Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Automation Rss

Search for any content tagged automation

   Items 1 to 20 of 34    Older >>
 

How to Run Scheduled Jobs in Azure SQL Databases

This article will help you to schedule jobs in Azure SQL.  Read more...
By Daniel Calbimonte 2016/08/01 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 738 reads

The Enterprise DBA Mindset as a Practical Problem-solving Approach

In order to keep the demands of the job under control, any DBA needs to automate as many as possible of the suitable tasks that their role demands. What makes a task suitable? How do you judge whether it is worthwhile? Can we take a 'managed', consistent, decision? Joshua Feierman explains the practicalities with a real example.  Read more...
By Additional Articles 2016/06/02 | Source: SimpleTalk | Category: automation
Rating:  Rate this |   Briefcase | 6,029 reads

Saving Time Through Automation

Steve Jones notes we should be automating where we can.  Read more...
By Steve Jones 2016/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

Free Webinar: Can you Automate your Ops Away?

Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!  Read more...
By Additional Articles 2015/06/29 (first published: 2015/06/26) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,990 reads

Free Webinar: Can you Automate your Ops Away?

Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!  Read more...
By Additional Articles 2015/06/29 (first published: 2015/06/26) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,990 reads

Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow

If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.  Read more...
By Additional Articles 2015/05/15 | Source: ITKnowledge Exchange | Category: automation
Rating:  Rate this |   Briefcase | 8,574 reads

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 | 5,308 reads

Database Build Automation – The First Step to Continuous Integration

So you're keen to take the first steps to the continuous integration of your database. You have to start by getting your database into source control. You can then begin to automate your build processes in order to generate and test a database. By doing this regularly, you'll be much better prepared for the deployment process because you'll have solved integration issues when they happen, and facilitated the broader testing process.  Read more...
By Additional Articles 2014/12/30 | Source: SimpleTalk | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 9,632 reads

Runbooks in SQL Azure

SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud” enabling automation of time consuming, repetitive tasks.  Read more...
By Paul Hebhardt 2014/12/02 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 2,925 reads

Database Configuration Management for SQL Server

It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention and management of configuration information. Configuration information is also essential for audit, resilience, and support. The range of documentation varies widely with the database and its setting, but the underlying principles remain the same. Without appropriate configuration management, automation is likely to be futile.  Read more...
By Additional Articles 2014/11/12 | Source: SimpleTalk | Category: configuration files
Rating:  Rate this |   Briefcase | 10,355 reads

Automating Red Gate SQL Compare with MSSQL Server Agent

How to compare two databases and email the results to every one who needs to know  Read more...
By Neil Burton 2014/10/29 | Source: SQLServerCentral.com | Category: redgate software
Rating: |  Discuss |   Briefcase | 1,235 reads

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,800 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 | 214 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,822 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,802 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,686 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,358 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 | 3,148 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 Sioban Krzywicki 2013/04/25 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 5,135 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,473 reads
   Items 1 to 20 of 34    Older >>