Solve gaps and islands with LEAD, ROW_NUMBER, and GENERATE_SERIES, then apply the same date patterns to missing days and login streaks.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Error: Fix: Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.) – Part 2
A reader got error message 5133, Directory lookup for the file failed, while running a plain CREATE DATABASE with no path. Here is what caused it.
Insufficient System Memory: Msg 701 in a Resource Pool
Msg 701 reports insufficient system memory in a resource pool. This post reproduces it safely with a memory-optimized table on SQL Server 2025, shows the second message you get when the rows fill the pool, and lists the fixes that worked.
Interview Question of the Week #004 – List All Columns and Their Data Type for a View
Inspect a view’s columns and their data type with SQL Server catalogs, result-set metadata, and checks for stale view definitions.
Bind Resource Governor to a Memory-Optimized Database
To bind Resource Governor to a memory-optimized database, you create a pool, bind it with one stored procedure and restart the database. This post runs each step on SQL Server 2025, proves the binding with the pool memory, and restores the server.
SQL SERVER – Who is Consuming my TempDB Now?
Temp tables, cursors, sorts and row versioning all use TempDB. Here is the script I use to find who is consuming my TempDB right now.
SQL SERVER – The DBA goes to MARS – Maintenance, Architecture, Research and Support – Notes from the Field #063
Stuart Ainsworth tells a captivating story on why the DBA goes to MARS: Maintenance, Architecture, Research and Support, the proactive side of the job.
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.