Opening SQL Server Configuration Manager failed with: MMC could not create the snap-in. A reader on Facebook asked, and here is how to fix it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
What is NOT NULL Constraint? – Interview Question of the Week #073
A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.
SQL SERVER – Finding Waits For Any Session with Extended Event wait_info
It becomes a great win-win situation. Let us learn about Extended Event wait_info in this blog post. Do you think this script will be useful for you?
SQL Server – InMemory OLTP Hash Collisions Performance Overhead
A customer’s InMemory OLTP tables ran slowly because of a very low hash bucket count. Here is the hash collisions performance overhead and how to avoid it.
SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126
Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,
SQL SERVER – FIX: Error 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later – Part 2
Msg 1807, could not obtain exclusive lock on database ‘model’, still shows up in SQL Server 2016. Here is another cause of Error 1807 and how to fix it.
PowerShell – Querying SQL Server From Command Line
A client’s deployment scripts got me curious about PowerShell. Here is how to start querying SQL Server from the command line with a PowerShell script.
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.