Dr Scripto 

Summary: Creating a Function in PowerShell and the power of the $PSVersionTable to make code more portable
Q: Hey, Doctor Scripto!
I saw that post last week on converting Here-String into an array. I wanted to write my code to trap for PowerShell and PowerShell Core.

Summary: Pulling up the properties of $PSVersionTable to identify your PowerShell edition

Hey, Doctor Scripto! I want to write my modules and scripts to be more portable. How can I tell if I am executing on PowerShell Core?

Just use the $PSVersionTable object and examine the PSEdition value.

Summary: Discovering some of the awesome and neat ways to leverage a Here-String in a Script or function
Q: Hey, Doctor Scripto!
I used to write scripts with supporting configuration files that never really changed. I was wondering if there was any way to put them INSIDE the script directly to make it self contained.

Summary: Using the ConvertFrom-Json Cmdlet in PowerShell to read a JSON formatted file

Hey, Doctor Scripto! I’ve seen a lot of JSON files in use in Azure. I’m not very good with editing JSON properly. Is there an easy way to read this and at least edit it with PowerShell?

Summary: Using the ConvertFrom-JSON and ConvertTo-JSON Cmdlets to edit a configuration file
Q: Hey, Doctor Scripto!
I need to be able to change the Startup settings in Teams (like the Auto launch feature). I can change it in the Interface, but I need to be able to edit across multiple systems.

Summary: Using PowerShell and a very simple Regular Expression to convert Random counts of spaces to a Comma

Hey Doctor Scripto! I have some string based output from a non PowerShell application. The output is good but I need to easily parse it.

Summary: Using PowerShell to automate Quser to identify users to Logoff systems in Windows
Hey Doctor Scripto! I need to log a user off every computer they’re logged into. The problem is, I don’t know which ones. How can I discover which computers they’re logged into and then log them off?

Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers

How can I easily check that my SQL Servers are all configured to meet best practices?

You can use SQL Server Assessments – the latest addition to the SQLServer PowerShell module.

Summary: Using the SQLServer module cmdlets to review and monitor SQL Server instance and database configuration
Q: Hey, Doctor Scripto!
I have loads of SQL Servers in my area of responsibility and I know they all need certain configuration settings but I’m never confident that they are all set just right so I spend a long time every month visiting them all over RDP to give reassure myself.

Summary: Using PowerShell to identify users who are Synchronized to AzureAD but not yet licensed

Hey, Doctor Scripto!
I’d love to be able to identify users Synchronized to AzureAD that haven’t yet had their licenses assigned.   Help a friend out?

No problem at all!