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

Content with tag Automation Rss

   Items 1 to 20 of 43    Older >>
 

Data Mining: Part 16 Automating Data Mining Processes

In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.  Read more...
By Daniel Calbimonte 2014/09/08 | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 2,158 reads

Artist or Scientist?

In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?  Read more...
By Steve Jones 2014/08/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 207 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,296 reads

Create MERGE statements with data!

A script to create MERGE statements with data for specific tables.  Read more...
By Jason Selburg 2014/07/16 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 2,863 reads

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 | 11,010 reads

Script to Detach All User Databases

The script will automatically detach all databases. Please run sp_helpdb to find out the location of all data and log files before using the script.  Read more...
By Patrick Akhamie 2014/06/26 | Source: SQLServerCentral.com | Category: detach database
Rating: (not yet rated) |  Discuss |   Briefcase | 699 reads

Setting up Automation in Azure

As I’ve started digging deeper into using Azure the need to automate tasks (turn off all VMs, turn on all...  Read more...
By Devin Knight 2014/06/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,321 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,485 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,059 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,952 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,089 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,135 reads

Automate Test Database Restoration

Automate test database restorations from your production system.  Read more...
By Mike Kober 2013/04/05 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,577 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,975 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...
By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,561 reads

Run SQL Hosted VBS Script from SQL

This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.  Read more...
By John Bevan 2012/09/20 | Source: SQLServerCentral.com | Category: script
Rating: (not yet rated) |  Discuss |   Briefcase | 910 reads

Insertion Query Creation of a Table in Milliseconds

This script helps you to constitute insertion procedures for tables in a millisecond.  Read more...
By emreguldogan 2012/08/30 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 2,284 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,792 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2012/01/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,650 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,103 reads
   Items 1 to 20 of 43    Older >>
 
Tags
t-sql (6)    
administration (4)    
backup / restore (3)    
indexing (3)    
job (3)    
scripting (3)    
deployment (2)    
editorial (2)    
integration services (ssis) (2)    
maintenance (2)    
monitoring (2)    
agent (1)    
alerts (1)    
auto create sql (1)    
azure (1)    
backup (1)    
blogs (1)    
career (1)    
central management server (1)    
changing (1)    
cms (1)    
create index (1)    
data (1)    
data mining (1)    
data synchronization (1)    
delete backup files (1)    
deployment process (1)    
deployments (1)    
detach database (1)    
development (1)    
file growth (1)    
jobs (1)    
merge (1)    
microsoft (1)    
multiple (1)    
partition tables (1)    
permissions (1)    
post-deploy (1)    
powershell (1)    
restore (1)    
schedule (1)    
scheduling (1)    
script (1)    
security (1)    
sql startup parameters (1)    
sqlcmd mode (1)    
ssdt (1)    
ssms (1)    
stored procedures (1)    
table (1)    
templates (1)    
vbs (1)    
vbscript (1)