Powershell

Creating a Powershell profile is a great way to create variables or aliases that you can use in your day to day work. The first thing you need to do is see if you already have a Powershell profile. You can do this by running the following Powershell command. test-Path $Profile if you get the following result. False This means that you need to create a Powershell profile.

While searching for ways to generate JSON from SQL Server I found a video on using Powershell to generate JSON using calls to SQL Server. This looked interesting so I tried it out and it worked. Unfortunately it still didn’t validate and just generated rubbish. I loaded the data into a text editor and found that when it hit the line return point it chopped data and added three dots to the end of each line.