Related Forum thread: http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/719ede23-9f1a-43f5-8c4e-8188fea0b19f/ Related Connect feedback: https://connect.microsoft.com/SQLServer/feedback/details/768743/sql-server-2012-import-module-sqlps-breaks-the-test-path-powershell-cmdlet Issue...

Sample code to run query against multiple SQL Servers and export the combined output to Excel. This generated excel file is later sent as email attachment using hotmail. Related email thread: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/987d48c0-a82d-4424-8699-cdd0b2bc9c51 ...

http://blogs.msdn.com/b/sqlagent/archive/2010/12/29/starting-jobs-in-powershell-using-job-name.aspx This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

One of our customer was looking for ways to schedule a policy evaluation on multiple servers using their existing MSX/TSX infrastructure. I thought it would be better to blog an article that could help others looking for similar information http://blogs.msdn.com/b/sqlagent/archive/2010/11/19/scheduled...

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

########################################################################################### # SQL 2008 powershell script to print Resource Governor state, properties, Resource pools and corresponding workload groups # # How to use this powershell script: # - Launch SQL Server Management Studio ( Start...

########################################################### # 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 Server 2008 # 2) Run SQL PowerShell ( Start...

########################################################################################### # 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 data files and sets Autogrowth by 10% # # How...

a) Install SQL Server 2008. b) Launch SQL Server Management Studio ( Start -> All Programs -> Microsoft SQL Server 2008 -> SQL Server Management Studio) c) Connect to SQL Server instance, Right click on the server node in Object Explorer and click on "Start Power Shell" menu d) Get...