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

Articles with tag Automation Rss

Search for any content tagged automation

   Items 1 to 20 of 20   
 

Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)

This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS.   Read more...
By Additional Articles 2014/07/16 | Source: MSSQLTips.com | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 10,326 reads

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.  Read more...
By Sujeet Singh 2014/04/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 5,422 reads

Five Tips to Get Your Organisation Releasing Software Frequently

The frequency of releasing software varies widely in the industry. If the test and release process is made as reliable and predictable as possible, then everyone gains. But how do you get started?   Read more...
By Additional Articles 2014/02/03 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,035 reads

Automation: Changing SQL Service Startup Parameters using T-SQL

Quick and efficent way to change SQL service startup parameters for 1000 instances!  Read more...
By Shaunt Khalatian 2013/12/19 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 2,896 reads

Find the Currently Running Scheduled Job

Ever need to automatically stop a long running job? Ever need to find which named Schedule is the currently running version of your job? There's simple code that'll let you find out.  Read more...
By Stefan Krzywicki 2013/04/25 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 5,070 reads

Automating SQL Server Database Deployments: A Worked Example

Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it through three steps by writing T-SQL scripts, adjusting configuration files and the change log, before generating a full build script containing all schema objects.  Read more...
By Additional Articles 2013/04/09 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 3,116 reads

Automatically Generate Stored Procedures

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database  Read more...
By James Skipwith 2013/01/01 (first published: 2011/02/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,953 reads

Managing Database Data Usage With Custom Space Alerts

A quick how-to on configuring SQL Server Agent alerts to manage file space usage.  Read more...
By Simon Richards 2012/05/30 | Source: SQLServerCentral.com | Category: alerts
Rating: |  Discuss |   Briefcase | 6,629 reads

A Simple way of Automating Scripts

Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.  Read more...
By Sadequl Hussain 2011/12/30 (first published: 2009/07/30) | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 37,075 reads

Automatically Scripting Out Permissions for Cross Environment Restores

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...
By Warren Campbell 2011/12/05 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 4,843 reads

The Robot DBA

Steve Jones talks about the idea of an automated DBA and disputes the notion that it will come to pass anytime soon.  Read more...
By Steve Jones 2011/09/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 180 reads

SQL Overview SSIS Package II - Retrieving SQL Error Log

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...
By David Bird 2011/07/08 (first published: 2008/01/14) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 17,405 reads

SQL Overview Part 1

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...
By David Bird 2011/07/01 (first published: 2008/01/07) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 26,129 reads

Automatically Generate Stored Procedures

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database  Read more...
By James Skipwith 2013/01/01 (first published: 2011/02/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,953 reads

A Simple way of Automating Scripts

Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.  Read more...
By Sadequl Hussain 2011/12/30 (first published: 2009/07/30) | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 37,075 reads

Multi-Script, Multi-DB Deployments

A way to handle application releases involving multiple scripts and/or multiple databases.  Read more...
By S. Kusen 2010/08/23 | Source: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |   Briefcase | 5,822 reads

A Simple way of Automating Scripts

Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.  Read more...
By Sadequl Hussain 2011/12/30 (first published: 2009/07/30) | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 37,075 reads

Using the FORFILES Command to Delete SQL Server Backups

Is there a way I can automate a file deletion process from within SQL Server?  Read more...
By Additional Articles 2008/11/11 | Source: MSSQLTips.com | Category: backup / restore
Rating:  Rate this |   Briefcase | 4,114 reads

SQL Overview SSIS Package II - Retrieving SQL Error Log

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...
By David Bird 2011/07/08 (first published: 2008/01/14) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 17,405 reads

SQL Overview Part 1

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...
By David Bird 2011/07/01 (first published: 2008/01/07) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 26,129 reads
   Items 1 to 20 of 20