After I set up AlwaysOn for a client, configuring replication failed: Replication components are not installed on this server. Here is how to fix error 21028.
How to Start Database in a Single User Mode? – Interview Question of the Week #202
How do you start a database in a single user mode when there is corruption? Here are simple steps in SQL Server Configuration Manager, one by one.
SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)
A client could not see the SQL Server Agent node, it was missing in SQL Server Management Studio. Here are the possible causes, starting with sysadmin rights.
SQL SERVER – Cluster Resource ‘AGName’ of type ‘SQL Server Availability Group’ in Clustered Role ‘AGName’ Failed
Configuring an availability group is easy; trouble starts when the cluster breaks. Here I fix a failed cluster resource of type SQL Server Availability Group.
SQL SERVER – Disable IntelliSense in SQL Server Management Studio
A client with over 350,000 tables in one database saw metadata locking every time SSMS opened. Disabling IntelliSense in SQL Server Management Studio fixed it.
SQL SERVER – SQL Server Management Studio Crash While Using Backup to URL or Connecting to Storage
During an urgent restore, SSMS crashed each time my client picked URL to restore from Azure Blob Storage. Here is how to fix the crash when connecting to storage.
How to Change Language for SSMS? – Interview Question of the Week #194
How do you change language for SSMS? A workshop attendee asked me and I had to research it, but the steps are simple and start in the Tools menu.