SQL 2016
SQL Server leverages MSDTC for distributed transactions (begin distributed transaction, remote proc trans, etc.)
I can’t emphasize this patch enough. There is a MSVC, runtime library patch needed
This blog takes you through the debugging journey, refreshing us on old concepts and
When we released Always On Availability Groups in SQL Server 2012 as a new
Database Instant File Initialization was added several SQL Server releases ago. The instant file
SQL Server uses WriteFileGather for the vast majority of data file write requests. The
When creating or growing the database log file (LDF) a byte pattern is stamped.
SQL Server 2016 introduces multiple log writer workers to the engine. For many
Spatial data is among, if not the fastest, growing storage types for the SQL
The SOS_RWLock is a synchronization primitive used in various places throughout the SQL Server