I recently had a very simple and interesting error received while I was performing an upgrade mode with Docker and Persistence Storage for my upcoming workshop.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
When Was SQL Server Last Restarted? – Interview Question of the Week #225
When was SQL Server last restarted? It is my first question in every Health Check, because a restart empties the DMVs and their performance history.
Docker Run Without Pull: Start SQL Server in One Command
Docker run without pull works because docker run downloads the image when it is not on your machine. This post shows how to check which images you already have and how the pull option changes the behavior. It also explains when an explicit pull is the better habit.
Columnstore Deleted Rows: When the Delete Bitmap Slows Scans
Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.
SQL SERVER – Stored Procedure sp_datatype_info to Get Supported Data Types
Forget which data types your SQL Server version supports? I run sp_datatype_info, which lists every supported type with precision, nullability and searchability.
SQL SERVER – Automatic Seeding of Availability Database ‘DB’ in Availability Group ‘AG’ Failed With an Unrecoverable Error
Automatic seeding of availability database failed with an unrecoverable error: it showed on the secondary, then vanished. Here is what ERRORLOG said.
Automatic Seeding in Always On: List and Monitor It
Automatic seeding in Always On lets the primary send a database to a secondary without a manual backup and restore. Three read-only queries show which replicas use it, what happened before and how far a seeding run has come. It also covers why it fails and when to switch it off.
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.