Monthly Archives: December 2009

QuickBlog – PowerShell SMO using SQL Authentication…

Most of the time, I’ve been using Windows Authentication to do all my PowerShell SMO scripting on my Development and local machine .  Now, that I’m covering for our DBA, I have been given a SQL User-Id for monitoring jobs … Continue reading

Posted in Uncategorized | Leave a comment

PowerShell working with SQL Server Agent jobs

I’m going to demonstrate how simple is using PowerShell with SQL Server 2008 Provider and PSSnapins to work with SQL Server Agent jobs. I will cover the following areas: 1. Listing Jobs. 2. Starting jobs. 3. Monitoring Jobs. You will … Continue reading

Posted in Uncategorized | Leave a comment

Update PowerShell V1 to V2 – Windows Management Framework:

This article describes the Windows Management Framework on Windows XP, Windows Server 2003, Windows Vista, and Windows Server 2008. The Windows Management Framework includes the following: Windows Remote Management (WinRM) 2.0 Windows PowerShell 2.0 Background Intelligent Transfer Service (BITS) 4.0 … Continue reading

Posted in Uncategorized | Leave a comment

QuickBlog: Using PowerShell to Kill Databases Processes in SQL Server…

This is going to be fast.  I just got tired of doing the following step on my SSMS (SQL Server Management Studio): 1. Click on SQL Server Activity Monitor. 2. Expand “Processes”. 3. Click on the “Database” column. 4. In … Continue reading

Posted in Uncategorized | 1 Comment