February 22, 2018 6:30 PM

PacificSource Health Plans
13010 SW 68th Parkway, Suite 140
Tigard, OR 97223

As you are facing the long side of the building – the main entrance is to your left. To the right, around the corner at the end of the building is a door which leads to the hallway where the new room is, and the first door on your right is β€œit”.
Introduction to Powershell for the SQL Server Pro

In this introductory session we will introduce the basic concepts of powershell and show how we can utilize it to begin automating common tasks. In addition to the concepts below, we will also delve a bit into how the DBA role is changing and what we can learn from developers in regards to automation.

Working with Strings
Using Invoke-SQL and the SQL Server Management objects (SMO)
Extensibility (Custom and third party cmdlets)
A brief introduction to the DBAtools.io cmdlets

Finally we will tie all this together by showing how we can use powershell to automate and standardize our SQL Server installs.

Brandon Leach is a Senior DBA at SurveyMonkey and a former developer in a past life. He is also a Microsoft Data Platform MVP. He has worked in high scale up and scale out environments and places a high value on the power of automating infrastructure.



PacificSource PASS Chapter Logo

copyright ©2017, Portland SQL Server User Group and pdxssug.com all rights reserved.
Redistribution of any portion of this site is forbidden without prior written permission.