The PowerShell Podcast

DBATools with Jess Pomfret

Episode Summary:

Jess Pomfret joins us to discuss how PowerShell was the perfect tool to help her automate DBA tasks. She gives some great insight into joining the community for the first time and talks about how helpful Chrissy LeMaire was in submitting her first submission to the dbatools module. Last, we cover the importance of writing code to test your code with Pester.

Guest Bio and links:

Jess Pomfret is a Microsoft MVP who is passionate about databases and automation, and PowerShell is the tool that lets her combine those loves. She is heavily involved with the DBATools module for PowerShell, the go-to tool for database administrators using PowerShell. Jess is also the Co-Author of DBATools in a Month of Lunches, estimated to be published in June of 2022. All of that and still finds time to speak at PowerShell and DBA events.

"DBAtools is kind of a gateway drug for PowerShell."
                                                   -Jess Pomfret

Resource Links

https://jesspomfret.com/

https://github.com/jpomfret/IntroPowerShell

https://mvp.microsoft.com/en-us/PublicProfile/5003655

https://github.com/dataplat/dbatools

https://www.manning.com/books/learn-dbatools-in-a-month-of-lunches

https://jesspomfret.com/searching-stored-procedures/

 

Nobody Keeps a Secret Like PowerShell

Andrew loses his coffee. We highlight Justin Grote who has a knack for breaking down the why not just the how of PowerShell. We discuss secure ways to use credentials with PowerShell. Lastly, we talk about security with PowerShell, and how it is often used as an attack vector. We end up realizing securing your environment should be its own episode soon.

 

Links to the episode on podcast directories:

Justin Grote Twitter - https://twitter.com/JustinWGrote/status/1502374413596909568

Justin Grote Github - https://github.com/JustinGrote

Justin Grote on Secrets - https://www.youtube.com/watch?v=J86GYcyZAZs

PSHSummit Secrets - https://www.youtube.com/watch?v=CKwDlCim15s

Secret Github - https://github.com/PowerShell/SecretManagement

Sydney Smith on the latest Secrets release - https://devblogs.microsoft.com/powershell/tag/secretmanagement/

 

Chatting about Chatbots with Mike Kanakos, Microsoft MVP

Mike Kanakos is extremely active in the PowerShell community, so getting the opportunity to highlight all his contributions was pretty awesome for us. We got to talk about all of the ways we can contribute to PowerShell to keep it the best version of itself. We also did a quick dive into ChatBots and highlighted PoshBot, which can connect to several chat backends like Slack or Teams.

Guest Bio and links:

Mike is a Microsoft MVP who might be the biggest advocate for PowerShell out there. He has weekly engagements where he is blogging or talking about Powershell. He is so active in the community they figured they might as well make him the Director of Community Engagement at PowerShell.org. He also leads the Research Triangle PowerShell Users Group, which is helping over 2400 members better automate with PowerShell.

 

Mikes MVP Profile - https://mvp.microsoft.com/en-us/PublicProfile/5004073

Mikes blog - https://www.commandline.ninja/

Research Triangle PowerShell User Group - https://rtpsug.com/

Awesome talk on Secrets - https://youtu.be/vEniQPooUSs

Poshbot Git - GitHub - poshbotio/PoshBot: Powershell-based bot framework

Poshbot Docs - Home - PoshBot Docs

pscookiemonster on Poshbot - http://ramblingcookiemonster.github.io/PoshBot/

Using Webhooks - Get a Teams Notification the Moment an Active Directory User gets Locked Out with PowerShell Using Webhooks – The Lazy Administrator

James ”Friggen” Petty! Microsoft MVP

James Petty is crazy busy with all things PowerShell. He is running the upcoming PowerShell + DevOps Global Summit. James runs PowerShell.org, Co-Authoring PowerShell in a Month of Lunches, and in mid-May will be running The PowerShell "Firehose Class" with Don Jones where they do a DEEP dive into PowerShell. Finally, we talk about the value of the importexcel module and using PowerShell to wow the boss.

Guest Bio and links:

James Petty is the CEO of the DevOps Collective, a nonprofit for technology education. As well as the owner/moderator of PowerShell.org and its forums. Not satisfied with how bad he has already made me feel about my productivity, he is the lead writer for the 4th edition of PowerShell in a Month of Lunches while still maintaining his job as the solutions architect for Wyre Technologies.

James MVP Profile - https://mvp.microsoft.com/en-us/PublicProfile/5003525?fullName=James%20Petty

PowerShell Forums - https://forums.powershell.org/

PowerShell Firehose Class - https://donjones.com/powershell-firehose-class/

Youtube series on importexcell module - https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq

Stop Typing So Much

We are all about psreadline! The latest psreadline just hit General Availability as of February 23rd. We highlight John Savill and his awesome YouTube channel. We cover how to get psreadline up and running in VsCode. Lastly, we talk about some of our favorite features. Jordan likes the command prediction that uses your command history. Andrew loved CTRL + R which allows him to do a quick search to find an old command so he can reuse them.

 

Resource links:

John Savill PSReadline - https://www.youtube.com/watch?v=Q11sSltuTE0

PSReadlin Blog - https://devblogs.microsoft.com/powershell/psreadline-2-2-ga/

VsCode PowerShell Preview - https://devblogs.microsoft.com/powershell/announcing-the-powershell-preview-extension-in-vscode/

Configure PSReadline for VSCode - https://gist.github.com/corbob/ac6c7a09f9e524a589d3f163558518a9

The Power of Shell Compels You

In the first-ever episode, we break down who the hosts are and why we started this podcast. Getting that crap out of the way, we get to talk about PowerShell! We cover Kevin Marquette's "Everything you want to know about" series, focusing on psobjects that we both have used to help our writing. We take a look at the module PsWordle and discover Jordan accidentally learned something. Josh King announced he has done a preview release of Burnt Toast and is looking for people to help him test, as well as join in the discussion on what could be next. Finally, we talk about why $null should be on the left side for comparisons in your scripts.

 

Resource links

PsCustomObject - https://powershellexplained.com/2016-10-28-powershell-everything-you-wanted-to-know-about-pscustomobject/?utm_source=blog&utm_medium=blog&utm_content=indexref

Burnt Toast - https://toastit.dev/2022/02/12/finally-introducing-the-first-preview-of-burnttoast-v1/

PowerShell Discord - https://discord.com/invite/powershell

PowerShell Slack - https://powershell.slack.com/join/shared_invite/zt-eodd93as-RHYl6s~9XH8FNyE09M7zmA

 

Social Media

- Twitter - General info: @admarsenal -

All things PDQ Deploy: @pdqdeploy -

All things PDQ Inventory: @pdqinventory -

Package Library updates: @packagelibrary -

Alerts and Technical updates@pdqalerts

Facebook: https://www.facebook.com/PDQlive/​​​​

Reddit: https://www.reddit.com/r/PDQ/​​​​

LinkedIn: https://www.linkedin.com/company/pdq.com

Our blog: https://www.pdq.com/blog/​​​​

Instagram: @pdqlife