My new online course is now up and available: Understanding Data Compression in SQL Server. This course is almost 1.5 hours long and covers the technical details of how Data Compression in SQL Server works and when and how to implement it. The course includes demo scripts and examples. From now until December 31, 2013, […]
You are an awesome DBA. You have complete control over your dominion. You have all your backups automated and the testing of those backups is automated. You have alerts properly configured on all your servers. You have your index maintenance plans running regularly. You ride a unicorn to the office and George Hamilton asks you […]
Note: For more details about this script and the variables and outputs, see my post here. I’ve made two changes to my script that checks for new database objects to compress. First, it will now enclose table and index names in square brackets to prevent errors with object names that are also keywords or include […]
I found a bug in SSMS that you may run into when modifying multi-step jobs. If you delete the last step of a job, when you click OK, you will get a pop up saying the On Success action of the (new) last step will be changed from “Go to the next step” to “Quit […]
SSIS packages are handy. They can do all sorts of things and the developers here use them a lot. One very useful feature is that you can set up connection objects in your package so it can connect to any of your servers to do what it needs to do. This is also one of […]