SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd.
A lot has changed in the SQL PowerShell world in the last 15 months and this full-day session is built to help people keep up with all the things that have been made easier, faster, or just didn’t exist before.
We will also cover several of the great commands in the dbatools module.
You can find more details at the Eventbrite page: https://www.eventbrite.com/e/be-a-rockstar-with-sql-powershell-tickets-33182821713
The updated abstract is included below.
Building Scalable, Robust Solutions in SQL PowerShell
Data is growing faster than ever, and Data Professionals are being asked to do more with less. As your responsibilities scale up, you need to make sure your scripts scale with them. As Microsoft’s official PowerShell module gets updated, the best practices change too. In this precon, we’ll show you how to write large-scale scripts that take advantage of the latest tools.
First, I’ll give you a lay of the land, showing you the basics and what’s new in PowerShell for SQL. With 90+ cmdlets and more every couple of months, you’ve probably missed some of the cool, new functionality. Then you’ll be ready to jump into some large-scale demos.
Next, we’ll dig deeper and look at techniques for building scripts that works at scale. For example, a ForEach-Object loop is like counting on your fingers. It’s great for a few objects, but starts to fall apart when you have to manage dozens of instances or hundreds of databases. Growing to enterprise scale requires different techniques and different features.
Another example is error reporting. If you’ve got 50 or even 10 instances, you don’t want them to have to stand in line to tell you what’s wrong when them. With parallel execution, you can get actionable information immediately, without waiting.
The most egregious example is dealing with third party apps. Does your app think a “data integration” is dumping 100 csv files to a folder? With PowerShell, you can dynamically and robustly import all of that into SQL, no manual intervention required.
By the end of the day, you will know how to use many of the new capabilities in SQL PowerShell and how to scale them across every instance of SQL Server in your environment. You’ll know best practices, and how to choose the best performing options to build scalable, robust solutions in PowerShell.
All attendees will receive all of the code that is demoed, as well as handouts about the language and how to get things done.