This soup-to-nuts all-day introduction to PowerShell for the SQL Server DBA will start with the basics of PowerShell and teach you the fundamental 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 AlwaysOn technology and Windows Server Core. At the end of the day, you'll be ready to put PowerShell to work automating and managing SQL Server in your organization.
Practice Manager, UpSearch
Allen White is a Practice Manager for UpSearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992. He is a certified MCITP in SQL Server and an MCT and has been awarded Microsoft’s MVP Award for the past 5 years. Allen is President of the Ohio North SQL Server User's Group and answers questions about SMO and PowerShell in the MSDN Forums. You can read his blog at http://sqlblog.com/blogs/allen_white/default.aspx.
OTHER COURSE INFORMATION:
Attendees will need to bring laptops.
Internet & Network access are not available.
Food: Lunch will be provided.
Courtyard by Marriott Chevy Chase
5520 Wisconsin Ave
Chevy Chase, MD 20815
Cancellations more than 1 month prior to the event will be refunded 100%, 2 weeks prior 50% and within the last 2 weeks prior no refund will be given. Please contact firstname.lastname@example.org for refund processing.