PowerShell for Admins

ICYMI: PowerShell Week of 15-March-2019

Mark Roloff
2 min read
Share:

Topics include goodies for your prompt, more xplatform support for the SqlServer module, and more.

Content pulled together by Robin Dadswell and Mark Roloff

Invoke-Sqlcmd is Now Available Supporting Cross-Platform

by Steve Lee on March 11th

DBAs rejoice!

Invoke-SqlCmd is now xplat with the latest PS Core build. Make sure you check out Steve’s post for the details.

PowerShell Core – Updating Your SQL Server Linux Docker Containers Images

by Max Trinidad on March 10th

Speaking of xplat support for that cmdlet… Max demonstrates how to update your Linux Docker image to include the necessary tools for using

Invoke-SqlCmd .

Programmatically Triggering a Group Licenses Refresh for AzureAD

by Jos Lieben on March 11th

As nice and the Az module and Graph API are, some things still aren’t accessible through those. Jos shows us how to automate with Azure’s “hidden” API.

Bitlocker Active Directory Recovery Password Backup Compliance

by Mick Pletcher on March 8th

For SCCM admins, here’s a handy way to use PS with a Compliance Policy to make sure your BitLocker keys are properly backed up.

The Happy PowerShell Prompt

by Aaron Powell on March 12th

Who couldn’t use a little more positivity in their shell? Using ConEmu, Aaron shows how to inject a little happiness into your prompt.

Reddit /r/PowerShell - Popular Weekly Post

May be old news to some but /u/NotNotWrongUsually came across how colorful we can get in the shell now. Time to add a little extra pizazz to my prompt!

Youtube: ANZPSUG March 2019

Friedrich Weinmann joins the Australia and New Zealand PSUG to discuss PSFramework.

Related Articles

Sep 15, 2023

PowerShell Escape Room

PowerShell Escape Room by Michiel Hamers

by Michiel Hamers
https://about.me/michielhamers/

Why on earth you want to create an Escape Room with PowerShell as backend?

I’ve always been a fan of escape rooms, so I decided to create my own for my kids. I wanted to make it something that would be challenging and fun for them, but also educational. I decided to use PowerShell as the backend for the escape room, as I’m a PowerShell developer and I thought it would be a great way to learn more about the language.
The first step was to design the rooms. I wanted to make sure that there were a variety of puzzles and challenges that my kids would have to solve. I also wanted to make sure that the rooms were visually appealing and engaging. Once I had the rooms designed, I started building them.
I used a variety of materials to build the rooms, including wood, cardboard, and fabric. I also used a few electronic components, such as a USB extension cable with a switch and a 3-button keyboard. The USB extension cable with a switch was used to create a physical button that my kids could press to solve one of the puzzles. The 3-button keyboard was used to enter the code that my kids had to find to solve another puzzle.
I also used a few websites to create rebus puzzles that my kids had to solve. I printed out the rebus puzzles and placed them around the rooms. Once my kids had solved all of the puzzles, they were able to enter the code on a single screen to escape the room.
In this blog post, we’ll delve into the process of creating an engaging PowerShell escape room for the global PowerShell community. We’ll emphasize the significance of storytelling and provide a detailed breakdown of the PowerShell structure used for the escape room.

Sep 15, 2023

Microsoft Graph PowerShell Module: Getting Started Guide

Microsoft Graph PowerShell Module: Getting Started Guide

by Jeff Brown

Microsoft is retiring the Azure AD Graph API sometime after June 30, 2023 (announcement). This retirement includes the Azure AD PowerShell module. In its place, Microsoft has released the Microsoft Graph PowerShell module. The Microsoft Graph PowerShell module is the next-generation way of managing Microsoft cloud services using PowerShell. If you have used MSOnline or Azure AD PowerShell in the past, you’ll need to read on to learn about this new module.

Oct 8, 2021

ICYMI: PowerShell Week of 08-October-2021

Topics include VMWare, Windows 11, Web Reports and more…

Special thanks to Robin Dadswell, Prasoon Karunan V, Kiran Patnayakuni and Kevin Laux

How to gather your vCenter inventory data with this VMware PowerShell script

by Scott Matteson on 7th October

Inventory reports are a common request when administering a VMware vCenter environment. Learn how this VMware PowerShell script can make such requests quick and easy

Building a Web Report in PowerShell, use the -Force Luke

by Chris Noring on 8th October