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.
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.
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 come close to discussing the whole topic here but like I said, it’s an excellent start that takes you past the basics of the right-click.
Here's the vid.