Saturday, June 9, 2018

New SQL Version Life Cycle tool

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

https://sqlversions.azurewebsites.net

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.




API

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 https://gist.github.com/Matticusau/5778b90507cb7274deebc12cf4360c1c

# 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 "http://sqlserverbuildsapi.azurewebsites.net/api/builds?version=$($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
$OutputData

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.

4 comments:

  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.

    ReplyDelete
  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.

    ReplyDelete
  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.

    ReplyDelete
  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

    ReplyDelete