Write a reproducible script with minimal tables, synthetic rows, the failing query, expected results, and the exact SQL Server version.
SQL SERVER – Automatic Startup Not Working for SQL Server Service
After a power failure, a client’s SQL Server service stayed down even though it was set to Automatic. Here is why automatic startup can fail and what to check.
SQL SERVER – An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port
A student could not connect with the Dedicated Administrator Connection (DAC) after my class. Here is the port error he saw and how to fix it.
SQL SERVER – The Patch Installer has Failed to Update the Shared Features
Under a tight downtime window, a client got “The patch installer has failed to update the shared features”. Here is what the logs showed and how we fixed it.
SQL SERVER – FIX: Rule “Reporting Services Catalog Database File Existence” Failed
After a disaster, a client’s SQL Server setup failed the rule Reporting Services catalog database file existence. Here is why and how I got the install through.
SQL SERVER – Error: Timeout (30000 milliseconds) Waiting for the SQL Server (MSSQLSERVER) Service to Connect
Timeout 30000 milliseconds waiting for the SQL Server service to connect. Why the service start times out, what to check, and how to give it longer.
SQL SERVER – Upgrade Failure – The Cluster Resource is Not Online. Bring the Analysis Services Server Online Before Starting the Upgrade Process
Upgrade and one need to evaluate them before making a final choice. Let us see an error related to Upgrade Failure. Let us learn today.