Create login with SID to keep SQL logins in sync on a secondary server, so users connect after log shipping, AlwaysOn or mirroring failover.
Forced Parameterization: When It Cuts CPU and When It Hurts
Test forced parameterization against ad hoc compile pressure with query_hash counts, compilations per second, CPU, and parameter sensitivity.
SQL SERVER – Walking the Table Hierarchy in Microsoft SQL Server Database – Notes from the Field #076
Kevin Hazzard shows how to walk the table hierarchy in a SQL Server database using the catalog, so you know the right order to load or clear tables.
SQL SERVER – Finding What Policies Are Enabled on Our Databases
A reader asked how to know which policy is enabled on a server. I explain how the policy engine uses target sets, then query what policies are enabled.
SQL SERVER – Script – Removing Multiple Databases from Log Shipping
Removing multiple databases from log shipping in SSMS takes many clicks per database. Here is a script that calls the log shipping stored procedures instead.
SQL SERVER – Is XP_CMDSHELL Enabled on the Server?
Is XP_CMDSHELL enabled on your server? I recommend avoiding it for security. Here are two ways to check and turn it off, starting with T-SQL.
Interview Question of the Week #015 – How to Move TempDB to Different Drive
Move tempdb files using sys.master_files and ALTER DATABASE, prepare Windows folders, restart SQL Server, and diagnose a full log first.
SQL SERVER – CONCAT function and NULL values
The CONCAT function and NULL values: CONCAT in SQL Server 2012 simply ignores NULL, while the + operator returns NULL. Here is a simple example.
SQL SERVER – The Basics of the File System Task – Part 2 – Notes from the Field #075
Andy Leonard returns with part 2 on the basics of the File System Task in SSIS, useful whenever your data moves to and from flat files.










