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.
SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts
You cannot back up SQL Server 2017 and restore it on SQL Server 2005. The workaround I used for a client: generate scripts in SSMS and run them on the old server.