Author: KenpoDBA

This is a really good video on how to use the RunAs utility in windows.  There are several scenarios when a DBA/Dev may need to logon to a program with separate credentials and this takes you a good way to getting there.  The process is simple, but it comes with some caveats.  I don’t even […]

Here I show you a couple methods for getting around really hard to read dynamic SQL. Here’s the vid.

Here I get past the basics of using the Script() method and take you to how to recreate some of the scripts you can create in SSMS by instantiating a scriptingOptions object and passing it to the method.  Here’s the vid.