Simplifying Life of SQL Server DBA

Configure Database Mirroring using SQL 2008 Power Shell

########################################################################################### # Scenario: Configure Database mirroring # # How to use this powershell script: # - Launch SQL Server PowerShell ( Start -> Run -> sqlps.exe) # - Copy the

SQL 2008 powershell script to print Resource Governor properties

########################################################################################### # SQL 2008 powershell script to print Resource Governor state, properties, Resource pools and corresponding workload groups # # How to use this powershell script:

SQL 2008 Powershell Script for creating a Policy and saving to file

########################################################### # SQL 2008 Powershell Script for Policy Based Management # Scenario: Create a server policy to check if XPCmdShell is disabled and save it to file # # To run this Powershell script # 1) Install

SQL Powershell - Unrestrict Growth size on all Database Files that has AutoGrowth set as None

########################################################################################### # Scenario: Unrestrict Growth size on all Database Files that has AutoGrowth set as None # The following SQL 2008 Powershell sample code enumerates all user database

SQL 2008 Power Shell script - Databases that were not backed up in last 7 days

a) Install SQL Server 2008. You can get RC0 from here: Download SQL 2008 RC0 b) Launch SQL Server Management Studio ( Start -> All Programs -> Microsoft SQL Server 2008 -> SQL Server Management Studio) c) Connect to SQL Server instance, Right