This site uses cookies for analytics, personalized content. By continuing to browse this site, you agree to this use. Learn More
A place to learn about PowerShell and share stories of automation
August 21, 2019Aug 21, 201908/21/19Summary: 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.
August 21, 2019Aug 21, 201908/21/19Summary: 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.
August 14, 2019Aug 14, 201908/14/19Summary: 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!
August 14, 2019Aug 14, 201908/14/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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?
July 31, 2019Jul 31, 201907/31/19Summary: 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.
July 31, 2019Jul 31, 201907/31/19Summary: 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.
July 24, 2019Jul 24, 201907/24/19Summary: Targeting Expired Certificates with Get-AuthenticodeSignature
Question: Hey Doctor Scripto! Is there an easy way to visually identify Digitally signed files with an Expired status on the Digital Certificate?
Answer: Absolutely! We just need to filter on the “Status” property and show those without the value ‘Valid’.
July 24, 2019Jul 24, 201907/24/19Summary: 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?
arrays
April 11, 2016Apr 11, 201604/11/16Summary: 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
December 11, 2017Dec 11, 201712/11/17[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,
Azure
August 14, 2019Aug 14, 201908/14/19Summary: 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!
August 7, 2019Aug 7, 201908/7/19Summary: 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.
December 12, 2017Dec 12, 201712/12/17At 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.
December 11, 2017Dec 11, 201712/11/17[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,
November 17, 2017Nov 17, 201711/17/17You’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.
November 15, 2017Nov 15, 201711/15/17Finding 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
January 25, 2017Jan 25, 201701/25/172016 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,
October 25, 2016Oct 25, 201610/25/16SUMMARY: 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).
September 26, 2016Sep 26, 201609/26/16SUMMARY: 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.
July 18, 2016Jul 18, 201607/18/16SUMMARY: 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.
May 16, 2016May 16, 201605/16/16SUMMARY: 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.
April 25, 2016Apr 25, 201604/25/16Summary: 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,
April 6, 2016Apr 6, 201604/6/16SUMMARY: 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();
December 7, 2017Dec 7, 201712/7/17[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,
Delimited files
April 11, 2016Apr 11, 201604/11/16Summary: 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
August 21, 2019Aug 21, 201908/21/19Summary: 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.
August 21, 2019Aug 21, 201908/21/19Summary: 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.
August 14, 2019Aug 14, 201908/14/19Summary: 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!
August 14, 2019Aug 14, 201908/14/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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?
July 31, 2019Jul 31, 201907/31/19Summary: 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.
July 24, 2019Jul 24, 201907/24/19Summary: Targeting Expired Certificates with Get-AuthenticodeSignature
Question: Hey Doctor Scripto! Is there an easy way to visually identify Digitally signed files with an Expired status on the Digital Certificate?
Answer: Absolutely! We just need to filter on the “Status” property and show those without the value ‘Valid’.
July 24, 2019Jul 24, 201907/24/19Summary: 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?
Extensions
November 21, 2017Nov 21, 201711/21/17Visual 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.
November 9, 2017Nov 9, 201711/9/17Consumers 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
April 11, 2016Apr 11, 201604/11/16Summary: 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
May 3, 2016May 3, 201605/3/16Summary: 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.
April 19, 2016Apr 19, 201604/19/16Summary: 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
April 19, 2016Apr 19, 201604/19/16Summary: 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!
July 17, 2019Jul 17, 201907/17/19Summary: 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.
September 15, 2018Sep 15, 201809/15/18Using the Get-Random Cmdlet to select a random list of names instead of numbers
September 15, 2018Sep 15, 201809/15/18Creating sample files with random sizes and dates for use in a Lab
July 16, 2018Jul 16, 201807/16/18Having some fun with Abbott and Costello’s “Who’s on first?” comedy routine, and multiple voices with Bing Speech.
June 29, 2018Jun 29, 201806/29/18Send and receive content to the Text-to-Speech API with PowerShell.
June 15, 2018Jun 15, 201806/15/18Send and receive content to the Text-to-Speech API with PowerShell.
May 31, 2018May 31, 201805/31/18Use Windows PowerShell to access the Cognitive Services Text-to-Speech API.
May 23, 2018May 23, 201805/23/18Normally, 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.
May 9, 2018May 9, 201805/9/18Summary: 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?
March 30, 2018Mar 30, 201803/30/18Summary: 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
December 1, 2017Dec 1, 201712/1/17Today, 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,
November 10, 2017Nov 10, 201711/10/17In 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,
Math
April 14, 2016Apr 14, 201604/14/16Summary: 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.
Microsoft 365
August 14, 2019Aug 14, 201908/14/19Summary: 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!
August 14, 2019Aug 14, 201908/14/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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?
July 31, 2019Jul 31, 201907/31/19Summary: 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.
July 31, 2019Jul 31, 201907/31/19Summary: 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
March 14, 2016Mar 14, 201603/14/16Summary: 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.
.NET
December 11, 2017Dec 11, 201712/11/17One 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,
November 20, 2017Nov 20, 201711/20/17Visual 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
November 20, 2017Nov 20, 201711/20/17On 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,
November 16, 2017Nov 16, 201711/16/17There 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
August 21, 2019Aug 21, 201908/21/19Summary: 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.
August 21, 2019Aug 21, 201908/21/19Summary: 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.
August 14, 2019Aug 14, 201908/14/19Summary: 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!
August 14, 2019Aug 14, 201908/14/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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?
July 31, 2019Jul 31, 201907/31/19Summary: 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.
July 31, 2019Jul 31, 201907/31/19Summary: 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.
July 24, 2019Jul 24, 201907/24/19Summary: Targeting Expired Certificates with Get-AuthenticodeSignature
Question: Hey Doctor Scripto! Is there an easy way to visually identify Digitally signed files with an Expired status on the Digital Certificate?
Answer: Absolutely! We just need to filter on the “Status” property and show those without the value ‘Valid’.
July 24, 2019Jul 24, 201907/24/19Summary: 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?
PowerShell 5
April 6, 2016Apr 6, 201604/6/16SUMMARY: 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,
March 31, 2016Mar 31, 201603/31/16Summary: 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
August 21, 2019Aug 21, 201908/21/19Summary: 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.
August 7, 2019Aug 7, 201908/7/19Summary: 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.
September 15, 2018Sep 15, 201809/15/18Using the Get-Random Cmdlet to select a random list of names instead of numbers
July 16, 2018Jul 16, 201807/16/18I’ve got a script that needs to power off a system after it’s done. How can I accomplish this with PowerShell?
June 29, 2018Jun 29, 201806/29/18Identify your PowerShell environment by making use of built-in PowerShell variables.
June 15, 2018Jun 15, 201806/15/18Make use of the native features of Windows through PowerShell to play sound.
May 31, 2018May 31, 201805/31/18Here’s how to make sure your errors get caught with Try Catch Finally.
May 9, 2018May 9, 201805/9/18How can I use Windows PowerShell to enumerate all certificates on my Windows computer?
March 15, 2018Mar 15, 201803/15/18Summary: Here’s how to use the ConvertTo-HTML cmdlet to build basic HTML content.
Hey, Scripting Guy! Occasionally I need to build basic HTML documents. I heard there was a way to do that with Windows PowerShell.
There most certainly is! Just use the ConvertTo-HTML cmdlet to save the day!
February 28, 2018Feb 28, 201802/28/18Summary: Change the keys to authenticate to Azure RM Cognitive Services, by using Windows PowerShell.
Hey, Scripting Guy! I created the keys for my Rest API. I know I can change them in the web portal, but is there a faster way of doing it through Windows PowerShell?
REGEX
September 30, 2016Sep 30, 201609/30/16Summary: 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.
September 30, 2016Sep 30, 201609/30/16Summary: 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,
April 15, 2016Apr 15, 201604/15/16Summary: 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
October 28, 2016Oct 28, 201610/28/16Summary: 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.
October 28, 2016Oct 28, 201610/28/16Summary: 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),
October 21, 2016Oct 21, 201610/21/16Summary: 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,
October 14, 2016Oct 14, 201610/14/16Summary: 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?
October 14, 2016Oct 14, 201610/14/16Summary: 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),
October 7, 2016Oct 7, 201610/7/16Summary: 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.
October 7, 2016Oct 7, 201610/7/16Summary: 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),
April 15, 2016Apr 15, 201604/15/16Summary: 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
August 14, 2019Aug 14, 201908/14/19Summary: 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.
July 31, 2019Jul 31, 201907/31/19Summary: 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.
July 24, 2019Jul 24, 201907/24/19Summary: 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?
July 17, 2019Jul 17, 201907/17/19Summary: 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.
September 15, 2018Sep 15, 201809/15/18Using the Get-Random Cmdlet to select a random list of names instead of numbers
September 15, 2018Sep 15, 201809/15/18Creating sample files with random sizes and dates for use in a Lab
February 3, 2017Feb 3, 201702/3/17Summary: 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),
February 2, 2017Feb 2, 201702/2/17Summary: 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.
February 1, 2017Feb 1, 201702/1/17Summary: 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),
January 31, 2017Jan 31, 201701/31/17Summary: 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?
Security
April 8, 2016Apr 8, 201604/8/16Summary: 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
May 3, 2016May 3, 201605/3/16Summary: 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
April 11, 2016Apr 11, 201604/11/16Summary: 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
April 15, 2016Apr 15, 201604/15/16Summary: 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.
April 14, 2016Apr 14, 201604/14/16Summary: 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.
April 11, 2016Apr 11, 201604/11/16Summary: 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.
April 8, 2016Apr 8, 201604/8/16Summary: 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
April 13, 2016Apr 13, 201604/13/16Summary: 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,
April 12, 2016Apr 12, 201604/12/16Summary: 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
April 15, 2016Apr 15, 201604/15/16Summary: 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
August 14, 2019Aug 14, 201908/14/19Summary: 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.
October 7, 2016Oct 7, 201610/7/16Summary: 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),
June 24, 2016Jun 24, 201606/24/16Summary: Use the trim() method to remove leading and trailing spaces from a string.
Could you do me a huge favor and show me how to get rid of spaces before and after a string in PowerShell?
No problem at all.
April 13, 2016Apr 13, 201604/13/16Summary: 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,
April 4, 2016Apr 4, 201604/4/16Summary: 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,
February 4, 2016Feb 4, 201602/4/16Summary: 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!
February 3, 2016Feb 3, 201602/3/16Summary: 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*
February 3, 2016Feb 3, 201602/3/16Summary: 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.
February 2, 2016Feb 2, 201602/2/16Summary: 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*
February 2, 2016Feb 2, 201602/2/16Summary: 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,
Visual Basic
November 20, 2017Nov 20, 201711/20/17Visual 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#
November 20, 2017Nov 20, 201711/20/17Visual 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
December 14, 2017Dec 14, 201712/14/17As 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,
December 13, 2017Dec 13, 201712/13/17Last 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.
December 12, 2017Dec 12, 201712/12/17At 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.
December 11, 2017Dec 11, 201712/11/17One 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,
December 7, 2017Dec 7, 201712/7/17[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,
December 7, 2017Dec 7, 201712/7/17[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,
December 6, 2017Dec 6, 201712/6/17[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,
December 5, 2017Dec 5, 201712/5/17[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,
December 4, 2017Dec 4, 201712/4/17[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.
December 1, 2017Dec 1, 201712/1/17Today, 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
November 15, 2017Nov 15, 201711/15/17Whatever 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
December 12, 2017Dec 12, 201712/12/17At 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.
November 21, 2017Nov 21, 201711/21/17Visual 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
December 11, 2017Dec 11, 201712/11/17[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,
December 4, 2017Dec 4, 201712/4/17[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.
November 15, 2017Nov 15, 201711/15/17Whatever 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
November 15, 2017Nov 15, 201711/15/17Whatever 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
November 15, 2017Nov 15, 201711/15/17Finding 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.
Visual Studio Tools for AI
November 15, 2017Nov 15, 201711/15/17Whatever 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
April 6, 2016Apr 6, 201604/6/16SUMMARY: 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,
March 31, 2016Mar 31, 201603/31/16Summary: 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
July 17, 2019Jul 17, 201907/17/19Summary: 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.
February 3, 2017Feb 3, 201702/3/17Summary: 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?
February 3, 2017Feb 3, 201702/3/17Summary: 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),
February 2, 2017Feb 2, 201702/2/17Summary: 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?
February 2, 2017Feb 2, 201702/2/17Summary: 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.
February 1, 2017Feb 1, 201702/1/17Summary: 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?
February 1, 2017Feb 1, 201702/1/17Summary: 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),
January 31, 2017Jan 31, 201701/31/17Summary: 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?
January 31, 2017Jan 31, 201701/31/17Summary: 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),
January 25, 2017Jan 25, 201701/25/172016 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,
