‘My SQL Server eats RAM and never gives it back’ is a common complaint. The SSMS Memory Consumption report shows where that memory goes and why.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – SSMS: Scheduler Health Report
Like a conductor at a concert, the scheduler makes sure every task in SQL Server gets its turn. Here is how the SSMS Scheduler Health Report shows its state.
Constant Folding: Expressions the Optimizer Solves Before Running
SQL Server does the math on your literals once, while it builds the plan. Here is where that helps, and where it quietly stops.
MySQL – How INSERT() Function Works for MySQL
MySQL has an INSERT() function that has nothing to do with adding rows. It replaces characters within a string at a given position. Here is how it works.
SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
What is Biml, and how can it help with SQL Server BI? Reeves Smith explains Business Intelligence Markup Language and how it adds automation to BI work.
Reading the Top Five Wait Types on Your Server
Top five wait types become useful when you filter background waits, measure changes over time, and connect them to active work.
SQL SERVER – Round Up From Notes from the Field of Blog Posts of Tim Radney
A round up of all the Notes from the Field posts by Tim Radney of Linchpin People, from finding the last backup to database file names.
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.