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.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Jul 8, 2014
blog

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014
blog

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More
Microsoft Azure Machine Learning screenshot
Jun 20, 2014
blog

Microsoft Cloud Predictive Analytics Preview Coming Soon

A preview of Azure Machine Learning, or Azure ML (project code name "Passau"), will be made publicly available in July 2014....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×