Upgrade PowerShell Version

Issue: You need to check your currently installed PowerShell version and upgrade to a newer version. Solution:  1) Check the current version of Powershell 2) Upgrade PowerShell by downloading and installing the corresponding version of Windows Management Framework (WMF).  For example if you want Windows PowerShell 5.0, then you would download Windows Management Framework 5.0 (or 5.1 which is currently in "preview" but will be officially released shortly). Read more [...]

SQL Express 2008 R2 Management Studio installation

Issue: Adding Management Studio to an existing SQL Express 2008 R2 instance can be extremely difficult and frustrating. Solution: The following links can be used to download SQL Management Studio 2008 R2 with SP1 or with SP2.  If you are currently running SQL Express 2008 R2 SP3, then you will need to install management studio 2008 R2 with SP2, and then apply SQL 2008 R2 SP3. SSMS 2008 R2 with SP1: http://www.microsoft.com/en-us/download/details.aspx?id=26727 SSMS 2008 R2 with SP2: http://www.microsoft.com/en-us/download/details.aspx?id=30438 SQL Read more [...]

How to Install Azure PowerShell (Oct 2016)

Installing and getting the Azure PowerShell modules working can be extremely frustrating.  Below I will attempt to streamline the process.  I created this process for Windows Server 2012 R2, however the same steps may work on other versions of Windows Server. Check your current version of PowerShell: Enter the following in PowerShell: $PSVersionTable.PSVersion check that you are on version 5 by looking at the 'major version' column. If you are not on PowerShell 5.0 then you need to install Read more [...]