DATEPART and DATENAME accept a string that holds only a time and fill in the missing date as January 1, 1900. This post keeps the quiz, runs every query on SQL Server 2025 and explains which of the five bonus queries work and why.
SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups
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.
SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location
When readers report a strange error, I first ask for the SQL Server ERRORLOG. Here are the various ways to find the ERRORLOG Location on your server.
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.
SQL SERVER – Backup on mapped drive failing with error – Error 3201, Level 16, State 1
Backup on a mapped drive failing with Error 3201? The SQL Server service does not see the drive you mapped in Windows. Here is why, and what to do.
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.