SQL Server Configuration Manager gave error 0x80010108: The object invoked has disconnected from its clients. Here is one cause I could reproduce on demand.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
First Queries to Run on an Unfamiliar SQL Server
Inspect an unfamiliar SQL Server with read-only queries for version, uptime, database size, waits, backup history, and settings.
SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]
SQL Server Configuration Manager would not open on my VM: Cannot connect to WMI provider [0x80070422]. I share what caused it and how I fixed it.
How to STOP the Usage of SELECT * For Views? – Interview Question of the Week #193
How do you stop people from using SELECT * in views? A slow query in a Health Check came from SELECT * over a wide view, so here is one way to prevent it.
Checking Optional Features Installed on an Instance From T-SQL
A 1 in SERVERPROPERTY does not mean the feature runs. Here is how I line up the flag, the setting and the service in one query.
SQL Server – Formatted Date and Alias Name in ORDER BY Clause
Format a date with CONVERT, then use its alias in ORDER BY, and the rows come back in a different order. Here is a simple example of this formatted date surprise.
Asynchronous Statistics Updates: When They Help and When They Hurt
Evaluate asynchronous statistics updates against compile latency, data-change timing, and low-priority metadata locking in SQL Server.
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.