If you write code to SQL Server then you might be interested in this: at the end of 2017 I wrote a tSQLt tdd training course which has helped over 300 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club. The course is free if you are happy to wait 10 weeks to complete it, with 1 lesson being made available per week - if you are in more of a hurry or you would like to help support the project you can purchase the course which makes it instantly available to you.
I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite a pain to work with, visualizing what it is that the functions will resolve to is often hard.
If you haven’t used an ARM template, ARM templates are JSON documents which are effectively a whole load of properties made up of a name and a value. The value can either just be a value or it can include arm template functions. If we look at this example:
The value for type, apiVersion, sku name and kind are standard values, standard hardcoded values. The value for name and location are determined at runtime - you can tell the difference because the functions are wrapped in [ and ]. In this case “[variables(‘storageAccountName’)] just grabs a value variable. Variables are defined by a json object called “Variables”. Location’s [resourceGroup().location] is a little more complicated. It calls a function “resourceGroup()” which returns an object and then the value of location is used.
When I was doing this, two things really stood out as not being quite right, the first was the ‘greater’ function - what this does is:
“Checks whether the first value is greater than the second value.”
‘A’ is greater than ‘a’
So, I grabbed a copy of the Azure Stack SDK and started the download, I thought it would be an installer, install some stuff and then grab the files but it turned out to be a little bit harder.
The setup for Azure Stack is basically:
- Download VHDX of Windows 2016 with a Setup folder
- Run a script that:
- Validates you meet the minimum requirements
- Creates some virtual machines
- Creates a storage cluster
- Does some other stuff
I initially grabbed started the machine and started the installation and it failed pretty quickly because I didn’t have a butt load of ram on my laptop and I wasn’t running on bare metal and I didn’t have enough disk space. I found that these checks were pester tests so I deleted them and the install continued merrily along (albeit slowly, you need hours to install Azure Stack). I also had to enable nested virtualization on the Azure Stack VM on my laptop using:
Set-VMProcessor -VMName stacky -ExposeVirtualizationExtensions $true
Eventually, I got the install running and after a while, I noticed that there was a vhdx being attached to one of the new virtual machines that was called “CommonNugets”. Being a nosy sort of a fellow I stopped the install and the Virtual Machine, mounted the original VHDX that had been created by the AzureStack installer and had a poke around until I found this nuget file:
This nuget file contained, drum roll please….
I have tried to search for some reference to EDM but it seems it is Microsoft internal as I cannot find any reference to it at all.
So, inside this dll, it shows that they use Antlr.Net to parse the code values in the text. I was particularly pleased that we both worked out if a value was a standard value or a template function, in the same way, basically doing:
(expression.First() == ‘[’)) && (expression.Last() == ‘]’));
Now, ‘greater’ how is it implemented by Microsoft?
First, they check if either the first or second parameters are strings if they are then if one is a string and one is not a string then they throw an exception.
Assuming that both are strings then they use the .net string.Compare to return an int, if string.Compare returns 0 or greater then the first value is greater than the second.
“string.Compare” is implemented by “System.Globalization.CompareInfo” because as well as the two strings they also pass in “StringComparison.InvariantCulture”.
If we look at https://docs.microsoft.com/en-us/dotnet/standard/globalization-localizat… we can see that “FILE” is greater than “file” when using “StringComparison.InvariantCulture” so what we have isn’t a straight map to the ASCII table but the sort order that windows uses.
Once I knew they had their own parser then the whole if / if_ regex thing became clear. I guess now I can fix greater at some point - I won’t rush as calling greater on a pair of strings just seems a bit odd to me and I probably won’t use it but at least now I can sleep without wondering how ‘greater()’ was implemented.