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.
Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?
Compare primary keys and unique key constraints in SQL Server, including NULL rules, foreign keys, and filtered unique indexes.
Buffer Pool Extension and In-Memory OLTP: What Each One Caches
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 – 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.










