How do you do a case sensitive search in SQL Server? Use COLLATE Latin1_General_CS_AS in the query, or change the column collation to make it permanent.
SQL SERVER – Installation Failed With Error – Wait on the Database Engine Recovery Handle Failed
I ran SQL Server setup on a domain controller by mistake, and the Installation Failed at ‘Wait on the Database Engine recovery handle’. Here is what fixed it.
SQL SERVER – Backup to Azure Blob error – The remote server returned an error: (409) Conflict
My backup to Azure Blob started failing with The remote server returned an error: (409) Conflict. Here is what the ERRORLOG showed and what it means.
Frame Your Week: Why a Weekly Review Beats a Daily To-Do List
A weekly review beats a daily to-do list because it shows seven days of work at once. This post borrows the rolling window from SQL to show how to look back, look ahead and choose up to four outcomes. It ends with a checklist you can try this week.
SQL SERVER – What is SQL Server Operating System?
What is the SQL Server Operating System, or SQLOS? An attendee spotted SOS waits after reading my wait stats book, and here is my simple explanation.
SQL SERVER – Understanding SQL Server Setup Support Rules for Cluster Nodes
What do the SQL Server setup support rules check when you build a cluster? My notes on the 11 Cluster Global Rules, and which ones are critical or optional.
SQL SERVER – Save and Send Execution Plan Via Email
A reader wanted to send a big graphical execution plan via email to a friend. Here is a quick step by step way to save it, and what to do if it is over 20 MB.