SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals. Key areas of focus ...

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 ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

The big data odyssey of SQL Server 2019, and more data and AI news from Microsoft Ignite; Review: SQL Server 2017 adds Python, graph processing and runs on Linux; Links to Managed Instance and Synapse ...