The Multifunctioning DBA:



August 21, 2012  4:29 PM

Powershell to get DB Role Members Report into Excel

Posted by: Colin Smith
Database, Excel, Powershell

Recently I had an application support group ask if I could get a report of all the members of the database roles that the application uses. I thought about it and, you know me, I thought, POWERSHELL!! Of course I can do that, I will get you a spreadsheet with that data as soon as I can. Off to...

June 25, 2009  9:24 PM

PowerShell SQL Server Health Check Script

Posted by: Colin Smith
Excel, Monitoring, MSSQL, Powershell, SQL Server

OK so I think that I have everything I want in my script to check on the health of my SQL Servers. I will run this at least once a day and more if needed. I hope that this will help some people out and if you have any questions, comments, or ideas of what else might be good to include please let me...


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: