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.
What is a Backup Timeline for Restore Process? – Interview Question of the Week #092
Question: What is a Backup Timeline for Restore Process?
Answer: One of the most popular interview question about Backup and Restore Database process.
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.
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
While preparing my SQLPASS session on SQL Server 2016, I explored creating clustered ColumnStore with InMemory OLTP tables. Here is what I learned.
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.