Tag Archives: PaaS

Azure Technical Fiction

Azure SQL PaaS version confusion

So, it seems that simply obtaining the version information for your SQL PaaS database server isn’t as straightforward as it seems, the official advice from Microsoft is that:


Azure SQL Database is always running on the latest stable version of SQL Server Database Engine and patched OS with 99.99% availability


{from https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-index)


I was checking this yesterday (4th November 2019) and seeing as MS Ignite has just kicked off in Florida and that SQL Server 2019 is not yet generally available (announcement expected at Ignite) I was assuming that our SQL PaaS database servers would be running SQL Server 2017 patched to CU 17.


Off I go to SQL Management studio to verify, I connect to one of my SQL PaaS DB servers and I run:




The server happily responds with:


Microsoft SQL Azure (RTM) – 12.0.2000.8
Oct 12 2019 22:46:48
Copyright (C) 2019 Microsoft Corporation


Version 12.0.2000.8??? What on earth, that’s referring to SQL Server 2014 which was end of support literally a month or so ago.

Some quick research and it seems that the version reported using the @@version command isn’t correct. Next command to try:




Server response:




Well that’s not right. Let’s try something else:




Server response:




Ahhhh that’s more like it, but what does version 15 correspond to? Well it seems it’s SQL Server 2019 – eh? How can that be if it’s not GA yet?


Well, it seems your SQL PaaS really is running on the latest, greatest release of SQL Server. Using the helpful info provided at https://sqlserverbuilds.blogspot.com/ it seems the .1900 refers to a very recent version of SQL Server 2019 which is probably an October 12th release as per the date given by @@version.


TLDR: Your SQL Server PaaS in Azure IS running the latest version of SQL, in fact currently one that isn’t available publicly. Wicked!

AWS Azure

Gap in the market for Recruitment Agencies

I think there’s a gap in the market which recruitment agents could potentially exploit. It’s been many years since I stopped contracting. Now back on the market little has changed in my communication with them.

Lots of roles, lots of JDs, lots on interest. The gap exists between what the JD says and what your CV/experience says. I really think Recruitment Agencies should start an element of providing Skills Training. No not for new up & coming agents to teach them sales techniques, pipeline management etc. No, I think they should offer courses in real world IT skills, if anyone knows where the real skills shortage is it’s recruitment agencies.

question mark read more »

%d bloggers like this: