Analysis, Reporting and Integration Services were missing from the Features page while installing SQL Server. The cause was missing MSI files in my setup media.
SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account
After I changed the SQL Server service account in my lab, the Always On secondary replica went disconnected. Here is why the endpoint rejects the new account.
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Files kept vanishing from a client’s SQL Server Binn folder. SQL Server cannot track that, so here is how to enable Files and Folders Level Auditing in Windows.
SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction
A client’s SQL Server 2016 Installation in Cluster hung at RunRemoteDiscoveryAction while setup ran discovery on the other node. Here is the cause of the delay.
SQL SERVER – Upgrade Error – Upgrading Subscription Settings and System Objects in Database [DBName].
A patch failed at “Upgrading subscription settings and system objects in database” with invalid object MSreplication_subscriptions. Here is the fix.
SQL SERVER – Unable to Failover SQL Server Instance – Error: Registry Information is Corrupt or Missing
A client could not failover SQL Server to another node: registry information is corrupt or missing. Here is how I found the right error in the logs.
How to Write Errors in Error Log? – Interview Question of the Week #175
How to write errors in Error Log? A customer asked this in my performance tuning workshop, and here is how to add your own messages to the SQL Server log.