Session 2: Scripting Backups, Restores and ADO.NET Using SQL Server

RSS

Presented by: Allen White A walk through the process of scripting backups and restores for SQL Server, as well as doing index maintenance and database integrity checks. Then an introduction to accessing data in SQL Server via ADO.NET, and a closer look at accessing the data objects via SMO, exposing ways of managing SQL Server not practical via T-SQL.

Buy This On-Demand Training Now!

This video is part of the SQL Server Database Administration with PowerShell On Demand training.

This class will first introduce you to PowerShell, after which you'll learn the basic SMO object model, how to manipulate data with PowerShell, and how to use SMO to manage objects. We'll then move on to creating Policy-Based Management policies, working with the Central Management Server, managing your system inventory, and gathering performance data with PowerShell.

Already purchased this? to view your content.
Microsoft Stack Master Class

Master-Level Microsoft Stack Class with John Savill
Online Class: Thursdays Oct. 12th-Dec. 21st
30 Hours of Training for $995!

Understand the complete Microsoft solution stack, how the products work together, and how to implement and maintain for a total datacenter and desktop solution. This course covers the latest technology updates including Windows Server 2016 and Windows 10 and will enable the new capabilities to be leveraged in your organization.

 

Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×