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 – Login Failed For User – Reason Server is in Script Upgrade Mode
Login failed for user because the server is in script upgrade mode? It happens after patching while upgrade scripts run. Here is what it means and what to do.
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.