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

http://sethusrinivasan.wordpress.com/2011/12/19/sql-server-2012-unattended-installation/

http://sethusrinivasan.wordpress.com/2011/07/12/sql-server-denali-ctp3-on-windows-2008-r2-server-core/ This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified...

# serverList.txt has name of fully qualified sql instance ( one per line) # Example entries: # server1 # server1\instance1 $instanceNameList = Get-Content C:\ServerList.txt foreach ($instanceName in $instanceNameList...

SQL Agent jobs are added / removed using stored procedure interface sp_add_job and sp_delete_job. Customers have asked us how we could track user who has created a job / deleted a specific job. You could accomplish this using SQL Server Auditing feature...

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

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

Turning on Verbose logging in SQL Agent 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

SQL Server Management Studio can be used to create a database backup job to backup an user database. Link This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified...

SQL Agent development team members have started a blog to write articles related to SQL Agent, Database Mail, data collector. Please send us topics, areas you would like us author articles that you would be intersted in. Here is the link to SQl Agent...

Create SQL Agent job and enumerate this job using SMO JobCollection

...

changeSvcAcct.ps1 ########################################################################################### # Scenario:Change Service account for SQL Server, Agent services # # How to use this powershell script: # - Launch SQL Server PowerShell ( Start...

Problem: Management view sys.dm_exec_requests has a column total_elapsed_time to track the total time elapsed in milliseconds since the request arrived. Following T-SQL query converted this value from milli-seconds to micro-seconds. -- Simplified...

MultiServerQuery.ps1 # Scenario: Execute a query on servers listed in Central Managment Server Group # # How to use this powershell script: # - Launch SQL Server PowerShell ( Start -> Run -> sqlps.exe) # - Copy the following powershell script and...

EnableProtocols.ps1 ########################################################################################### # Scenario: Enable / Disable protocols in SQL Server # ( Thanks Michiel http://blogs.msdn.com/mwories/ for helping me out) # # How to use this...

########################################################################################### # 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 state, properties, Resource pools and corresponding workload groups # # How to use this powershell script...

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

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

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

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