Commenting Tribal Knowledge in SPs

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.

Here's the vid.

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.

Here's the vid.

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.

 Here's the vid.

Real news, real tech.