Use Case for PowerShell
Heroes in a half shell, PowerShell! Well, maybe that wasn’t the original line, but you know from this program and other places on the internet, PowerShell is all the rage. In this episode, we wanted to chat about other ways people are using PowerShell and we are happy to have Warren Estes talk with us about some of his experiences. Warren shares some ways he has used PowerShell to push the easy button and how it lead to a contribution on the Microsoft SSRS toolkit. We are joined this week by special guest panelist Eugene Meidinger.
If you know the source of the original line, let me know on social media or in the comments below!
Script to dynamically create backup scripts https://www.warrenestes.com/dynamically-create-restore-script/
Update Multiple SSRS subscriptions https://www.warrenestes.com/update-multiple-ssrs-subscriptions/
“[PowerShell is] not always my first choice, but in the end, it’s usually the best choice and quickest choice.”
“It’s wonderful to have pre-written code out there. Having the .net framework is absolutely amazing.”
“You don’t want to contribute garbage to an open source project. Testing is imperative, it’s huge.”
“Creating robust solutions to complex problems using PowerShell is super powerful.”
Listen to Learn
1:13 Compañero Shout-Outs
03:50 Introduction to guest co-host Eugene Meidinger
06:46 Intro to the guest and topic
07:22 Working with cross-functional environments
11:01 You can use .net libraries to get code to use in PowerShell
13:14 PowerShell is procedural but you can add desired state configuration
15:21 Unit testing and touching on Pester
16:48 What’s the best way to find out if there are integrations for the tools that we’re using?
17:40 Warren’s contribution to the PowerShell library
21:34 Can anyone contribute?
23:58 It’s always nice to hear actual use cases
25:37 How did Warren decide what to use in a specific situation that he wrote about?
27:20 SQL Family Questions
30:25 Closing Thoughts
“I am a database professional with over 15 years’ experience as a production DBA/Developer. I first started with SQL Server in 2000 (the year), using 7 (the version), and have worked with sybase, oracle and MSSQL. I also have experience with VB, C#, and love me some Powershell.
My website is www.warrenestes.com.”
Meet the Hosts
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.