Presented by Allen White
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 session is 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’ll also be useful for the “accidental DBA”, the person in IT who inherits the responsibility for managing 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
If you have any questions regarding this event, the registration process or would like to register more than one attendee, please contact us directly.
Phone: 800-262-1954 or 913-967-1719