Reeves Smith shows how to add reference data to Master Data Services with the MDS add-in for Excel, so the business can manage it themselves.
SQL SERVER – Create Login with SID – Way to Synchronize Logins on Secondary Server
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.
SQL SERVER – How to Add User Across Databases
Auditors needed read access to every database once a year. Here is the script I gave a DBA to add a user across databases on older versions of SQL Server.