A reader hardcoded 1 GB in my log shrink script and got: Cannot shrink file in database to xxxx pages as it only contains yyyy pages. I explain why it appears.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Error 21028 : Replication Components are not Installed on This Server
After I set up AlwaysOn for a client, configuring replication failed: Replication components are not installed on this server. Here is how to fix error 21028.
How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204
How do you create an empty table and fool the optimizer into thinking it has data? Nobody asked me that in 20 years, but I use this trick in Health Checks.
SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server
Dropping a linked server with sp_dropserver failed with Msg 15190: There are still remote logins or linked logins for the server. Here is how to clear them.
SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database databasename. CREATE DATABASE is aborted
My 2007 post on Msg 1813, Could not open new database, is still popular. SQL Server expert Jeremy Roe sent an updated script for newer versions of SQL Server.
SQL SERVER – Error: Parameter ‘ProbePort’ does not exist on the cluster object. Unable to set Probe Port for Azure Load Balancer
Setting up an Always On listener with an Azure Load Balancer, I hit: Parameter ‘ProbePort’ does not exist on the cluster object. Here is what fixed it for me.
Diagnosing Blocking Chains With sys.dm_exec_requests
Trace blocking chains from active requests to a candidate head session, inspect sleeping transactions, and verify the owner before action.
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.