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.
Msg 864: Buffer Pool Extension Size Over the Limit
Msg 864 means a buffer pool extension file is larger than SQL Server allows for the memory in the machine. This post gives the limits, four read-only checks tested on SQL Server 2025, and the steps to start a server that will not boot.
SQL SERVER – ReadOnly Databases and Notes Using Snapshots
Can you get the ReadOnly error without marking the database ReadOnly? Yes, using snapshots. Here is a script that shows the behavior step by step.