From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Automation strategies

Automation strategies - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Automation strategies

“

- [Instructor] At some point in the development cycle of a database, it's going to become apparent that manually initiating every command and process is not going to be a viable solution for very long. You'll eventually need to turn to an automatic solution and have the server start to perform actions by itself, either on a schedule or in response to some sort of triggering events. SQL Server 2016 provides a number of ways to automate the process of maintaining the database and the server instance. So let's take a look at some of the options that deserve your consideration, starting at the OS level. The first is one that was mentioned earlier in the course. Microsoft PowerShell includes an interactive command prompt, and an integrated scripting environment for creating batches of commands that can be triggered manually or on a schedule and easily shared with others. PowerShell uses a series of built in cmdlets that can be used for both the interactive and the scripting environments…

Contents