The Multifunctioning DBA:

MSSQL


June 26, 2009  5:46 PM

Finding what account a Service is running as



Posted by: Colin Smith
Database Administration, MSSQL, Powershell, Services

Yesterday my boss came to me asking if I knew what server an account was running on. I know that the account is used as a SQL Server service account because of the naming convention that was used. I also know that the account is being used as I used the Quest Software cmdlet get-qaduser to query AD...

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...


June 25, 2009  3:30 PM

SQL Server Health Report



Posted by: Colin Smith
Microsoft, Monitoring, MSSQL, Powershell, Reporting, SQL Server

Yesterday I posted about a great article that I found on how to use Powershell to create an excel file and also use SMO to get information about SQL Server. I am working on a report that I will have run daily. This report is going to give me an overall health check of my SQL Servers. I am going to...


June 23, 2009  7:54 PM

Powershell and SQL Server



Posted by: Colin Smith
MSSQL, Powershell, Reporting, SQL Server

Today I wanted to use Powershell to create a report about my SQL Servers. I found a great article about how to do this using Excel at this link. http://www.mssqltips.com/tip.asp?tip=1759.  the author does a great job here and has a great sample script that you can start with and then modify as you...


May 29, 2009  2:49 PM

Powershell SQL Load Script



Posted by: Colin Smith
Database Administration, MSSQL, Powershell, Scripting, SQL

In my environment we have some servers, test servers, that are loaded from the Production Servers on a regular basis. Since this is the case I have decided that I would like to attempt to script this. I just started but I am already well on my way to getting this done. I am pretty sure that I will...


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: