Session 3: Automating the DBA's Workload

RSS

Presented by: Allen White 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.

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.

Purchase a VIP Subscription to Gain Access!

In order to gain access to this and several other amazingly life-changing articles as well as many, many other cool content types, purchase VIP Access!

Already purchased this? to view your content.
NEW: Microsoft Hyper-V Master Class with John Savill

A new Master Class with John Savill! Get 12 hours of detailed instruction covering all the key aspects of a Hyper-V based virtualization environment.

During this training attendees will learn how to:

-- Architect a Hyper-V based virtualization solution.
-- Migrate from physical and other virtualization environments.
-- Implement a private cloud solution.

Thursdays, April 17th through May 8th
 

Upcoming Training

Deploying Windows 7 and Windows 8.1 with System Center Configuration Manager 2012 R2

Wednesday, April 23rd @ 11am, 1pm, 3pm ET

In a single day you will learn to deploy Windows 7 and Windows 8.1 using System Center Configuration Manager 2012 R2 and MDT 2013. Johan Arwidmark guides you through the entire build process. You will learn about reference images, deployment of images, drivers injection, adding updates and applications and a great deal of real-world tips and tricks.

Enroll by April 29th and SAVE 15%
View All Online Training

IT/Dev Connections

Register now to get the best rates available!

Current Issue

April 2014 - The architectural components related to Hyper-V networking in System Center Virtual Machine Manager 2012 R2 can be confusing. Walk through all the VMM networking architectural components and how to use them.

CURRENT ISSUE / ARCHIVE / SUBSCRIBE

Windows Forums

The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.

Sponsored Introduction Continue on to (or wait seconds) ×