The PowerShell Podcast

Splatting, Automation, and Chasing the Sun with Jess Pomfret


Listen Later

Jess Pomfret returns for her third appearance on the PowerShell Podcast and brings the same energy that keeps people coming back. She and Andrew cover a lot of ground, starting with her upcoming "Chase the Sun" charity cycling event where she'll attempt to ride 205 miles coast-to-coast across the UK in a single day, starting at sunrise on the longest day of the year and racing the sun to the finish line. It's a big undertaking, and she's riding to raise money for Momentum in Fitness, a charity her wife works for that brings fitness opportunities to older adults, kids in non-traditional school settings, and children with cancer.

On the technical side, Jess makes the case for PowerShell splatting as an underrated beginner concept that makes code dramatically more readable. She walks through the idea of pulling parameters out of a long command line, organizing them into a hash table, and passing that hash table to the command instead. It's one of those things experienced scripters take for granted, but seeing it for the first time is genuinely useful.

The conversation also gets into Desired State Configuration (DSC), where Andrew and Jess dig into what it is, how it works, and why it matters for sysadmins who want to maintain consistent configuration across their environments. Jess also opens up about managing a packed schedule between her day job, speaking, podcasting, LinkedIn Learning courses, and serious bike training. Her answer is honest and relatable: she's still figuring it out, but Todoist and a very supportive partner help a lot.

Key Takeaways:
  • Splatting is one of the most readable improvements you can make to your PowerShell code. Instead of chaining parameters into one long command, you load them into a hash table and pass that to your command with an @ symbol. Cleaner to write, easier to read, and especially useful when you're sharing code on a screen.
  • DSC lets you define what a system should look like and PowerShell handles the work of getting it (and keeping it) there. It's a mindset shift from scripting manual steps to declaring an end state, and it's particularly powerful in large environments where consistency matters.
  • Having a support system is one of the most underrated factors in being able to sustain a high-output career alongside community contributions. Whether it's people around you who help carry the load or finding your people in the data and PowerShell communities, you can't do it alone indefinitely.
  • Guest Bio:
    Jess Pomfret is a Data Platform Engineer and a dual Microsoft MVP. She's been working with SQL Server since 2011, is a maintainer on the dbatools open source project, co-host of the Finding Data Friends podcast, and a LinkedIn Learning instructor. She grew up in the south-west of England and now lives in the US. Outside of tech, she's an avid cyclist, padel player, and a devoted fan of proper football.
     
    Resource Links:
    • Connect with Jess on LinkedIn: https://www.linkedin.com/in/jpomfret
    • Connect with Andrew: https://andrewpla.tech/links
    • Jess's blog: https://jesspomfret.com
    • Support Jess's Chase the Sun ride for Momentum in Fitness: https://www.justgiving.com/page/jess-pomfret
    • Finding Data Friends podcast on YouTube: https://www.youtube.com/@findingdatafriends/videos
    • dbatools – PowerShell module for SQL Server automation: https://dbatools.io
    • Jess's previous episode on the PowerShell Podcast (Ep. 164): https://powershellpodcast.podbean.com/e/from-proper-football-to-databases-with-jess-pomfret/
    • Jess's first appearance on the PowerShell Podcast: https://powershellpodcast.podbean.com/e/dbatools-with-jess-pomfret/
    • Join the PDQ Discord: https://discord.gg/pdq
    • The PowerShell Podcast on YouTube: https://youtu.be/M2XvvCKs1Ls
    • ...more
      View all episodesView all episodes
      Download on the App Store

      The PowerShell PodcastBy PDQ.com

      • 4.9
      • 4.9
      • 4.9
      • 4.9
      • 4.9

      4.9

      31 ratings


      More shows like The PowerShell Podcast

      View all
      Hanselminutes with Scott Hanselman by Scott Hanselman

      Hanselminutes with Scott Hanselman

      381 Listeners

      The Changelog: Software Development, Open Source by Changelog Media

      The Changelog: Software Development, Open Source

      288 Listeners

      Security Now (Audio) by TWiT

      Security Now (Audio)

      2,007 Listeners

      Windows Weekly (Audio) by TWiT

      Windows Weekly (Audio)

      887 Listeners

      Software Engineering Daily by Software Engineering Daily

      Software Engineering Daily

      624 Listeners

      Risky Business by Risky Business Media

      Risky Business

      376 Listeners

      RunAs Radio by Richard Campbell

      RunAs Radio

      83 Listeners

      SANS Internet Stormcenter Daily Cyber Security Podcast (Stormcast) by Johannes B. Ullrich

      SANS Internet Stormcenter Daily Cyber Security Podcast (Stormcast)

      649 Listeners

      CyberWire Daily by N2K Networks

      CyberWire Daily

      1,026 Listeners

      Click Here by Recorded Future News

      Click Here

      420 Listeners

      Darknet Diaries by Jack Rhysider

      Darknet Diaries

      8,051 Listeners

      CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

      CoRecursive: Coding Stories

      188 Listeners

      Tech Brew Ride Home by Morning Brew

      Tech Brew Ride Home

      962 Listeners

      The Real Python Podcast by Real Python

      The Real Python Podcast

      139 Listeners

      Hacker And The Fed by Chris Tarbell & Hector Monsegur

      Hacker And The Fed

      167 Listeners