Which SQL Server edition do you need? Express, Developer, Standard and Enterprise compared in plain terms, plus the licensing trap where a free Developer Edition quietly ends up running the business.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Unstable Queries: Finding Wide Duration Swings in Query Store
Find unstable queries with Query Store duration spread, weight averages, and separate plan changes from waits and parameter effects.
MySQL – How to Create Stored Procedure in MySQL
MySQL supports stored procedures for your business logic. Here is how to create a stored procedure in MySQL and execute it, with a simple sales example.
SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026
I was once corrected on Page Life Expectancy. Here my friend Tim Radney explains in simple words what a good value for Page Life Expectancy really is.
SQL SERVER – Synchronize Data Exclusively with T-SQL
Many tools sync data between databases. Here I build the functionality to synchronize data exclusively with T-SQL, step by step, from structure to triggers.
SQL SERVER – Faster Application Performance with In-Memory OLTP
How in-memory OLTP engines give faster application performance and better scalability for SQL Server databases, with a focus on SQL Server 2014.
Signal Waits: Telling CPU Pressure From Slow Disks
Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.
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.