SQL Server Database Administration with PowerShell - On Demand

Price: $199.00

Presented by Allen White

Three Technical Sessions Available for Instant Access

Running Time: 314 minutes


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.

We'll wrap up with a look at the new PowerShell cmdlets introduced for SQL Server 2012 and how you can use PowerShell to manage SQL Server 2012 in server environments including the new Always On technology and Windows Server Core. After this one day you'll be ready to go to work and able to use PowerShell effectively.

During this training you will gain an understanding of:

  • The PowerShell language and object use
  • Server Management Objects and how to manage SQL Server with them
  • Gathering data on the properties and performance of SQL Server to provide management with details during license audits and performance problems

Who should attend? This course is designed for those new to PowerShell but have been working with SQL Server, and those who know basic PowerShell but want to be more effective using SQL Server with PowerShell. It also will be useful for the “accidental DBA”, the person in IT who inherits the responsibility ofmanaging the database servers.


Session 1: PowerShell Basics

An introduction to the basics of PowerShell, the language constructs and logic flow, allowing you to build your own library of functions and scripts to automate your own workflow. This will be followed by an introduction to Server Management Objects (SMO), which is the Management API for SQL Server.


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

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.


Session 3: Automating the DBA's Workload

An introduction to Policy-Based Management and a demonstration of how to set up PBM using PowerShell, followed by a walkthrough of the registered server and Central Management Server setup via scripts. Then a discussion of maintaining a server inventory and gathering SQL Server performance data via PowerShell, and a demonstration on using PowerShell Remoting to manage multiple servers simultaneously.



Allen White Is a Microsoft SQL Server MVP and Practice Leader at UpSearch. Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. He currently serves the SQL Server community as President of the Ohio North SQL Server User Group, the Cleveland, OH based chapter of the Professional Association for SQL Server (PASS). Contact Allen at http://upsearch.com/sql


Customer Service

Need to be invoiced or interested in registering 2 or more people? Contact our customer service team directly for assistance.
Email: service@sqlmag.com
Phone: 800-262-1954 or 913-967-1719

Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×