Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Automation Rss

   Items 1 to 6 of 6   
 

Collect Data from Multiple Instances Using SSIS and Powershell

Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.  Read more...
By S. Kusen 2015/02/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,695 reads

Automate Your Central Management Server Registrations

Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.  Read more...
By S. Kusen 2014/08/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,645 reads

Automate drive space monitoring for all production servers

Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it   Read more...
By Roshan Joe Joseph 2011/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,816 reads

Exec scripts in a group of databases

Easily execute your scripts in a set of databases  Read more...
By William Talada 2009/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,007 reads

Automate drive space monitoring for all production servers

Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it   Read more...
By Roshan Joe Joseph 2011/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,816 reads

Locate specific columns used in procs

SP to find object and line number that references column(s) of interest.  Read more...
By Damien Alvarado 2008/01/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 989 reads
   Items 1 to 6 of 6   
 
Tags
central management server (cms) (1)    
cms (1)    
data flow (1)    
data gathering (1)    
integration services (ssis) (1)    
maintenance (1)    
powershell (1)    
templates (1)