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.
Append-Only Ledger Tables for Audit Logs That Cannot Be Edited
Can someone quietly edit your audit table? With an append-only ledger and a stored digest, the answer becomes no, and you can prove it.