Buffer Pool Extension caches clean pages of disk-based tables on an SSD. Memory-optimized tables have no pages, so it cannot hold them. This post proves it on SQL Server 2025 with two tables and read-only checks.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – ReadOnly Databases with ReadOnly File Attribute
A reader attached a database that came up ReadOnly and would not switch to ReadWrite. Here is how the ReadOnly file attribute causes it, with repro steps.
SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070
Tim Mitchell explains how using raw files in SSIS helps when data cannot simply be processed on the fly in a single data flow pipeline.
SQL SERVER – Database Stuck in “In Recovery” Mode After Restart
Is your database stuck In Recovery after a SQL Server restart? I explain the analysis, roll forward and rollback phases and what you can do meanwhile.
SQL SERVER – Security Conversations and Notes with a DBA
At a Pluralsight booth, a DBA from the banking world asked me many SQL Server security questions. Here are my notes from those security conversations.
SQL SERVER – Converting YYYYDDD Ordinal Date Codes Safely
This Julian date example uses an ordinal YYYYDDD code. I distinguish that business encoding from an astronomical Julian day number.
Interview Question of the Week #009 – Is GO T-SQL Statement?
Explain GO T-SQL confusion with batch boundaries, GO repetition, variable scope, semicolon errors, and a procedure creation example.
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.