Saturday, June 9, 2018

New SQL Version Life Cycle tool

Introducing my latest SQL Server Life Cycle and Versions lookup tool.

Back in 2016 I released the first version of this app and the goals were the same. Provide an interface to easily lookup a SQL version number and find out the support status of that released. All backed with an API that could be queried from scripts and other tools.

This new release is a complete re-write and includes a modern responsive site written in Angular (because I felt the need to learn).

With this initial release I am providing the following capabilities in the UI:

Version Search

The search feature allows you to lookup a specific release of SQL Server or version number and then see all the releases that match that search result. In the results you can see the release date, mainstream and extended support dates.

Clicking on a row in the results will open the

Life Cycle

The life cycle search page is just a page to quickly lookup when certain branches of a product release will end mainstream support or extended support. This was created as while onsite consulting I sometimes need the ability to quickly look up life cycle information rather than a specific version. It was also a "wish list feature" from a customer I was working with at the time.

Health Check [beta]

The health check is a beta release of my end goal which is to allow you to enter your version number and get basic recommendations about how to upgrade. The initial release simply recommends to either start planning to upgrade or to urgently upgrade depending on that versions support status. My vision for this feature is to provide guidance about updates that have been released on the same branch to stay current and also life cycling plans for upgrades to service packs or next release.


One of my main goals with this app was to ensure that it had an API which could be queried and then used to extend other tools and scripts. For example you could incorporate it into a Health Check Script to retrieve the version number from the SQL Instance and then call the API to get information about the life cycle and support of that release. Or you could use Power BI taking data from your CMDB and performing a lookup against the API for the rows or a search against the API and store that as a query with a relationship link.

The following code provides an example of using the API in a Health Check script. The code is available at

# Import the SQL Module
Import-Module SqlServer;

# Get the version number via appropriate method
$VersionNumber = Invoke-Sqlcmd -ServerInstance $SqlServerName -Query "SELECT SERVERPROPERTY('PRODUCTVERSION')";
$VersionNumber = $VersionNumber.Column1;

# Call the API to get the version information
$VersionData = Invoke-RestMethod -Uri "$($VersionNumber)";

# Want to improve your Health Check script, calculate the health of Support Status
if ($VersionData.ExtendedSupportEnd -le (Get-Date)) {$SupportStatus = 'Critical'}
elseif ($VersionData.MainstreamSupportEnd -le (Get-Date)) {$SupportStatus = 'Warning'}
else {$SupportStatus = 'Ok'}

# format the output data string
$OutputData = @"
Instance = $($Instance.Name)
Version = $($VersionData.BuildVersion)
Product = $($VersionData.ProductName)
Branch = $($VersionData.BranchName)
Update = $($VersionData.BuildUpdate)
MainstreamSupportEnd = $($VersionData.SupportEndMainstream)
ExtendedSupportEnd = $($VersionData.SupportEndExtended)
SupportStatus = $($SupportStatus)

# Return the hashtable

Soon, I will update the samples repository I provided for the previous version to reflect the new API syntax.

Lastly a note on the data. There is no dynamic link from this data to any Microsoft or other site. The data is provided "as-is" and manually maintained by myself and a few trusted peers. We do our best to make sure it is up to date and accurate but for any business critical or commercial decision make sure you refer to the official sources.

If you like this tool, or have some ideas for improvements, or even notice inaccuracies in the data please let me know.

Legal Stuff: The contents of this blog is provided “as-is”. The information, opinions and views expressed are those of the author and do not necessarily state or reflect those of any other company with affiliation to the products discussed. This includes any URLs or Tools. The author does not accept any responsibility from the use of the information or tools mentioned within this blog, and recommends adequate evaluation against your own requirements to measure suitability.


  1. Welcome to replica watches sale here. Swiss Replica Watches On Sale, replica Cartier watches UK
    Rolex, Audemars Piguet, Hublot, Panerai and many more Swiss hand made replica watches with Swiss clone movements.

  2. Et par hundre quid vil kjøpe deg en flott klokke i sin egen rett uten å måtte ty til
    kjøpe en falsk. billig klokker til salgs Visse Seiko klokker eller små merker som Smiths eller Precista fra
    Timefactors har stort følgende og med rette. billig rolex klokker De har flotte, holdbare mekaniske bevegelser og vil tjene i mange år.

  3. Comprar Hublot Fake Clock, Best Breitling,repliki zegarków Breitlingbreitling replica, italo fontana underwater, repliki cartier, zegarki hublot replica, fałszywe zegarki breitling, replica montblanc, come buy heretanie ZegarkiRolex fałszywe zegarki, oglądać breitling repliki, repliki zegarków marki heuer, omega oglądać kopię, rolex fałszywe omega tańsze.

  4. La moitié de la chaussure est l’une des couleurs les plus populaires (Tonal noir ou gris, crème et jaune), l’autre moitié montre un regard complètement différent. Split au milieu sont probablement imitation balenciaga pas cherles itérations les plus frappantes des anciennes chaussures grumeleuses. D’autres couleurs sont nouvelles versions de « plus maigres » Triple S, avec un peu l’image de marque drapeau au lieu de la broderie, ici en imitation balenciaga sandalesjaune / jaune / noir et reintonweiß tandis qu’un pantalon d’été silhouette brodée bleu / crème / offre vert / noir panneaux, jaune lacets bouclés

  5. Moncler have been developing their ski-inspired apparel since founded in 1952, moncler jackets for sale popular for their luxe quilted down coats originally produced for extreme cold-weather conditions. cheap moncler parka Sportswear-inspired clothing combined with street-style provides practical and versatile daily-wear pieces including Moncler t-shirts and polos perfect under a lightweight jacket.

  6. Buy hublot fake watch, best breitling replica, breitling mini for watch , breitling replikas, u-boat italo fontana, replica cartier, hublot replica watches, fake watches breitling, replica montblanc, come here buy replica TAG HEUER watches , rolex watches fake, watch replica breitling, replica tag heuer watches, cheapest fake rolex.

  7. Thank you so much for the great and very beneficial stuff that you have shared with us. replica watches india

  8. Giuseppe Zanotti was born replica sneakers in San Mauro Pascoli, replica jimmy choo an Adriatic town with a long tradition of shoemaking. He has worked in luxury footwear for women for over twenty years, beginning as a design apprentice before making a name for himself as a footwear designer for Italian and international companies. In 1994, Giuseppe Zanotti decided to try his hand in his own business. There followed a steady rise to distinction which fully justifies the international acclaim he now enjoys.

  9. The AAA Cartier Replica watches sale at are uk replica watchesbest quality cheap fake watch from China,The high end Cartier replica watches include Ballon Bleu De Cartier, replica cartier watchesCalibre De Cartier,Cartier La Dona,Cartier Love Watch,Cartier Pasha,Cartier Roadster,Cartier Santos,Cartier Tank replica watches,We can shipp to Uk,USA,canada,australia,and almost all country worldwide

  10. Longines watches have been a landmark of the industry since their brand began best replica watches in 1832 in Saint-Imier. Today, the brand offers a wide variety of watches for men and women. Watches manufactured by Longines have been utilized throughout history for replica Longines Elegant watches everything from exploration ventures to the expression of elegance. In addition to being famous for their ties to the racing and equestrian worlds, Longines watches are globally recognized for their timeless chic sophistication. we have a variety of Longines watches for sale, all new, beautiful, and guaranteed to be genuine. Even better, when shopping our Longines watches online, you know you are getting the best value. Browse our selection to find the Internet’s best Longines watch price.

  11. Highly energetic blog, like it. Read replica watches india buying tips from Datsbrand website.