A backup without a full path suddenly failed with Msg 3047: the BackupDirectory registry key is not configured correctly. Here is why and how I fixed it.
SQL SERVER – Performance Benefit of Using SPARSE Columns?
What is the performance benefit of using SPARSE columns? From a SaaS consulting assignment, here are the considerations I shared with the developers.
SQL SERVER – Error: Property BackupDirectory is Not Available for Settings
Opening Restore in SSMS gave ‘Property BackupDirectory is not available for Settings’. I used a Profiler trace to find where it comes from and fixed it.
SQL SERVER – Unable to Start Services After Patching (sqlagent_msdb_upgrade.sql)
Unable to start services after patching? The ERRORLOG pointed to sqlagent_msdb_upgrade.sql failing. Here is what caused it for my client and the fix.
SQL SERVER – Fix: The Cluster Resource Could not be Deleted Since it is a Core Resource
After changing a file share witness, a client could not delete the old one: the cluster resource could not be deleted since it is a core resource. The fix.
Why ’10’ + 5 Returns 15: Mixing Strings and Numbers
The plus sign adds or glues text depending on the types on each side. I show the surprise, the error 245 it can cause, and how text keys get hurt.
SQL SERVER – Fix Error Msg 35336 Working with ColumnStore Indexes
A bank moving from SQL Server 2012 to 2016 wanted to use non-clustered ColumnStore indexes. Here is the error Msg 35336 we hit and how to fix it.