SQL Server Ledger – has taken data integrity to the next level, integrating blockchain-style data verification directly into the database.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Understanding the AUTO_DROP Option in SQL Server 2022
One such feature is the AUTO_DROP option for statistics. In this blog post, we’ll explore what the AUTO DROP option is, how it works.
FinOps Observability Fireside Chat: Elevating Database Management
FinOps Observability, the need for cost-efficient solutions in the database world is more critical than ever.
BULK INSERT Batch Size and ROWS_PER_BATCH
Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.
Why ‘Max Server Memory’ Isn’t Always the Limit
What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?
Logging Agent Jobs That Call Stored Procedures
Improve logging Agent jobs with procedure run records, start and end events, captured errors, step output, and history correlation.
Detailed Summary of “Selling the Invisible: A Field Guide to Modern Marketing” by Harry Beckwith
Let me tell you about a book that seriously changed the way I think about marketing services. It’s called “Selling the Invisible” by Harry Beckwith.
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.