PowerShell Core ISE (Visual Studio Code)
Produced: 22/03/2021 10:41:00
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
Produced: 20/03/2021 06:01:00
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
Produced: 18/03/2021 09:04:00
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?

Splitting a Table Full of Strings into Columns
Produced: 11/03/2021 09:52:00
This was a fun afternoon I spent getting this working nicely. I don’t know if there are better ways of doing this, but if there are then the internet isn’t the place to look because if you type in string split you’ll get a whole bunch of pages about splitting a string… but just an individual string.

What I wanted was to be able to take a table full of delimited strings and make them into columns so that I could insert them into a table. So here’s what happened…

Stop, Start, and Remove Containers
Produced: 05/02/2021 09:22:00
I’ve covered a lot of the creation and usage of a Container, but it’s very unusual that you’d want to create one, get it running, and then leave it that way.

Generally you want to stop and start the Container on demand, and eventually you’ll want to remove it entirely.

Therefore let’s have a look at that.

This is actually nice and easy (most things in Docker are once you’re used to the syntax and the nuances).

1 of 57