Speaking at SQL Saturday Munich October 8th!

So last October I attended the first SharePoint Saturday in Munich which was great event and if you want to you can read up about my experience in this previous post.

 

However it seems that in October this year I’ll be returning to Munich for the SQL Saturday event where I’ll be delivering my Why & how to implement PowerShell DSC for SQL Server session.

 

There has been a number of changes to the xSQLServer Resource over at https://github.com/powershell/xSQLServer in the last few months (yay) so there will be some cutting edge new insights into this session so it looks like I know what I’ll be spending my time on soon enough.

 

It’s also a session where I do cram in a lot of information within the hour (originally it was a 2 hour session at SQL Saturday Exeter) so if you attend make sure that you are ready to jot down a fair amount of notes and

 

There are a number of other familiar faces from the SQL Community speaking at the event so I’m looking forward to being able to catch up with them all and meet even more of the amazing #SQLFamily.

#PowerShell Side by Side #ProTip

Today I’m going to share with you a little but simple tip to enable you to do more Side by Side testing of PowerShell v6 with you current installed version in a simpler and less error prone manner.

 

Firstly we will create a new environmental variable which we can do in a number of ways but I quite doing it this way  as its easy enough to script

Function Update-PS6Path {

       

        $PS6LatestPath = Get-ChildItem ‘C:\Program Files\PowerShell’ -Directory |

                         Sort-Object CreationTime -Descending |

                         Select-Object -ExpandProperty FullName -First 1

        [Environment]::SetEnvironmentVariable(“PS6”,$PS6LatestPath,“Machine”)

    }

 

This then means that to Launch PowerShell v6 you can do this in the console to run PowerShell v6 (the latest installed version anyway) and in this case we are passing some of the available arguements to the powershell.exe application as noted at https://msdn.microsoft.com/en-us/powershell/scripting/core-powershell/console/powershell.exe-command-line-help

& $env:ps6 -NoProfile -NoLogo -ScriptBlock { $PsVersionTable } -NoExit

So hopefully this little snippet will help you out in doing some more Side by Side testing as time goes on.