Create login with SID to keep SQL logins in sync on a secondary server, so users connect after log shipping, AlwaysOn or mirroring failover.
SQL SERVER – 3 Common Mistakes of Agile Development – Notes from the Field #074
Agile builds software in small, time boxed steps. In Notes from the Field #074, Stuart Ainsworth shares stories about 3 common mistakes of Agile Development.
SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072
Reeves Smith explains why you should add Master Data Services to your enterprise and why data governance is often overlooked in data warehouse projects.
SQL SERVER – Marking Filegroup as ReadOnly with SQL Server
Readers asked how to mark a filegroup as ReadOnly. Here is a T-SQL script that creates a test database, adds a filegroup and marks it ReadOnly.
SQL SERVER – SCRIPT – SQL Listening on Dynamic Port?
How do you know if SQL Server is listening on a fixed or dynamic port? Here is a script that reads the TcpDynamicPorts registry value for your instance.
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 – 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.