PowerShell Archives - Jonathan Crozier

Formatting JSON with proper indentation using PowerShell

PowerShell is a powerful scripting language that makes working with data a breeze, allowing you to import and export to a variety of common file formats such as CSV, XML, and JSON. However, when it comes to JSON, the formatting applied by the built-in ConvertTo-Json cmdlet leaves a lot to be desired. While this may…

How to update Azure Web App TLS/SSL bindings in bulk using PowerShell

InScripting Security Web

If you have an Azure Web App with multiple custom domains and you want to enable TLS (Transport Layer Security), you’ll need to add a TLS/SSL certificate binding for each hostname. These bindings can be configured individually via the Azure Portal web interface. However, if the number of hostnames is large, updating the TLS/SSL binding…

Send a Mailgun email via PowerShell

InScripting

Mailgun is a popular email delivery service that is built for developers and combines high reliability with scalability. PowerShell is a cross-platform scripting language that allows tasks to be automated on Windows, Linux, and macOS using the power of .NET. When developing PowerShell scripts that are running automatically on a schedule, it’s often useful to…

File backup to network drive using PowerShell

InScripting

When it comes to backing up files, sometimes the simplest option is best. If you’re looking for a quick, straightforward, yet flexible solution for backing up files and folders, a PowerShell script can be a great choice. By creating your own backup script, you can stop relying on third-party programs to do the job for…

Connecting to SQL Server from PowerShell

InScripting SQL

PowerShell is an awesome scripting language with many powerful features. This includes integration with SQL Server; a fantastic database engine that is both reliable and battle-tested. If you need to automate repetitive and/or time-consuming DBA processes, connecting PowerShell to your SQL Server instance can be a massive help. In this article, we are going to…

PowerShell Quickstart – How to get up and running fast!

InScripting

If you’re seeking to get up and running quickly with PowerShell and you aren’t sure where to start, you’ve come to the right place! PowerShell is an invaluable scripting tool for both system administrators and developers alike. Getting up to speed with it will make for a very useful addition to your toolkit. In this…

Tag: PowerShell

Formatting JSON with proper indentation using PowerShell

How to update Azure Web App TLS/SSL bindings in bulk using PowerShell

Send a Mailgun email via PowerShell

File backup to network drive using PowerShell

Connecting to SQL Server from PowerShell

PowerShell Quickstart – How to get up and running fast!

Introduction to the SQL Server MERGE statement

Operating on data via a SQL Server Stored Procedure efficiently with Table-Valued Parameters using C#

Enable ahead-of-time (AOT) compilation for Blazor WebAssembly