Worth Corner, Crawley, RH10 7SL

Support Hours - Mon-Sat, 8.00-18.00

Welcome to our PowerShell blog

PowerShell has grown overthe years and become invaluable in the world of SQL Server and automation.

However, it has a quirky syntax and I tend to remember SQL better than anything else, therefore this is my blog to document what I learn as I go...

PowerShell Core ISE (Visual Studio Code)
Now there’s a clue in the title on this one. There is no ISE for PowerShell Core. This is because the ISE was a Windows thing and the whole point of Core is that it’s Cross Platform and therefore they haven’t tried to build in a specific ISE that will work for all OS variants.
However, there’s always an alternative and we have one in the form of Visual Studio Code, our friendly cross platform multi-language supporting application.
Visual Studio Code is a standalone application for Source Code Editing and which works cross platform whether that be Linux, Windows, or macOS.

Installing PowerShell Core on Windows
If you’re thinking of dipping your toe into PowerShell Core to see what it’s about, how it works, and what it does (it’s basically the same as PowerShell 5.1 except cross-platform as discussed in my previous post), then you need to install PowerShell Core.
Luckily it’s a standalone install and will NOT replace PowerShell 5.1 on your desktop or server, running happily side by side. Therefore it’s the perfect way to get started with it and make sure it’s compatible with your needs and scripts before making the full leap.

PowerShell Core - What is it and Why
I’ve been asked this a lot by people recently and I can understand the confusion because it seems that Core is everywhere and yet casual programmers and developers (who, as a SQL guy, are those I tend to deal with) seem unsure what it is and why it exists, yet are being told that they should be using it. Hence I thought I’d just put a quick note in the PowerShell blog about Core even though it’s not a PowerShell exclusive thing, it’s everywhere now, but this is the blog in which it fits best.

So what is Core? Do we need it? Should we all be using it?

Writing to the Console
When you start testing and writing code in PowerShell, one of the most useful things you can do is to return data to the console in order to see what’s happening, what you’ve done etc and keep track of your code as it runs.
PowerShell provides this in a very simple way and, unlike ECHO in DOS, PowerShell provides us with some formatting too, which can make your code look nice and friendly to both testers and developers.

So, without further ado, let’s get straight to it…

1 of 1

SQL  World  CEO
Kevin  Urquhart

iPhone Selfie

I am a SQL Server DBA, Architect, Developer, Trainer, and CEO of SQL World. This is my blog in which I’m simply trying to share my SQL knowledge and experiences with the world.


© Copyright 2020 SQLTraining Ltd.