As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...

The next SQL Server: Interview with Asad Khan of Microsoft Your email has been sent Learn about the latest features and future of SQL Server 2022 in this interview ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...