When I guide a DBA over a screen share, line numbers make it easy to point at the right spot. Here is how to enable line numbers in SSMS.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Wide Covering Indexes: The Cost of INCLUDE Everything
Adding every column with INCLUDE feels like a free speed-up. Here is a small demo of the space, reads and writes you pay for.
Right-Sizing SQL Server: Reading CPU and Memory Use Before Consolidation
Base right-sizing SQL Server on sampled CPU, memory pressure, buffer use and interval I/O, then compare peaks across a full business cycle.
In-Memory OLTP Migration Checklist in SSMS: Step by Step
The In-Memory OLTP migration checklist shows which tables and stored procedures can move to memory-optimized objects. This post sizes up the tables with T-SQL, walks through the wizard in Management Studio and explains how to read the reports.
Alphabets – SQL SERVER – Retrieving Rows With All Alphabets From Alphanumeric Data
I got an email from one of my blog readers asking for an easy way to identify if a given string contains only alphabets. There can be methods.
SQL SERVER – Applying NOLOCK to Every Single Table in Select Statement – SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
READ UNCOMMITTED changes session read isolation without adding NOLOCK to every table. A workshop procedure made the distinction useful.
How to Move SQL Server MDF and LDF Files? – Interview Question of the Week #189
How do you move SQL Server MDF and LDF files? Detach and attach is the old way, so here is the step-by-step method I use for my clients today.
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.