Tired of typing WITH COMPRESSION on every backup? Here is how to Enable Backup Compression on by default for the whole SQL Server instance.
Building a Data Dictionary Query From Extended Properties
A plain join quietly hides every column nobody described. See the LEFT JOIN that keeps them, and turn the gaps into a to-do list.
SQL SERVER – What Are Ghost Records and How to Clean Them Up?
Ghost Records are logically deleted index records waiting for physical cleanup. I investigate their context before recommending an intervention.
SQL SERVER – Simple Explanation of AT TIME ZONE Feature
The AT TIME ZONE feature arrived in SQL Server 2016. Here is a simple two-step example that converts US East Coast time to West Coast time.
SQL SERVER – The Operating System Returned the Error 21(The Device is Not Ready.) While Attempting ‘GetDiskFreeSpace’ on ‘A:\’
While testing SQL Server 2017, I found Error 21 (the device is not ready) in the ERRORLOG for GetDiskFreeSpace on drive A. Here is why it shows up.
SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives
SQL Server 2017 adds sys.dm_os_enumerate_fixed_drives, a new DMV that shows free space on each drive and replaces xp_fixeddrives. Here is the query I use.
SQL SERVER – FIX: Msg 5123, Level 16 – CREATE FILE Encountered Operating System Error 5
This blog is about another common error reported by many DBA to me. He faced error related to create file in OS.
Here is the text of the message.