There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SSIS packages so you can start to record some of this information. Your packages will be more supportable, easier to update, and you’ll take hours or sometimes days off of a re-design or support effort. […]
Category: Uncategorized
Grant DB Permissions in Powershell
This is a beautiful bit of script that allows you to set DB permissions for a user. This is particularly useful for adding a user to multiple DBs on the server. And the code to accomplish this is much shorter than its T-SQL counterpart. If you need a bit more explanation about how this is […]
Compression Basics
I’m going over the basics of how to implement data compression here. I’m not really touching on where and why you’d want to do it, but how to once you’ve made the decision. Here’s the vid.