PowerShell For Programmers: Here Strings, There Strings, Everywhere Some String Strings

There won’t be much code in today’s post, but this can be a useful feature to know about. In addition to the expandable and literal strings we talked about, we can also use something called a Here String. Here strings allow us to have quote characters inside of our string that match the quote characters…


How to fetch a user’s profile from Azure Active Directory using PowerShell

On my recent journey helping customers migrate from TFS to VSTS; one of the most common obstacle is verifying that users marked for active import to VSTS have matching AAD records. Thankfully there is a fairly streamlined way to do this using PowerShell and the Azure Graph API. The magic is in the bellow PowerShell…


PowerShell PowerTip: Grabbing the location your script lives in

One super common thing in PowerShell is to design a script to consume particular files for data. Often times you are building the script right in the folder for your files. However, it can be annoying to give long, literal file paths to a file. Also, if you give that script to someone else, they…


Working with JSON data in PowerShell

Welcome back everyone! This week we will take another look at some common data types we might encounter in the real world: JSON data. JSON data is used pretty frequently on the web if you’re hitting APIs. This not only includes external data (twitter, weather, marvel database), but often includes internal data to your company….


Create database on Azure SQL Managed Instance using PowerShell

Azure SQL Managed Instance is a fully managed SQL Server instance hosted in Microsoft Azure cloud that enables you to work with your databases using standard TSQL or PowerShell. In this post you will see how to create your database using PowerShell. Prerequisites In Azure SQL Managed Instance, you can use PowerShell to create a…


Change size of Azure SQL Managed Instance using PowerShell

Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reserved size of the instance. You can use PowerShell to easily manage size of the instance and automate this process.


PowerShell PowerTip: ISE crashing and auto complete not working

Hi all, I’m going to start putting out these short PowerShell PowerTips every so often. They won’t be full blog posts, but they will be short and useful! Have you been having issues with the ISE crashing and not auto completing since windows update 1803? From what I’ve seen there is a fix for this…

5

Azure API Management PowerShell Cmdlets update

We are pleased to announce that Azure PowerShell Cmdlets version 6.1 is out and contains the following updates related to Azure API Management: AzureRM.ApiManagement is using 2018-01-01 management API version Added support for versions and revisions Added support for ServiceFabric backends Added support for Azure Application Insights loggers Added support for the Basic SKU Added support…


How to deploy to Azure using an ARM template with PowerShell

I wrote this article here “How to use/create ARM templates for deployments” where I show how I generated the ARM template for multiple Azure features existing in a Resource Group.  I then deploy all features using the ARM template using the Template deployment blade in the portal.  This article explains how to run the same…