SQL Server would not start due to a corrupted model database with error 5125. Here is how to restore a corrupted model database from backup the right way.
SQL SERVER – Security Considerations for Contained Databases
Security considerations for contained databases: how contained authentication works, the initial catalog it needs, and the fallback to server logins.
SQL Server Scheduler and Operating System Scheduling: Notes
The SQL Server scheduler decides which ready work gets processor time, on top of the operating system’s own thread scheduling. Tested queries on SQL Server 2025 show runnable, running and suspended tasks under load, and the permission each view needs.
Putting a Database Under Source Control
Putting a database under source control starts with state or migration scripts, consistent object files, and a reviewable first commit.
Volunteering in the Data Community
Volunteering in the data community can mean welcoming people, reviewing talks, answering questions, or organizing events within a clear time budget.
Hey DBA – Do You Study Mistakes? – Notes from the Field #097
A scare with a chainsaw got Mike Walsh thinking. In Notes from the Field #097, he explains why DBAs should study their mistakes and learn from each one.
SQL SERVER – Column Alias and Usage in Where Clause
You can ORDER BY a column alias, so why not use it in WHERE? A simple example that shows how SQL Server assigns a Column Alias and where it is in scope.