A DBA asked whether backups on new EMC storage should use a 256 KB transfer size. Here is what I learned about the MaxTransferSize parameter.
Interview Question of the Week #012 – Steps to Restore Bak File to Database
Restore bak file backups safely with header and file inspection, complete Windows paths, conditional access changes, and recovery options.
Add a User Across Databases: A Tested Script With Cleanup
To add a user across databases you need one login and, in every chosen database, a user and a role. This post gives a tested script that does it, checks it and removes it again on SQL Server 2025. It also answers the model database question and shows the server-level shortcut.
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.







