Andy Leonard explains the basics of the SSIS Execute Process Task, used to start a custom application or run an operating system command from a package.
Who Changed This Row? Auditing Data Changes
Auditing data changes requires choosing whether you need old values, new values, actor identity, or a change feed, then testing the cost.
SQL SERVER – Know Your Backup Before Deleting Database
Dropping a database in a demo is fine, but on production be careful. Here is how to know your backup before deleting database, so you can undo mistakes.
SQL SERVER – FIX: Msg 3102, Level 16, State 1 – RESTORE cannot process database ‘Name’ because it is in use by this session
Msg 3102 says RESTORE cannot process the database because it is in use by this session. The fix is simple: switch to master before you restore.
SQL SERVER – FIX – Error 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use
Error 3702 says you cannot drop the database because it is currently in use, and even speakers get stuck on it. Here are simple ways to get past it.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.
SQL SERVER – Finding Out Identity Column Without Using Column Name
Did you know SELECT $identity finds the identity column without using column name? Here is how it works, and how to check if a table has one.