Scripting Blog

A place to learn about PowerShell and share stories of automation

Dr Scripto
Creating a Platform Independent Function in PowerShell

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.

Dr Scripto
PowerTip: Identify if you are running on 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.

Dr Scripto
Maximizing the Power of Here-String in PowerShell for Configuration Data

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.

Dr Scripto
PowerTip: Read a JSON configuration file as a PowerShell object

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?

Dr Scripto
Automating Quser through PowerShell

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?

Dr Scripto
Executing SQL Server Assessments from PowerShell

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.

200 Level

Dr Scripto
PowerTip: Using PowerShell to Convert raw Text to a Comma Separated columm

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.

Dr Scripto
Automating Quser through PowerShell

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?

arrays

Dr Scripto
Creating a Platform Independent Function in PowerShell

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.

Dr Scripto
How to skip the beginning and ending of a file by using PowerShell

Summary: Learn how to skip the beginning and ending portions of a text file by using Windows PowerShell in this article by the Microsoft Scripting Guy Ed Wilson.
This is the second post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

ASP.NET Core

Azure

Dr Scripto
PowerTip: Identify Synchronized AzureAD accounts without a License assigned

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! 

Dr Scripto
PowerTip: Identify the last time Users changed passwords in AzureAD

Summary: Using PowerShell to report on Users and the last time Passwords were changed

Hey, Doctor Scripto! I need to report on users and when they updated their passwords In AzureAD. Could you show me how ?

Most certainly, I love to provide a helping hand however I can.

Dr Scripto
Easily Create IoT Edge custom modules with Visual Studio Code

At the recent Connect(); 2017 in November, we announced public preview of Azure IoT Edge. Now you can bring the intelligence of the Cloud right to the IoT Edge as well as easily create and manage business logic for your devices.

Dr Scripto
Sky’s the limit with Azure, ASP.NET Core, and Visual Studio for Mac

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
Cloud services represent a huge leap in functionality,

Dr Scripto
Managing Secrets Securely in the Cloud

You’ve probably heard some version of the story about a developer who mistakenly checked in his AWS S3 key to Github. He pulled the key within 5 minutes but still racked up a multi-thousand dollar bill from bots that crawl open source sites looking for secrets.

Dr Scripto
Keep Your Skills Up to Date: New Training and Azure Resources

Finding better ways to upskill is a consistent topic that comes up when we talk to you about what’s top of mind. It’s no wonder when the one constant in our industry is change with new techniques, frameworks, tools, and languages emerging all the time.

community

Dr Scripto
Nearly everything has changed for SQL Server PowerShell

2016 was the best year in SQL PowerShell history! I guess I should have mentioned that here sooner.
Wired® Magazine recently said that Microsoft SQL Server was the surprise hit of the year. The primary cited reason is the SQL Server port to Linux,

Dr Scripto
Join the PowerShell tenth birthday celebration

SUMMARY: Microsoft Scripting Guy Ed Wilson announces November 14, 2016 as date for PowerShell 10th anniversary celebration
Can you believe that PowerShell is nearly 10 years old (that is a long time in ‘internet time’)? On November 14, 2016 we will celebrate the occasion with a day-long event that will run from 8 in the morning until 4 in the afternoon (PST).

Dr Scripto
Scripting Guys at Ignite 2016 in Atlanta

SUMMARY: Ed Wilson, Microsoft Scripting Guy, talks about the Scripting Guys booth at Ignite 2016 in Atlanta.
Good morning everyone. Ed Wilson, Microsoft Scripting Guy, here. So, the day has finally arrived – after literally months and months of planning, Ignite 2016 in Atlanta has arrived.

Dr Scripto
The Scripting Guy: coming to a town near you

SUMMARY: The Microsoft Scripting Guys, Ed Wilson, upcoming live appearances.
Hello Scripters,
Teresa (aka. Scripting Wife) here. We have been really busy recently working with PowerShell user groups, and we want to provide you with a convenient listing of upcoming special events.

Dr Scripto
The Scripting Guys and Scripting Wife summer tour

SUMMARY: Ed Wilson talks about his summer of PowerShell tour with dates and links to live appearances.
Hello everyone,  Hope you are having a fantastic day. Ed and I have been busy as usual and are ready to get busier.  Here are the dates and links to upcoming events we will be attending and Ed speaking.

Dr Scripto
How to answer a technical question: A guide for presenters

Summary: Learn how to properly answer a technical question in a presentation in this step-by-step post by PowerShell MVP June Blender.
Today we have another blog post by PowerShell MVP June Blender. June is an Honorary Scripting Guy and a technical evangelist for the SAPIEN Technologies,

Dr Scripto
PowerShell 5 MVA coming soon to a computer near you

SUMMARY: Microsoft Scripting Guy, Ed Wilson talks about recording a new Microsoft Virtual Academy series of videos with PFE Ashley McGlone.
Hello everyone, Microsoft Scripting Guy Ed Wilson here. Well, I can tell you this week has been absolutely incredible. The Scripting Wife and I are out in Seattle (Bellevue,

Connect();

Delimited files

Dr Scripto
How to skip the beginning and ending of a file by using PowerShell

Summary: Learn how to skip the beginning and ending portions of a text file by using Windows PowerShell in this article by the Microsoft Scripting Guy Ed Wilson.
This is the second post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

Doctor Scripto

Dr Scripto
PowerTip: Identify which Platform PowerShell is running on

Summary: Using $PSVersionTable to identify if you are on Windows or Unix

Hey, Doctor Scripto! I’m working on my PowerShell scripts and I need to be able to identify if I’m working on Windows or Linux. How can I do this easily?

Dr Scripto
Creating a Platform Independent Function in PowerShell

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.

Dr Scripto
PowerTip: Identify if you are running on 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.

Dr Scripto
Maximizing the Power of Here-String in PowerShell for Configuration Data

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.

Dr Scripto
PowerTip: Read a JSON configuration file as a PowerShell object

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?

Dr Scripto
Configuring Startup Settings in Microsoft Teams with Windows 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.

Dr Scripto
PowerTip: Using PowerShell to Convert raw Text to a Comma Separated columm

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.

Dr Scripto
Automating Quser through PowerShell

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?

Dr Scripto
PowerTip: Identify if SQL Servers are configured to best practices

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.

Dr Scripto
Executing SQL Server Assessments from PowerShell

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.

Extensions

Dr Scripto
Announcing Language Server Protocol Preview Release

Visual Studio is joining Visual Studio Code in offering support for the Language Server Protocol. As an extension author, you can now write Visual Studio extensions that leverage existing language servers to provide a rich editing experience for languages that initially had no native language support in Visual Studio.

Dr Scripto
Visual Studio IDE extensions now published and managed at Marketplace

Consumers of Visual Studio IDE extensions visit Visual Studio Marketplace to discover and acquire extensions. But extension publishers visit Visual Studio Gallery to publish and manage their Visual Studio IDE extensions. Henceforth, extension publishing and management will also be in Marketplace.

files

Dr Scripto
How to skip the beginning and ending of a file by using PowerShell

Summary: Learn how to skip the beginning and ending portions of a text file by using Windows PowerShell in this article by the Microsoft Scripting Guy Ed Wilson.
This is the second post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

Getting Started

Dr Scripto
The top three tips for effective sorting in PowerShell

Summary: Learn the top three tips to effectively use Windows PowerShell to sort data in this blog post by the Microsoft Scripting Guy, Ed Wilson.
One of the fundamental things that I need to do when I look at any kind of data is sort it so that I can make sense of what I am looking at.

Dr Scripto
Use a script block to create custom groupings in PowerShell

Summary: Learn how to use a script block with the Group-Object cmdlet in Windows PowerShell to create custom groupings in this article by Microsoft Scripting Guy Ed Wilson.
Good morning. Ed Wilson the Microsoft Scripting Guy is here. This week, I have been hanging out with a group of writers.

Grouping

Dr Scripto
Use a script block to create custom groupings in PowerShell

Summary: Learn how to use a script block with the Group-Object cmdlet in Windows PowerShell to create custom groupings in this article by Microsoft Scripting Guy Ed Wilson.
Good morning. Ed Wilson the Microsoft Scripting Guy is here. This week, I have been hanging out with a group of writers.

Hey Scripting Guy!

Dr Scripto
Clean up Domain Controller DNS Records with Powershell

Summary: Using Windows PowerShell to remove Stale / Dead Domain Controller records.
Q: Hey, Doctor Scripto!
How can I quickly clean up all my dead Domain Controller’s DNS records?
A:
That’s a great question. The good Doctor also knows the very person to answer it best.

Dr Scripto
PowerTip: Use PowerShell to pick a random name from a list

Using the Get-Random Cmdlet to select a random list of names instead of numbers

Dr Scripto
Using PowerShell to create a folder of Demo data

Creating sample files with random sizes and dates for use in a Lab

Parse HTML and pass to Cognitive Services Text-to-Speech

Having some fun with Abbott and Costello’s “Who’s on first?” comedy routine, and multiple voices with Bing Speech.

Windows PowerShell and the Text-to-Speech REST API (Part 5)

Send and receive content to the Text-to-Speech API with PowerShell.

Windows PowerShell and the Text-to-Speech REST API (Part 4)

Send and receive content to the Text-to-Speech API with PowerShell.

Windows PowerShell and the Text-to-Speech REST API (Part 3)

Use Windows PowerShell to access the Cognitive Services Text-to-Speech API.

Run PowerShell code in Puppet

Normally, it’s preferable to use specific Puppet and DSC Windows modules to manage systems in Puppet, but an alternative is running PowerShell commands and scripts by using the exec resource. This can be helpful for transitioning existing PowerShell code into Puppet quickly.

Dr Scripto
Get certificate info into a CSV by using PowerShell

Summary: Certificate management is always challenging. Let’s explore how to use PowerShell to export local certificate information to a comma-separated values (CSV) file on Windows 7 (or later) computers.
Q: Hey, Scripting Guy!
How can I get all my certificate info into a CSV on my Windows computers?

Dr Scripto
Introducing the DscLcm utility for PowerShell

Summary: Desired State Configuration is a great deployment tool to meet your organization’s infrastructure-as-code goals. I recently came across a situation for a project that uses the Push Service (as opposed to the Pull Service). It required me to be able to apply a new partial configuration to a node,

Java

Dr Scripto
Announcing JUnit Support for Visual Studio Code

Today, we’re pleased to release a new extension to our Visual Studio Code Java extension family – Test Runner/Debugger for Java. It’s a lightweight test runner/debugger with below features we hope you will like.

Recognize JUnit4 tests
Run test
Debug test
View test status and run summary

Same as the Debugger for Java,

Dr Scripto
Run and Debug Java 9 in Visual Studio Code

In the past 3 weeks, we’ve continued to see a lot of people installing and trying our tools, reading our documents, and visiting our repository. We’ve also seen a number of new issues opened by the Java community. Thank you all for trying our tools and providing feedback,

JSON

Math

Microsoft 365

Dr Scripto
PowerTip: Identify Synchronized AzureAD accounts without a License assigned

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! 

Dr Scripto
Reporting on Microsoft 365 Licensing using PowerShell – Part 3

Summary: Will Martin finalizes his discussion on how to report on Microsoft 365 licensing in the cloud.
Previous Posts on this article can be found here for continuity
Reporting on Microsoft 365 Licensing using PowerShell – Part 1
Reporting on Microsoft 365 Licensing using PowerShell – Part 2
Dr.

Dr Scripto
Reporting on Microsoft 365 Licensing using PowerShell – Part 2

Summary: Will Martin continues his discussion on how to report on Microsoft 365 licensing in the cloud.
Previous Posts on this article can be found here for continuity
Reporting on Microsoft 365 Licensing using PowerShell – Part 1
Remember from last week we showed the results of what a user licensed in Microsoft 365 looked like in the web portal?

Dr Scripto
PowerTip: Identify the last time a User was Synchronized to AzureAD

Summary: Use PowerShell to identify the property in AzureAD with the Synchronization time in AzureAD

Hey, Doctor Scripto. Is there a way with PowerShell to identify when a user was last synchronized with AzureAD?

Absolutely! We just need to examine the LastDirSyncTime when using the Get-Msoluser cmdlet.

Dr Scripto
Reporting on Microsoft 365 Licensing using PowerShell – Part 1

Summary: Will Martin discusses how to report on Microsoft 365 licensing in the cloud.
Hello everyone, Doctor Scripto here today to introduce you to a good friend of mine. Will Martin is a PFE in Messaging here at Microsoft and he wanted to share a wonderful solution he found on reporting on Microsoft 365 licensing with PowerShell.

Microsoft Operations Management Suite

Dr Scripto
Control management pack updates between MS OMS and Operations Manager

Summary: Learn how to disable automatic management pack updates from MS OMS to Operations Manager and limit updates to a specific time window.
Hi all, Brian Wren here. I usually spend my time writing documentation for TechNet and Azure.com, but I’ve been hearing about an issue from a few customers that I wanted to address.

Microsoft Teams

.NET

Dr Scripto
Share UI Code in any iOS and Android App with .NET Embedding

One of the most exciting announcements during this year’s Connect(); event was the ability to embed .NET libraries into existing iOS (Objective-C/Swift) and Android (Java) applications with .NET Embedding. This is great because you can start to share code between your iOS and Android applications,

Dr Scripto
Overview of Visual Studio 2017 and Updates for .NET Developers

Visual Studio 2017 first released in March of this year. Since then, there have been five updates with each bringing more improvements and capabilities. Every improvement is geared towards making you more productive and this post aims to give you an overview of the culmination of features to date.

Performance

Dr Scripto
Large C# and VB solutions load significantly faster in 15.5 update

On average, 50 percent of all solutions opened by Visual Studio users open in ten seconds or less. However, large solutions can take longer to load because there are a lot of projects that Visual Studio needs to process.
Over the last six months,

Dr Scripto
Test Experience Improvements

There have been several significant improvements to the test experience that range across Visual Studio and Visual Studio Team Services. These efforts involved frameworks and tooling for both .NET and C++, but all had a common goal: make testing with our developer tools a great experience.

PowerShell

Dr Scripto
PowerTip: Identify which Platform PowerShell is running on

Summary: Using $PSVersionTable to identify if you are on Windows or Unix

Hey, Doctor Scripto! I’m working on my PowerShell scripts and I need to be able to identify if I’m working on Windows or Linux. How can I do this easily?

Dr Scripto
Creating a Platform Independent Function in PowerShell

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.

Dr Scripto
PowerTip: Identify if you are running on 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.

Dr Scripto
Maximizing the Power of Here-String in PowerShell for Configuration Data

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.

Dr Scripto
Configuring Startup Settings in Microsoft Teams with Windows 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.

Dr Scripto
PowerTip: Using PowerShell to Convert raw Text to a Comma Separated columm

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.

Dr Scripto
Automating Quser through PowerShell

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?

Dr Scripto
PowerTip: Identify if SQL Servers are configured to best practices

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.

Dr Scripto
Executing SQL Server Assessments from PowerShell

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.

Dr Scripto
PowerTip: Identify Synchronized AzureAD accounts without a License assigned

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! 

PowerShell 5

Dr Scripto
PowerShell 5 MVA coming soon to a computer near you

SUMMARY: Microsoft Scripting Guy, Ed Wilson talks about recording a new Microsoft Virtual Academy series of videos with PFE Ashley McGlone.
Hello everyone, Microsoft Scripting Guy Ed Wilson here. Well, I can tell you this week has been absolutely incredible. The Scripting Wife and I are out in Seattle (Bellevue,

Dr Scripto
Use PowerShell 5.0 to create temporary files in the temp folder

Summary: Microsoft Scripting Guy Ed Wilson talks about using Windows PowerShell 5.0 on Windows 10 to create temporary files in the temporary folder.
 
Sometimes it is the little things that make life easier. You know, like a cereal bar … it’s not like a major technological breakthrough but it is much more convenient than getting a bowl of milk and opening a box of cereal and dumping it in the bowl.

PowerTip

Dr Scripto
PowerTip: Identify which Platform PowerShell is running on

Summary: Using $PSVersionTable to identify if you are on Windows or Unix

Hey, Doctor Scripto! I’m working on my PowerShell scripts and I need to be able to identify if I’m working on Windows or Linux. How can I do this easily?

Dr Scripto
PowerTip: Identify if you are running on 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.

Dr Scripto
PowerTip: Read a JSON configuration file as a PowerShell object

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?

Dr Scripto
PowerTip: Identify if SQL Servers are configured to best practices

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.

Dr Scripto
PowerTip: Identify the last time Users changed passwords in AzureAD

Summary: Using PowerShell to report on Users and the last time Passwords were changed

Hey, Doctor Scripto! I need to report on users and when they updated their passwords In AzureAD. Could you show me how ?

Most certainly, I love to provide a helping hand however I can.

Dr Scripto
PowerTip: Use PowerShell to pick a random name from a list

Using the Get-Random Cmdlet to select a random list of names instead of numbers

Dr Scripto
PowerTip: Turn off the power to your computer with PowerShell

I’ve got a script that needs to power off a system after it’s done. How can I accomplish this with PowerShell?

Dr Scripto
PowerTip: Determine your version of PowerShell and host operating system

Identify your PowerShell environment by making use of built-in PowerShell variables.

Dr Scripto
PowerTip: Use PowerShell to play WAV files

Make use of the native features of Windows through PowerShell to play sound.

Dr Scripto
PowerTip: Ensure that errors in PowerShell are caught

Here’s how to make sure your errors get caught with Try Catch Finally.

REGEX

Dr Scripto
PowerTip: How to escape characters in a string using regular expressions

Summary: Cloud & Datacenter Management MVP, Thomas Rayner, shows how escape characters for use in regex.
Is there a way to escape characters in a string automatically for use in regex?
 Use the [regex]::escape() method to automatically escape characters in a string so you can use them in regex.

Dr Scripto
PowerShell regex crash course – Part 1 of 5

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows the basics of working with regular expressions in PowerShell.
Hello! I’m Thomas Rayner, a proud Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy! this week. You can find me on Twitter (@MrThomasRayner) or posting on my blog,

Dr Scripto
PowerTip: Use a regular expression pattern to remove nonalphabetic characters

Summary: Learn how to use a regular expression pattern to remove non-alphabetic characters from a string by using Windows PowerShell.
 How can I use Windows PowerShell to remove non-alphabetic characters from a string?
 To remove nonalphabetic characters from a string, you can use the -Replace operator and substitute an empty string ‘’ for the nonalphabetic character.

Regular Expressions

Dr Scripto
PowerTip: Using PowerShell to Convert raw Text to a Comma Separated columm

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.

Dr Scripto
Automating Quser through PowerShell

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?

Dr Scripto
PowerTip: Know the difference between the .split() method and ‘-split’

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how to split a string by using a string instead of just a character.
I am trying to split the string “this is my amazing string” on the pattern “my” by using “this is my amazing string”.split(“my”) but it’s giving me a bunch of garbled stuff back.

Dr Scripto
PowerShell regex crash course – Part 5 of 5

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows the basics of working with regular expressions in PowerShell.
Hello! I’m Thomas Rayner, a proud Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy! this week. You can find me on Twitter (@MrThomasRayner),

Dr Scripto
PowerTip: How to use regular expressions to split a string without losing the character you split on

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how to split a string without losing the character you split on.
I’m splitting this file name some file.txt into its name and extension by going “some file.txt” –split “.”. It’s giving me some file and txt,

Dr Scripto
PowerTip: How to detect a valid Active Directory user name using regular expressions

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how use regex to detect if a string is a valid Active Directory user name.
The invalid characters for an Active Directory user name are /\[:;|=,+*?<>]\ and “. How do I tell if a string is a valid Active Directory user name?

Dr Scripto
PowerShell regex crash course – Part 3 of 5

Summary: Thomas Rayner, Microsoft Cloud & Datacenter Management MVP, shows the basics of working with regular expressions in PowerShell.
Hello! I’m Thomas Rayner, a proud Cloud & Datacenter Management Microsoft MVP, filling in for The Scripting Guy! this week. You can find me on Twitter (@MrThomasRayner),

Dr Scripto
PowerTip: How to detect phone numbers using regular expressions

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how to use regex to detect if a string is a phone number.
I have an array like $phoneornot = @(‘780-123-4567’, ‘780 321 6548’, ‘notme’, ‘this is 2 num’), and I need to know which array items are phone numbers.

Dr Scripto
PowerShell regex crash course – Part 2 of 5

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows the basics of working with regular expressions in PowerShell.
Hello! I’m Thomas Rayner, a proud Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy! this week. You can find me on Twitter (@MrThomasRayner),

Dr Scripto
PowerTip: Use a regular expression pattern to remove nonalphabetic characters

Summary: Learn how to use a regular expression pattern to remove non-alphabetic characters from a string by using Windows PowerShell.
 How can I use Windows PowerShell to remove non-alphabetic characters from a string?
 To remove nonalphabetic characters from a string, you can use the -Replace operator and substitute an empty string ‘’ for the nonalphabetic character.

Scripting Techniques

Dr Scripto
Maximizing the Power of Here-String in PowerShell for Configuration Data

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.

Dr Scripto
Reporting on Microsoft 365 Licensing using PowerShell – Part 3

Summary: Will Martin finalizes his discussion on how to report on Microsoft 365 licensing in the cloud.
Previous Posts on this article can be found here for continuity
Reporting on Microsoft 365 Licensing using PowerShell – Part 1
Reporting on Microsoft 365 Licensing using PowerShell – Part 2
Dr.

Dr Scripto
Reporting on Microsoft 365 Licensing using PowerShell – Part 1

Summary: Will Martin discusses how to report on Microsoft 365 licensing in the cloud.
Hello everyone, Doctor Scripto here today to introduce you to a good friend of mine. Will Martin is a PFE in Messaging here at Microsoft and he wanted to share a wonderful solution he found on reporting on Microsoft 365 licensing with PowerShell.

Dr Scripto
Reporting on Digitally Signed Files with PowerShell

Summary: Using the Get-AuthenticodeSignature cmdlet to show if a file is Digitally Signed
Q: Hey, Doctor Scripto!
I was curious, since many new files are Digitally signed with a certificate if there was an easy way to see the status of the Digital Signatures of many files easily?

Dr Scripto
Clean up Domain Controller DNS Records with Powershell

Summary: Using Windows PowerShell to remove Stale / Dead Domain Controller records.
Q: Hey, Doctor Scripto!
How can I quickly clean up all my dead Domain Controller’s DNS records?
A:
That’s a great question. The good Doctor also knows the very person to answer it best.

Dr Scripto
PowerTip: Use PowerShell to pick a random name from a list

Using the Get-Random Cmdlet to select a random list of names instead of numbers

Dr Scripto
Using PowerShell to create a folder of Demo data

Creating sample files with random sizes and dates for use in a Lab

Dr Scripto
PSScriptAnalyzer deep dive – Part 4 of 4

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows how to write a custom PSScriptAnalyzer rule.
Hello! I’m Thomas Rayner, a Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy this week. You can find me on Twitter (@MrThomasRayner),

Dr Scripto
PSScriptAnalyzer deep dive – Part 3 of 4

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows how to use Pester to get nUnit formatted results out of PSScriptAnalyzer.
Hello! I’m Thomas Rayner, a Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy this week.

Dr Scripto
PSScriptAnalyzer deep dive – Part 2 of 4

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows how to suppress, include, and exclude PSScriptAnalyzer rules.
Hello! I’m Thomas Rayner, a Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy this week. You can find me on Twitter (@MrThomasRayner),

Security

Dr Scripto
Letter frequency analysis of text by using PowerShell

Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to do letter frequency analysis of a text enabling one to see how often a letter occurs.
This is the first post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

sorting

Dr Scripto
The top three tips for effective sorting in PowerShell

Summary: Learn the top three tips to effectively use Windows PowerShell to sort data in this blog post by the Microsoft Scripting Guy, Ed Wilson.
One of the fundamental things that I need to do when I look at any kind of data is sort it so that I can make sense of what I am looking at.

Storage

Dr Scripto
How to skip the beginning and ending of a file by using PowerShell

Summary: Learn how to skip the beginning and ending portions of a text file by using Windows PowerShell in this article by the Microsoft Scripting Guy Ed Wilson.
This is the second post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

Text

Dr Scripto
Additional resources for text analysis by using PowerShell

Summary: This is a summary of some of the additional resources for working with text and Windows PowerShell.
Good day. Microsoft Scripting Guy, Ed Wilson, is here. So, here’s the deal. We are going along and decide to write a simple Windows PowerShell script.

Dr Scripto
Calculate percentage character frequencies from a text file by using PowerShell

Summary: Learn how to use Windows PowerShell to calculate the percentage of how often a character appears in a text file.
This is the fifth post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

Dr Scripto
How to skip the beginning and ending of a file by using PowerShell

Summary: Learn how to skip the beginning and ending portions of a text file by using Windows PowerShell in this article by the Microsoft Scripting Guy Ed Wilson.
This is the second post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

Dr Scripto
Letter frequency analysis of text by using PowerShell

Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to do letter frequency analysis of a text enabling one to see how often a letter occurs.
This is the first post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

Text files

Dr Scripto
Maximizing the Power of Here-String in PowerShell for Configuration Data

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.

Dr Scripto
Configuring Startup Settings in Microsoft Teams with Windows 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.

Dr Scripto
Compare the letter frequency of two text files by using PowerShell

Summary: Learn how to use Windows PowerShell to compare the letter frequency of two different text files.
This is the fourth post in a multi-part series of blog posts that deal with how to determine letter frequency in text files. To fully understand this post,

Dr Scripto
Read a text file and do frequency analysis by using PowerShell

Summary: Learn how to read a text file and do a letter-frequency analysis using Windows PowerShell in this article written by the Microsoft Scripting Guy, Ed Wilson.
This is the third post in a multi-part series of blog posts that deal with how to determine letter frequency in text files.

Text manipulation

Dr Scripto
Creating a Platform Independent Function in PowerShell

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.

Dr Scripto
Maximizing the Power of Here-String in PowerShell for Configuration Data

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.

Dr Scripto
PowerTip: Use a regular expression pattern to remove nonalphabetic characters

Summary: Learn how to use a regular expression pattern to remove non-alphabetic characters from a string by using Windows PowerShell.
 How can I use Windows PowerShell to remove non-alphabetic characters from a string?
 To remove nonalphabetic characters from a string, you can use the -Replace operator and substitute an empty string ‘’ for the nonalphabetic character.

Uncategorized

Dr Scripto
Compare the letter frequency of two text files by using PowerShell

Summary: Learn how to use Windows PowerShell to compare the letter frequency of two different text files.
This is the fourth post in a multi-part series of blog posts that deal with how to determine letter frequency in text files. To fully understand this post,

Dr Scripto
Next steps for the official PowerShell documentation

Summary: Learn about changes that we’ve already made for PowerShell content and what’s planned for the near future.
Hello scripters!
My name is Don Gill, and I am the new documentation manager for Windows PowerShell. With the 2016 PowerShell and DevOps Summit quickly approaching,

Dr Scripto
A first look at Windows PowerShell ISE Preview

Summary: Take a first look at the newly released Windows PowerShell ISE Preview.
Good morning everyone. Ed Wilson here. I can tell you that the list of speakers for PowerShell Saturday on in Tampa March 19, 2016 looks really impressive. There are going to be seven MVPs and six Microsoftees there!

Dr Scripto
PowerTip: Find published modules in the PowerShell Gallery

Summary: Learn how to find Published Windows PowerShell modules in the PowerShell Gallery.
 How can I use Windows PowerShell to find modules that are published in the Windows PowerShell Gallery?
 Use the Find-Module cmdlet in Windows PowerShell 5.0. This example finds modules related to the ISE:
Find-Module *ISE*

Dr Scripto
Install the PowerShell ISE Preview from the PowerShell Gallery

Summary: Learn how to install the Windows PowerShell ISE Preview edition from the PowerShell Gallery to Windows PowerShell 5.0 by using a one-line command.
One of the way cool things is that the Windows PowerShell ISE is released to the PowerShell Gallery.

Dr Scripto
PowerTip: Learn about PowerShell default parameter values

Summary: Learn about the default parameter values in Windows PowerShell.
 How can I find more about default parameter values in Windows PowerShell?
 Use the Get-Help cmdlet and search for *defaultParameter*. The following command returns a            list of Help topics that provide this information:
help *DefaultParameter*

Dr Scripto
Convert a web page into objects for easy scraping with PowerShell

Summary: Learn how to use Windows PowerShell 5.0 to scrape a web page so that you can easily return parsable objects.
Good morning. Ed Wilson here, and today I have a guest blog post by Doug Finke…
When surfing the PowerShell Gallery,

Dr Scripto
PowerTip: Use PowerShell to view properties and their values for a .NET Framework class

Summary: Learn how to view properties and the associated values of those properties of .NET Framework classes with Windows PowerShell.
 How can I use Windows PowerShell to view the properties and their values from a .NET Framework class,      

Dr Scripto
PowerTip: Find properties of .NET Framework class with PowerShell

Summary: Learn how to use Windows PowerShell to display properties of a .NET Framework class.
 How can I use Windows PowerShell to easily display properties of a .NET Framework class?
 Pipe the type accelerator to the Get-Member cmdlet and specify the MemberType property,

Dr Scripto
PowerTip: Find information about .NET Framework method with PowerShell

Summary: Learn how to use Windows PowerShell to find information about a .NET framework method.
 How can I use Windows PowerShell to find basic information about a particular .NET Framework method?
 Use the GetMethod method from the class, for example:
 [math].GetMethod("Tan")
Note  The method name is case sensitive and it must be in double quotation marks.

Visual Basic

Dr Scripto
Overview of Visual Studio 2017 and Updates for .NET Developers

Visual Studio 2017 first released in March of this year. Since then, there have been five updates with each bringing more improvements and capabilities. Every improvement is geared towards making you more productive and this post aims to give you an overview of the culmination of features to date.

Visual C#

Dr Scripto
Overview of Visual Studio 2017 and Updates for .NET Developers

Visual Studio 2017 first released in March of this year. Since then, there have been five updates with each bringing more improvements and capabilities. Every improvement is geared towards making you more productive and this post aims to give you an overview of the culmination of features to date.

Visual Studio

Dr Scripto
Visual Studio Updates for Office 365 APIs Tools

As we recently detailed on the Office Developer blog, we are making it simpler and easier for developers to connect to Office 365 through the Microsoft Graph. For Visual Studio developers currently using the Office 365 API Tools to create applications,

Dr Scripto
Connect(); 2017: SmartHotel360 Demo Apps and Architecture

Last month we hosted Microsoft Connect(); in New York City. Connect(); is a three-day, in-person and online developer event. If you missed it, no worries! You can watch our keynotes, sessions, and on-demand videos on Channel 9.
For the past five months our keynote demo team worked on a new set of reference apps.

Dr Scripto
Easily Create IoT Edge custom modules with Visual Studio Code

At the recent Connect(); 2017 in November, we announced public preview of Azure IoT Edge. Now you can bring the intelligence of the Cloud right to the IoT Edge as well as easily create and manage business logic for your devices.

Dr Scripto
Share UI Code in any iOS and Android App with .NET Embedding

One of the most exciting announcements during this year’s Connect(); event was the ability to embed .NET libraries into existing iOS (Objective-C/Swift) and Android (Java) applications with .NET Embedding. This is great because you can start to share code between your iOS and Android applications,

Dr Scripto
Visual Studio 2017 Version 15.6 Preview

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
A few days ago we released Visual Studio 2017 version 15.5 and an update to Visual Studio for Mac,

Dr Scripto
Post-Connect(); 2017 Visual Studio Partner Webinar Series

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
Earlier this week,

Dr Scripto
Snapshot Debugging with Visual Studio 2017: Now Ready for Production

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
Earlier this year we previewed the Snapshot Debugger,

Dr Scripto
Join Us to Learn How to Build Android 8.0 Oreo and iOS 11 apps with Visual Studio

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
Visual Studio and Xamarin enable .NET developers everywhere to use their favorite language and full-featured IDE to create native Android,

Dr Scripto
Visual Studio 2017 Version 15.5, Visual Studio for Mac Released

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
 
Today we released significant updates to both Visual Studio 2017 and Visual Studio for Mac.

Dr Scripto
Announcing JUnit Support for Visual Studio Code

Today, we’re pleased to release a new extension to our Visual Studio Code Java extension family – Test Runner/Debugger for Java. It’s a lightweight test runner/debugger with below features we hope you will like.

Recognize JUnit4 tests
Run test
Debug test
View test status and run summary

Same as the Debugger for Java,

Visual Studio App Center

Dr Scripto
The Latest in Developer Productivity and App Experiences

Whatever the language or platform, developers want the same thing – to create app experiences that are high-quality, intelligent and personalized. Experiences that delight users and keep them engaged. To do that, we need tools that increase our productivity, so that we spend more time on what matters most to our app’s success.

Visual Studio Code

Dr Scripto
Easily Create IoT Edge custom modules with Visual Studio Code

At the recent Connect(); 2017 in November, we announced public preview of Azure IoT Edge. Now you can bring the intelligence of the Cloud right to the IoT Edge as well as easily create and manage business logic for your devices.

Dr Scripto
Announcing Language Server Protocol Preview Release

Visual Studio is joining Visual Studio Code in offering support for the Language Server Protocol. As an extension author, you can now write Visual Studio extensions that leverage existing language servers to provide a rich editing experience for languages that initially had no native language support in Visual Studio.

Visual Studio for Mac

Dr Scripto
Sky’s the limit with Azure, ASP.NET Core, and Visual Studio for Mac

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
Cloud services represent a huge leap in functionality,

Dr Scripto
Visual Studio 2017 Version 15.5, Visual Studio for Mac Released

[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
 
Today we released significant updates to both Visual Studio 2017 and Visual Studio for Mac.

Dr Scripto
The Latest in Developer Productivity and App Experiences

Whatever the language or platform, developers want the same thing – to create app experiences that are high-quality, intelligent and personalized. Experiences that delight users and keep them engaged. To do that, we need tools that increase our productivity, so that we spend more time on what matters most to our app’s success.

Visual Studio Live Share

Dr Scripto
The Latest in Developer Productivity and App Experiences

Whatever the language or platform, developers want the same thing – to create app experiences that are high-quality, intelligent and personalized. Experiences that delight users and keep them engaged. To do that, we need tools that increase our productivity, so that we spend more time on what matters most to our app’s success.

Visual Studio Subscriptions

Visual Studio Tools for AI

Dr Scripto
The Latest in Developer Productivity and App Experiences

Whatever the language or platform, developers want the same thing – to create app experiences that are high-quality, intelligent and personalized. Experiences that delight users and keep them engaged. To do that, we need tools that increase our productivity, so that we spend more time on what matters most to our app’s success.

Windows 10

Dr Scripto
PowerShell 5 MVA coming soon to a computer near you

SUMMARY: Microsoft Scripting Guy, Ed Wilson talks about recording a new Microsoft Virtual Academy series of videos with PFE Ashley McGlone.
Hello everyone, Microsoft Scripting Guy Ed Wilson here. Well, I can tell you this week has been absolutely incredible. The Scripting Wife and I are out in Seattle (Bellevue,

Dr Scripto
Use PowerShell 5.0 to create temporary files in the temp folder

Summary: Microsoft Scripting Guy Ed Wilson talks about using Windows PowerShell 5.0 on Windows 10 to create temporary files in the temporary folder.
 
Sometimes it is the little things that make life easier. You know, like a cereal bar … it’s not like a major technological breakthrough but it is much more convenient than getting a bowl of milk and opening a box of cereal and dumping it in the bowl.

Windows PowerShell

Dr Scripto
Clean up Domain Controller DNS Records with Powershell

Summary: Using Windows PowerShell to remove Stale / Dead Domain Controller records.
Q: Hey, Doctor Scripto!
How can I quickly clean up all my dead Domain Controller’s DNS records?
A:
That’s a great question. The good Doctor also knows the very person to answer it best.

Dr Scripto
PowerTip: Get a list of security patches installed in the last 90 days

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how to get a list of all the security patches installed in the last three months.
How can I list all the security patches that I’ve installed in the last 90 days?

Dr Scripto
PSScriptAnalyzer deep dive – Part 4 of 4

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows how to write a custom PSScriptAnalyzer rule.
Hello! I’m Thomas Rayner, a Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy this week. You can find me on Twitter (@MrThomasRayner),

Dr Scripto
PowerTip: Get a list of suspended Azure Automation jobs

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how get a list of all your suspended Azure Automation jobs.
I think I have an Azure Automation job that is getting suspended for running too long. How can I verify this?

Dr Scripto
PSScriptAnalyzer deep dive – Part 3 of 4

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows how to use Pester to get nUnit formatted results out of PSScriptAnalyzer.
Hello! I’m Thomas Rayner, a Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy this week.

Dr Scripto
PowerTip: Convert from UTC to my local time zone

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how write a function to convert from UTC to your local time zone.
I have a time that I’d like to convert from UTC to my local time zone. How can I do this?

Dr Scripto
PSScriptAnalyzer deep dive – Part 2 of 4

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows how to suppress, include, and exclude PSScriptAnalyzer rules.
Hello! I’m Thomas Rayner, a Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy this week. You can find me on Twitter (@MrThomasRayner),

Dr Scripto
PowerTip: Find all the Azure Automation jobs that will run in the next two days

Summary: Cloud and Datacenter Management MVP, Thomas Rayner, shows how to find all the Azure Automation jobs that will run in the next two days.
Is there a way to find all the Azure Automation jobs that will run in the next two days?

Dr Scripto
PSScriptAnalyzer deep dive – Part 1 of 4

Summary: Thomas Rayner, Microsoft Cloud and Datacenter Management MVP, shows the basics about how to use PSScriptAnalyzer.
Hello! I’m Thomas Rayner, a Cloud and Datacenter Management Microsoft MVP, filling in for The Scripting Guy this week. You can find me on Twitter (@MrThomasRayner),

Dr Scripto
Nearly everything has changed for SQL Server PowerShell

2016 was the best year in SQL PowerShell history! I guess I should have mentioned that here sooner.
Wired® Magazine recently said that Microsoft SQL Server was the surprise hit of the year. The primary cited reason is the SQL Server port to Linux,