Blog

Building Scalable, Robust Solutions in SQL PowerShell

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.  One of the most egregious examples 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.

at UT Chattanooga
EMCS Building , 784 Vine Street
Chattanooga, United States

no comment

Leave a Reply