The Multifunctioning DBA:

Scripts

1

August 17, 2012  12:00 PM

Powershell to Drop Procs



Posted by: Colin Smith
POSH, Powershell Tips, Scripting, Scripts, SQL Admin, SQL Administration, SQL Administration. MS SQL, SQL Server

I was asked by a developer if I could drop all the procs in a database except the ones that he knew were being used. I thought Powershell can do that. So I told him that I could if he provided me a list of the ones that he did not want to be droped. So he sent me a list and I got to work. I thought...

September 20, 2011  3:59 AM

Day One



Posted by: Colin Smith
Blog, Job, Scripts

Day one at the new job was a bit slow but I guess that is to be expected. Had to do a lot of paperwork and then get situated at my new desk, log into my new machine and start to figure out the new environment.  While I was doing that I found my own blog very useful. I downloaded some of my own...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: