Primary keys for an OLTP database

OLTP database performance with different clustered indexes.

Memory-Optimized Table Truncation

Logshipping to SQL Server on Linux

An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.

Disk space used by the SQL Server instance

I have found this query valuable. Sometimes you need to see just overall consumption without any detailed information. It is also useful in overall trend analysis and disk space planning.

Stretch Database limitations

SQL Server Transaction Log Architecture

Resumable online index rebuild

Restore databases on SQL Server 2017

Azure Elastic jobs

Learn the basics of Elastic Jobs on the Azure platform.

Offline R Services installation and patching

The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.