After applying STIG to SQL Server 2016, SSMS said accessing this server via SQL Management Objects (SMO) is not permitted. Here is the cause and the fix.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Unable to Launch SSMS Error – Cannot Find One or More Components. Please Reinstall the Application
I had SSMS 17.1 installed on the machine and it was working fine. I don’t remember what I installed, but I started facing an SSMS error.
SQL SERVER – Msg 3743: The Database is Enabled for Database Mirroring. Database Mirroring Must be Removed Before you Drop the Database
Msg 3743 says the database is enabled for database mirroring, and mirroring must be removed before you drop it. Here is how my client got past it.
Building Demo Data With GENERATE_SERIES
Build demo data with GENERATE_SERIES, weighted categories, customer skew, random amounts, and validation that preserves repeatable tests.
When to Use IDENT_CURRENT? – Interview Question of the Week #150
When should you use IDENT_CURRENT instead of SCOPE_IDENTITY()? A question I heard at the Group By conference, answered with the key difference.
SQL SERVER – Backup to URL error: Operating system error 50(The request is not supported.)
Backing up a database to Azure gave me a backup to URL error: Operating system error 50, the request is not supported. Here is the cause and the fix.
SQL SERVER – Execution Failed. See the Maintenance Plan and SQL Server Agent Job History Logs for Details
My client ran a new Maintenance plan for full and log backups and it failed at once. The reason was two subplans in one plan. Here is how to run them.
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.