There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SPs so you can start to record some of this information. Your SPs will be more supportable, easier to update, and you’ll take hours or sometimes days off of a re-design or support effort. You won’t be sorry you started doing this.
Commenting Tribal Knowledge in SSIS Packages
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. You won’t be sorry you started doing this.
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 put together then look at the video for granting schema permissions with Powershell.