Summer project – PowerShell IoT – pt 3. Needles and Pins.

Disclaimer: Pictures and GIFs are crap here. Deal with it.

So, I finaly got my PI working as expected, and was ready to start testing stuff.
Looking at the examples of the PowerShell IoT Github page , Lighting a single led would be a good first test.

In the box of goodies  I initialy had purchased I had five LEDs, 10 different resistors, a breadboard and the cables needed.

Before coding however, there is some knowledge needed:

  1. What is this GPIO thing?
  2. How do I know where to connect the cables on my PI?
  3. What are resistors, how do they work, and which one out of the millions available should I use?

So lets answer them in order.
GPIO is, to put it simple, the easiest way to interact with any kind of external device.
Connect your thing with one cable to any GPIO pin, and the other end to ground (‘GND’).
a GPIO pin has two modes you can set it to: High or Low (‘On/Off’ and ‘Up/Down’ are other terms i’ve stumbled accross here, but thats not what Wikipedia says..)
You can actually read and write data to GPIO, but for our test thats not necessary.
There is much more to GPIO, but for now that is nothing we need to know.

A great command I discovered pretty early on was ‘pinout’
As I understand it, this comes as a part of the package gpiozero, but it seems to be installed by default on Raspbian.
It prints out basic info of your Pi, and the layout of the pins. Please note that they are not in order!
If you connect something the wrong way, bad things might happen.
To make things even more interesting, the WiringPi numbers (that PowerShell IoT uses) is not the same as the numbers on the PI pinout command..
A complete map of numbers can be found here.

So step one would be two cables to the PI. One GPIO and one Gnd.

Next up we need to connect the cables to the breadboard, and a resistor on one side of it.
I googled it, looked at resistor calculator apps and so on, but I dont want google to simply solve my problem, I want to know how to solve it myself.
Nothing made it click until i stumbled on a sign in the store where i bought my things that had the following on it (roughly translated from swedish):

Resistance (kΩ) = ( Source voltage (V) -Voltage drop (V) ) / Power (mA)
If my Source voltage is 12V and i want to connect a LED of 3,6V 20mA I need a resistance of 0,42kΩ

PS:> (12-3.6)/20
0,42

Awesome! Learning instead of just repeating what others told me.

Last lesson to learn was that a LED can be connected backwards. It doesn’t work.
After realizing this everything was connected:
Raspberry Pi GPIO18 pin -> Resistance (330Ω) -> LED -> Raspberry PI GND
(This is exactly the same as the example on GitHub)

nor

Fire up pwsh, Import the example LED module and voila!

Once one led is working, connecting more and writing small blink script was as simple as 1-2-3,
And so, my first adventure in to PowerShell IoT ended like this:
Its pronounced 'hyyif'

Thats it for my first venture. Next up will be an accelerometer.
I dont have no code from this available on GitHub, as it is already available in the PowerShell IoT repo.
Lessons learned:
Invest in a real breadboard and a breakout cable / cobbler. Its well worth the few $ it costs and makes it so much easier to connect stuff.

Summer project – PowerShell IoT – pt 2. Installation and prereqs.

Disclaimer: This is just what I did. some of this might actually be unneccesary, irrelevant or just plain weird. If so, let me know, and Ill try and update next time I install Raspbian.

So, to get everything we need up and running,
This is what i ended up with doing.

Download Raspbian and install in using etcher.
A simple guide for this can be found here.

Insert the sd card in the Pi, and boot it up.

After initial setup, start bash (console),  and do the following

  • Expand disk to use all free space on sd card using the following command
sudo raspi-config --expand-rootfs
  • Configure network to use WLAN. This is espacialy needed if you, like me, have a hidden SSID which is not supported in the gui configuration.
sudo nano /etc/wpa_supplicant/wpa_supplicant.conf 

I found a guide here of how to configure it, and my conf file ended up looking like this

network={
        ssid="insert_your_hidden_SSID_here"
        scan_ssid=1
        psk="insert_your_wifi_password_here"
        key_mgmt=WPA-PSK
}

And after doing this, I did a reboot to get connected to my network.

sudo reboot
  • Next step, Install prereqs for PowerShell and PowerShell IoT.
    According to the PowerShell install instructions, we need libunwind8.
    It seems to be some kind of prereq for CoreCLR 2.0 to work properly as it can generate really weird errors if it is missing.
sudo apt-get install libunwind8
  • Install Powershell. Download the latest build from here
    the file you get is a gziped file, that you can install using the following command.
mkdir ~/powershell
tar -xvf ./Downloads/powershell-6.0.2-linux-arm32.tar.gz -C ~/powershell/

This will install powershell in the ~/powershell folder. Feel free to use any folder you like.

  • Install Mono framework. PowerShell-IoT is based on the unosquare raspberryio framework, and that in turn requires a Mono version greater than 4.6 installed. The following commands will upgrade your installed packages, and install mono for you.
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mono-complete
sudo apt-get install dirmngr
# Verify mono version -gt 4.6
mono --version
  • Finaly we install the unosquare raspberyio framework that PowerShell-IoT is based on using nuget. First off, make sure we have nuget installed.
sudo apt-get install nuget
  • Because the nuget version distributed is old, you will get a really weird error when trying to install stuff. Update Nuget exacutable by running the following command.
sudo nuget update -self
  • And finally, we can install raspberryio.
nuget install Unosquare.Raspberry.IO
  • It’s time to enter the world of powershell. Start Powershell using the following command.
sudo WIRINGPI_CODES=1 ~/powershell/pwsh

What is this WIRINGPI_CODES? you ask. a well structured and good explanation can be found on the PowerShell IoT Github page.

Photo from terminal on Raspbian. I have no idea how to do screenshots on Linux. And I know i didnt use the wiringpi variable. Bad Bjompen.

In the next chapter we will finally start to look in to some code and the first project: lighting a Led. ’til then, stay cool in the heatwave.

Summer project – PowerShell IoT – pt 1. The prequel.

Disclaimer, This is jut a prequel, no code is here. If you are just curious about how to get going, read chapter two directly.

Summertime is upon us, and I am in the middle of vacation.
Swedish weather right now is pure terror with forest fires, no rain and I am spending most of the days in the couch just trying to cool down.
What could be a better way than some code?

This spring Microsoft released Powershell IoT,
And there was some presentations of it at PSConfEU.
Since I have a Raspberry Pi, I thought this would be an interesting project to check out, And so, the summer project was decided.

At first I decided something I wanted to automate at home:
I have a crock pot. A cheap one without temp controll and automatic turn off, but it does its job.
If I could get my Pi connected to a temp sensor, using a needle in the food beeing prepared,
My plan was first to set a temerature alarm, but soon I realized I could connect it to a powerswitch,
and automatically turn the Crock Pot to off when meat reaches $temp.
Project one was designed.

Before I started messing with the project itself, I realized I would have to check out how PowerShell IoT works,
so i bought some cheap sensors (temp/humidity and acceleration), a bunch of leds, resistors, cables and a breakout board for design and connections.
All of this added up to a sum of about 20$. IoT stuff is cheap! =)

Good to go, I hit my first hurdle:
I haven’t installed or ran Linux in years.. how do this work?

I started by installing Raspbian, the default Raspbery Pi Operating system.
You can find raspbian here: https://www.raspberrypi.org/downloads/raspbian/
I opted for the desktop version. Why? Easier was my guess.

Secondly, We need to put it on a SD card.
I had a 16Gb card spare, so I used that one, connected to my laptop, and installed the image downloaded using Etcher, found here: https://etcher.io/
All of this is documented fairly well on the Raspbian page, and was very simple.

Throw the SD card in to the Pi, and off we go. I thought.
I started by installing PowerShell for Raspbian. I picked the correct version from https://github.com/PowerShell/PowerShell,
Downloaded it, followed the instructions, and… nothing worked any more.
I ran out of diskspace.
Turns out the default raspbian image only has a 4 gb partition, the rest of the sd card is left unused.

Reinstall, and try again in chapter two.

New work, new life, new blogpost.

Well.. as expected, my plan for once a week went south.
But I finally had something to write about, so here goes.

I was recently tasked with writing a integration for SalesForce at work
Just as any normal task I started with google, what had people done before and was it already solved.
Turns out SalesForce, atlhough it has a really well documented API, does not seem to have a powershell module.

Well, read on to see how awesome it turned out.

First of, i needed a test Salesforce account and settings. Fairly easy, and summarized here:

Data Creation and gathering

  • Create developer account, they are free from here: Salesforce developer account
  • Log in to account webpage
    Note the first letters in the url, https://eu12.lightning.force.com/ eu12 in my case. You’ll need those later.
  • Go to Apps -> App Manager and create a new connected app.
    Note the Consumer key and the consumer secret

    • If you missed them, they can be found in Apps -> connected apps -> manage connected apps
  • Click the small button besides your created app and select ‘View’
    Go to Apps -> Connected Apps -> Manage Connected app -> Click to select your newly created app

    • Check settings for oauth policies. If they are wrong, click edit policies and change
  • Click your user avatar -> settings to go to user settings
  • Select ‘Reset my security token’ to receive user token

You should now have the following infomation:

  • Username (my.user@domain.com)
  • Password (password)
  • Consumer Secret (1234567890123456789)
  • Consumer Key (ReallyLongStringFullOfNumbersLike1234567890AndEvenSomeCharacterrsLike_./ThrownInThere)
  • User Token (25RandomCharactersNumbers)
  • Domain for connection (eu01)

Powershell stuff
Connecting to Salesforce using Oauth password
For all of SalesForce API requests, we need to make sure we use TLS 1.2, but this is not default in Powershell.
To set the security protocol to TLS1.2

> [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

In order to send requests to your SalesForce API you first need to get an access token.
You get this by creating a custom webrequest to the oauth endpoint.
Create a body that looks like this:

$authBody = @{
  grant_type = 'password' # This is a string, not your password, to tell the API we want to use Password authentication.
  client_id = $SalesForceClientID # This is your consumer key previously fetched
  client_secret = $SalesForceClientSecret # This is your consumer secret
  username = $SalesForceUsername # Your username
  password = $PassToken # This is a combination of your password and your token. See below.
}

$PassToken is your password and your user token combined in to one string without spaces. In my example above:

> $Password = 'password'
> $UserToken = '25RandomCharactersNumbers'

PassToken would then be ‘password25RandomCharactersNumbers’

> $PassToken = "$SalesForceServicePassword$SalesForceToken"

Now, remember those first letters in your url at the top? eu12?
You need those to know which host you should talk to.
To receive your token, send a POST request with your body to the URI

> https://<yourdomain>.salesforce.com/services/oauth2/token

In my case, it would be

> https://eu12.salesforce.com/services/oauth2/token

If you are successfull, you should now get back something like this:

> access_token :
> instance_url :
> id :
> token_type : 'Bearer' # This is not user specific. For Oauth it is always bearer.
> issued_at :
> signature :

It is good to keep this one in a variable, since we need it for all requests in this session.

> $AccessToken = Invoke-RestMethod -Uri 'https://eu12.salesforce.com/services/oauth2/token' -Method POST -Body $authBody

Now on to the good stuff.

Sending requests to the SalesForce API
We will start of with something somewhat simple right?
Searching for a user!

SalesForce API is actually quite a mess of different endpoints, and not always easy to navigate.
Fortunately, there is a API browser available online, at https://workbench.developerforce.com/
Log in there using your SalesForce account, and select ‘Utilities’ -> ‘Rest Explorer’ to get to the API browser.
Executing the default ‘Get’ will give us a long list of objects to browse,
One of them is ‘Search’.
Clicking that will however only show an error, as we need to input a query of some kind.

Instead of telling you how i know, lets just say i do know that SalesForce uses something called SOQL, Salesforce Object Query Language.
Read all about that here.
Using this link, and also this
We can now start to construct our query. (Yes, in my case that actually included reading loads of more pages. If you are serious about learning SOQL, you should do it to.)
In the end i get something like this:
FIND+{<search>}+IN+<property>+FIELDS+RETURNING+USER(<userproperties>)
Userproperties? Well, back to the workbench explorer.
Users, and a lot of other things, in Salesforce are called SObjects.
Entering the SObjects API we find a User, and under that a Describe. Describing users sounds good.
This endpoint contains a fields ‘folder’ showing the available properties,
And using this information we can now nomplete the query:

FIND+{björn}+IN+name+FIELDS+RETURNING+USER(id,name,username)

So using the error from the /search url, we can construct a full query URL

/services/data/v41.0/search/?q=FIND+{björn}+IN+name+FIELDS+RETURNING+USER(id,name,username)

Paste it into the Workbench field and execute. Success!
But we are not here to browse stuff.

Using the $accessToken we have, we can create a complete search request.

> $Method = 'Get' # What was set in the workbench
> $URI = "$($AccessToken.instance_url)/services/data/v41.0/search/?q=FIND+{björn}+IN+name+FIELDS+RETURNING+USER(id,name,username)" # The URL from your token plus the relative path from workbench
> $Headers = @{
  'Authorization' = "Bearer $($AccessToken.access_token)"
  'Accept' = 'application/json'
} # See description below

We must alwas set the header in our requests, as that is how we show that we have the correct token.
Using Oauth username password it is always set as the string ‘Bearer access_token’
Also, we always want json offcourse 😉

So lets try it:

> Invoke-RestMethod -URI $URI -Method $Method -Headers $Headers

Success!

And you can now go ahead and start messing about in the SalesForce API.

But I started by saying it turned out awesome.
Just searching using powershell and variables isn’t that nice,
So I wrapped this, and a few more api calls in a module,
Alongside a ‘Invoke-APSalesForceRestMethod’ that automaticatly wraps the token and creates a valid request from it.

Then we managed to convince our employer to open source it.

So without further delay,
you can download / fork / clone our SalesForce module here:
https://github.com/SnowSoftware/AutomationPlatform-SalesForce.Integration
And please help out, send bug reports, add functionality and use it!

And this is the awesome part.
We managed to get our company, Snow Software, to open source our software.
and there is more to come, so stay tuned!

 

Oh, and I still need to learn how to format things on my blog..

 

‘Til nex time, whenever that may be!

ping? pong!

Good morning internet!

If you don’t already do this,
you should start reading /r/PowerShell on Reddit.
Many good questions ranging from total beginner to extremely advanced,
and you get to see problems you never knew other people had.

I try to help out there every now and then,
but mostly someone else beats me to it.
No fake internet points for me.

Today, like many times before, someone asked for tips about ping or similar commands,
so I thought I’d do a blog post about different ways to do it, and do some measuring as well!

Let’s start by checking different methods to do this.
In PowerShell there is a well-known command, Test-Connection, that most of use and love.
Simply put, it is equivalent to CMD’s ping, but with added PowerShell glory.

Next up is a somewhat lesser known one, Test-NetConnection.
This command gives you a little bit of different possibilities and results,
like setting target port (for testing stuff like www, ftp..), tracerouting etc.
More info on MS website.

Third (and forth) will be the .net class System.Net.NetworkInformation.Ping

I set up a quick test environment using four external known hosts that reply to ping.
[string[]]$address = '8.8.8.8','8.8.4.4','4.2.2.2','4.2.2.1'

And just to make sure all of them are actually available, lets test it first.
$address | foreach {Test-Connection $_ -Count 1}
Well, looks good. Let’s see how much time this takes.
PS> Measure-Command -Expression {$address | foreach {Test-Connection $_ -Count 1}} | Select -ExpandProperty Milliseconds
95
95 milliseconds.
After doing this 10 times I get between 95 and 105ms.

Does Test-NetConnection beat it? let’s see!
PS> Measure-Command -Expression {$address | foreach {Test-NetConnection $_ }} | Select -ExpandProperty Milliseconds
347
Whoa! nope, no, njet!
Again, after 10 or so times, average is between 250 and 350ms.
If you are only interested in ping results, avoid this.

So let’s go all in.
We already know using classes are almost always faster,
but it´s not knowledge unless tested.
First up is using good old ping.
PS> Measure-Command -Expression {$address | foreach {[System.Net.NetworkInformation.Ping]::new().Send($_)}} | Select -ExpandProperty Milliseconds
75
Yupp. It’s faster.
average after 10 tests is 69 to 75ms.

So let’s test one more.
[System.Net.NetworkInformation.Ping]::new() contains a method called SendPingAsync()
Normally, you wait for one ping to return, before sending the next one,
but using async we can send them all at the same time, and just await the results.
This is blazingly fast, but it takes a bit of more code to handle.
As it sends the ping request to a background job,
you have to explicitly tell PowerShell to wait for it to finish.
Let’s try.
PS> Measure-Command -Expression {$a = $address | Foreach {[System.Net.NetworkInformation.Ping]::new().SendPingAsync($_)} ; [Threading.Tasks.Task]::WaitAll($a)} | Select -ExpandProperty Milliseconds
39
39ms. Again, 10 tries average 39 to 49ms.
After this, you can use your variable ($a in my case) to check the actual status of your servers.

Final result:
1. SendPingAsync() ~40ms
2. Ping() ~75ms
3. Test-Connection ~95ms
4. Test-NetConnection ~347ms

So, is there a point to all this?
Well, I only tested four servers and there was already a massive speed difference.
No go run this test on a park of thousands of servers.

I highly recommend you read Boe Prox blogpost on speedy ping!,
because we all know you can’t have too many tools in your toolbox.

As for me? I think I have to learn how to write code in a blog post.
I wonder if someone has written a blog post about it..

Monday shorty – Whats in that string?

Happy Monday!

Yes, I know, it´s Wednesday, but yesterday was the national day of Sweden so this is, in fact, the first workday of the week.
Let´s just say ‘Monday shorty’ was probably not the most thought through topic I could have chosen.

Anyway!
How many times have you seen this?
PS:\> $string
abc
PS:\> $string -eq 'abc'
False

Or maybe even this?
PS:\> '^C' -eq '^C'
False

I know I have run in to it a lot of times,
And I have also answered the question on both Facebook and Reddit,
so Here is my solution to the question:
‘What´s in that string?’

Simply convert it to a char array,
and pipe it to a foreach loop converting each char in the array to an int!
PS:\> $string.ToCharArray() | ForEach-Object -Process {[int][char]$_}
97
98
99
32

Ok, I understand if you don’t speak int fluently,
So Here is Wikipedia’s list of ASCII chars.
And lo and behold, a trailing space!

Oh, the other one? Those are, after all, the same characters, right?
PS:\> '^C'.ToCharArray() | ForEach-Object -Process {[int][char]$_}
3
PS:\> '^C'.ToCharArray() | ForEach-Object -Process {[int][char]$_}
94
67

Simple, but useful, just how I like it.

See you next “Monday”

//Bjompen

Get-PSConfEU -Year 2017 | Set-PSConfEU -state ‘Awesome’

On my way home from one more visit to Hannover, and the PSConfEU conference.
Tobias has once again superseded my expectations of a well-organized event,
and I thought I’d go through my conference experience.
Let’s start with the non-technical.

PSConfEU has, both years I have been there, been really good arranged.
The Conference center is nice, and although it´s a bit easy to get lost in the corridors,
it worked out fine thanks to excellent pointers, rollups, markings and most of all the extremely helpful ‘ladies in pink’
The food was descent, but definitely up to par with other conferences I’ve been to,
and I have had far, far, worse ones (Hello Ignite Chicago 2015…).
The Evening event was a visit to the Hannover Zoo.
A nice zoo, where we got to see a show including Caribou, Seals, and most notably,
A Bald eagle flying over the audience so close you could feel its wings in your hair.
After that, it was food and bar at the Zoo restaurant,
with some amazing food, and even more amazing company.

But PSConfEU isn´t just about food and sessions..
The biggest advantage is the social part, and getting to meet, talk to, and get starstruck, by the crème de la crème of the PowerShell society.
With 42 speakers, where 6 was core members from Microsoft, you get the chance to really dig in to the interesting bits,
Whether it’s Azure, PS Core, VSCode, Optimizing or anything else, there is someone here who not only can,
but wants to talk to you about it.
and like someone said in 2016; ‘If you have a PowerShell question, and no one here can answer it, it is impossible to answer’
Everyone here is really nice, and they love talking about what they do!

So, getting down to the sessions.
I Will try to score them on a 1-5 scale (apart from the opening sessions), but please don’t get me wrong..
getting a 1 in PSConfEU sessions is probably like getting a 4 in other conferences anyway!

Wednesday.

Opening Ceremony, 2017-05-03, Tobias Weltner,
Tobias started the conference in a good, funny, and lighthearted beat,
by giving away prices for 2016 best speaker (Will Schroeder), and best beer (Chrissy LeMaire),
talking about last year’s conference, hashtags that came up during ‘pre conference tweeting’ (#PSConfEURoadtrip, #PSConfEUChocolateChalenge)
And I got a new 2016 mug, and started the conference knowing that my so far biggest contribution to the PowerShell society is being a klutz..

Keynote: State of the Union, 2017-05-03, Jeffrey Snover,
Where is PowerShell today, and where are we going? If anyone knows, it´s Jeffrey.
The talk was a lot about PowerShell Core, PowerShell on Linux and OSX,
and the key was ‘any platform, any target, any shell, anywhere’ (no, it’s not a quote, it’s my interpretation of it =) )
PS Core is the future, and although PowerShell for windows isn’t dead yet if you haven´t already, it’s time to start in to digging in to the other platforms as well.
Glad I at least started running PS on OSX =)

PowerShell Warm-Up: Quiz & Quirks, 2017-05-03, Tobias Weltner,
The first day continued with a short session where Tobias told us about random quirks.
Apparently, these were all questions asked by MVP / the ‘smarter than me’ crowd (all names censored off course),
in public discussions, that probably should have been pretty easy to figure out.
One of my favorite pictures is this;
imposter syndrome
Imposter Syndrome is quite common, and I think most of us suffer from it from time to time.
so why do I mention this, and why do I think it is important for this session?
Even the smartest guys I have talked to don’t know everything, and it´s easy to forget that. I´ll get back to this topic later.
In the end, it was a rather funny session, completing the lighthearted feeling of the first morning…

Catch Me If You Can – PowerShell Red vs. Blue, 2017-05-03, Will Schroeder,
..Because then there is this guy.
Will won last years’ best speaker doing the same topic as this year,
and it is amazing how interesting this is.
Will is a fantastic speaker, and the session is about what is going on in the chase of red team (the white hat ‘bad guys’) vs. blue team (white hat ‘good guys’).
Off course, since it is a PowerShell Conference, the main topic was PowerShell security,
and it was very interesting hearing him saying that the PowerShell security is basically so good today,
red teamers are moving towards other surfaces.
I guess my first task when I get home is activate PowerShell logging.
This session also marked the end of the opening sessions, and the start of the room running race. Off we go!

Breakdown the GUI: PowerShell logging to automate everything, 2017-05-03, Jaap Brasser,
Jaap is so cool, Heat don’t stand a chance =)
A talk about what tools you can use, and how to use them,
to automate the stuff, they don’t tell you how to automate.
I found myself knowing the tools used (PowerShell Logging and Procmon), but it´s always nice to get a fresh view of things.
In the end, I´ll give this session a 3/5.

Getting started with Windows Server Containers, 2017-05-03, Flynn Bundy,
In my work we already use Linux containers, and I would really like to start using them on windows as well.
As I am in such a position, this was a really inspiring speech,
and one ill definitely come back to as soon as the vids are online.
Flynn showed how easy it really is to manage, set up, and fix it,
and although I confess, I don’t remember right now how (hey, it’s 12 AM, I’m on a train and have spent 4 days in Hannover),
I left this session inspired and with the feeling that this is something I can, and must, do.
If not for company profit, because it´s fun! And in the end, that’s the feeling a speech should give you.
A solid 4/5 (mainly for my own bad memory and problem taking notes I believe.. Might add 1 after rewatching =) )

When every second counts! 2017-05-03, Mathias R Jessen, Øyvind Kallstad,
think your stuff runs fast? you´re wrong.
I always like to read blogposts and tweets from these guys,
Because it always gives me more knowledge of how to write better scripts.
The base content of the talk was showing time differences between different ways of doing the same thing.
However, I got the impression that they could do much better..
in my opinion it was a bit to low lever, and I would have liked to go more in to the nitty gritty of it.
Details of why it’s faster and what happens behind the scenes.
On the plus side, the slides part was really fun, and kept an easy feeling all the way.
+1 for ‘computers isn´t magic, they are bound to C’
In the end Mathias and Öyvind gets a solid 2/5
(also, Mathias, fix and release Out-Graph 😀 )

Green is bad Red is Good – Turning your Checklists into Pester Tests, 2017-05-03, Rob Sewell,
Rob is probably one of the most inspiring speakers out there,
and if you ever get a chance to see him, do.
This was a pester session, but not one of the ordinary.
Although it was a lot of code involved, the core point was the hows and whys,
which, if you ask me, is actually more useful!
In the end, only I can write my tests, but I do like to get different views of how to think!
He showed lots of examples as how the dbatools.io  team tests, and even though I am not a DBA,
it was really inspiring and gave me a good push in to the Test field.
I seriously think Pester is still far from its potential,
and could be used in many different scenarios we still haven´t figured out.
Let’s go home and see what there is to test. 4/5

Thursday.

PowerShell Microservices: At the Service of DevOps, 2017-05-04, Gael Colas,
Having the first session the day after the big party is hard,
And I sure hope no one fell asleep during morning hours..
Gael knows what he is talking about, and just like Flynn’s session this is one I will get back to later.
The art of writing ‘DevOpsy’ PowerShell scripts isn’t easy,
But Gael put in to words how to think.
Unfortunately, I, just as many with me, was tired, and I will have to watch this session again to get the full content of it.
(?/5, will watch again.. Sorry Gael!)

Start-NewEra -Repo PowerShell, 2017-05-04, Ben Gelens,
An Open Source PowerShell Session held all through using OSX and Open source IDE.
Now tell yourself ten years ago that sentence. Did you believe it? 27 y/o Björn didn´t.
Going in to the details of .net core, and how to build scripts and functions that works well both ways, this was a really interesting session.
Just like Jeffrey said in the opening session, functions will from now on be coded targeting PS core,
and ‘back ported’ to PS for Windows. my big takeaway from this session was ‘if you don’t start learning this now, you’re gonna have a bad time.
Ben is a really good speaker, and I’ll give him a solid 3/5

Performant PowerShell, 2017-05-04, Staffan Gustafsson,
Staffan is a Developer, and most of his speeches has gone ‘swoosh’, right over my head.
This one didn’t.
Instead of showing loads of code, and how to write it,
most of Staffans session was showing graphs! (Off course the graphs was done using PowerShell though)
This, in turn, made this a really useful and interesting session,
as it instead showed direct performance hits using various techniques in coding.
Also, Staffan made a point of using optimizing only when you actually care,
which I really liked hearing (I love getting my opinions confirmed by those smarter than me =) )
In the end, optimizing techniques are always interesting, but in all honesty,
I watch these sessions because I find them interesting more than actual work use.  4/5

Take your Automated Release Pipeline to the next level! 2017-05-04, Jan Egil Ring, Øyvind Kallstad,
A Multicloud release pipeline with automagic failover. sounds good? it is!
Öyvind and Jan Egil showed how to build a release pipeline using both AWS and Azure,
with source control, testing, surveillance and everything else needed.
I have seen a lot of sessions on ‘devops’, ‘ci/cd’ and such,
but not many that actually did it all.
After all, failover and redundancy is the key to a useful cloud strategy.
I really liked this session, since they both showed the automation part, and also the ‘behind the scenes’
Unfortunately, when I tried to re-watch the recorded session, the audio is really horrible,
to the point of unlistenable, so I can’t go back and refresh it.
5/5, useful, interesting and practical. everything done right!

The psychology to building a team that automates, scripts and DevOps’, 2017-05-04, Jeff Wouters,
A PowerShell geek gone psychologist? Yep, that’s Jeff.
I have seen a couple of speeches of him before, and they are mostly enjoyable, and full of laughter.
This one was fun, but in all honesty it felt like he just quoted different psychologists.
The only really fun part for me was when he said
‘stop using curse words, instead just say anything else! like fika!’
Fika is the Swedish word for coffee break, and I think everyone thought I was insane when I laughed at this =)
In his defense, he was called in last minute as Ravi (who should have had more than one talk in the conference) couldn’t get his visa through.

Mastering a complex DSC lab infrastructure – The story of the BMW Group DC deployment, 2017-05-04, Jan-Hendrik Peters, Raimund Andree,
I was not supposed to see this session, but was recommended by Christian Lehrer (@chris_tea) to go anyway.
Apparently they had done a similar session before in German which had been really good.
And I must say; Thank you Christian! This was really cool!
Jan-Hendrik and Raimund have built a module to create advanced lab deployments either on prem, or in azure.
this has been done before, but this one looks like they really thought it through,
and made it to be used by all types of administrators and users (and not just the PowerShell geeks!)
They presented the framework while talking about how they started designing it for a use case in BMW (like the title says..)
This made the talk really interesting, and really easy to keep up with,
as everything was put in place not just with a how, but also a why.
In the end, this framework will probably end up in my toolkit. 5/5

DevOps and the Harmonious Whole, 2017-05-04, Kenneth Hansen,

Friday:

Automation in a hybrid world, 2017-05-05, Jakob Gottlieb Svendsen,
OMS is the key to knowing what is going on in your azure environment,
and Jakob is the guy knowing how to do OMS.
Like I mentioned before, we are currently doing Linux and Docker in Azure,
and we are trying to figure out how, what and why to monitor stuff using OMS.
In the evening party Wednesday, I spent a while listening and talking to Jakob about OMS,
and it was really interesting, so I ended up going to this session,
and it was really worth the watch. loads of info and demos on using Azure Automation and OMS to get what you want.
Yet one more session I will watch online, that left me wanting more. 5/5

Azure Automation – Advanced Runbook Design, 2017-05-05, Jakob Gottlieb Svendsen,
..and more I got.
I confess, I did miss a bit of the needed basic knowledge as I have yet to start using runbooks,
but in the end this was also a really good session which I know I will get back to in the future.
If my mind serves me well, Jakob had to cut this session short because he had to many bullet points.
shame, I really like listening to him,
and if we ever need a consultant to help us with our OMS designing, I will do my best to get Jakob coming to Sweden.
4/5

Demystifying $THIS, $_, $PSITEM, $$, $Whatever…, 2017-05-05, Jason Yoder,
Really? I had the impression from the abstract that this was to be a session diving into some unknown and fun ways of using variables outside of the standard ways,
but it ended up being variables for beginners…
Although Jason is a really good speaker, and he can wake up an audience,
I left this session thinking I could have done a lot more useful stuff.
I feel that the level of PSConfEU should be mainly -ge 500, but this was at most 200.
Sorry Jason, 1/5

Building Your First CI/CD Pipeline in Azure, 2017-05-05, Benjamin Hodge,
Most of the speakers at PSConfEU I follow on social media, and Ben is no exception.
The problem with this is that you often get the impression that you are so far behind everyone else (Again, see the imposter syndrome..)
Bens talk was about building a CI/CD pipeline without actually having to do all the heavy lifting right from the start,
showing what small steps he had taken to do it, and in what order.
‘Sort what you do, do one thing automatically today, one more tomorrow and go on ´til you´re done’
In the end he still was running some stuff manually,
but with all the heavy lifting done by simple scripting.
I found this really useful to see, as I currently find myself in a similar position,
where I want to automate my builds and releases, but don’t really know where and how to start!
I don’t know if I will steal his code, but definitely his ideas. 4/5
(Also, it should be PoshPipe!)

Test your PowerShell code with AppVeyor for ITPros, 2017-05-05, André Kamman,
I´ve been looking in to appveyor for my personal builds,
so this was a given for me.
Turns out André was joined on stage by Rob Sewell also, and it was a blast!
Apparently, they had more or less no practice together doing this speech, and they joked and looked like they were really enjoying themselves.
And they managed to fit in a bit about Appveyor as well!
They showed how easy they were using it in the dbatools.io release pipeline,
and it looked really useful. (not surprised though, many projects use it.. must be good, right?)
4/5, will start using.

AMA – Ask Microsoft Anything, 2017-05-05, Angel Calvo, Bruce Payette, David Wilson, Jeffrey Snover, Joey Aiello, Kenneth Hansen, Mark Gray,
How can you end a conference like this?
with this off course!
It was exactly what the topic said,
with questions from the audience, ranging from light hearted, to advanced, future, to passed.
want to know what they talked about? go watch the video!
I am constantly amazed by how humble and down to earth the main people of Microsoft is..
they are really just glad knowing what they do is useful to people!
And dear Microsoft, we are glad you are doing it. even those of us to starstruck to tell you..
6/5.
quote of the week goes to Jeffrey: ‘I am really glad we paid for your tickets, David’

In the end i would really like to say thank you to everyone involved, everyone i met, and everyone who helped out doing this.
It has been an awesome experience yet again, and i hope to see you all again in 2018!
I recomend you go to PSConfEU on youtube and look at all the sessionvideos,
and to GitHub and download slides and code. I know I will.

Disclaimer: I know citations are wrong, some facts are wrong, I still haven’t reviewed Kenneth´s session, and there might be other things wrong in here as well,
but in all honesty, this is my blog, and my interpretations. Deal with it. I might complete it later.