Author: KenpoDBA

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 […]

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.

This is a really cool method for changing SQL job owners or any job property I would imagine.  It really simplifies it from using SQL syntax.  So learn this method and it’ll be your friend for years to come.  Here’s the vid.