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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Upgrading Subscription Settings and System Objects Error in SQL Server Upgrade
Upgrading subscription settings is an upgrade step, and in this 2018 client case it failed on a missing replication table. This post shows tested queries for replication flags and the Distributor, how the Msg 208 for the missing table looks, and what the original fix with sp_removedbreplication did and did not touch.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.