{"id":4558,"date":"2015-05-18T08:41:38","date_gmt":"2015-05-18T06:41:38","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/"},"modified":"2015-05-18T08:41:38","modified_gmt":"2015-05-18T06:41:38","slug":"sql-server-change-management-list-all-updates","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/","title":{"rendered":"SQL Server &#8211; Change Management: list all updates"},"content":{"rendered":"<p>I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"installed-update.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png\"><img decoding=\"async\" title=\"installed-update.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png\" alt=\"installed-update.png\" \/><\/a><\/p>\n<p>I take the opportunity of this blog to remind you in a little introduction the different types of patches for SQL Server:<\/p>\n<ul>\n<li>Service Pack\n<ul>\n<li>Service Pack, known as SP is big set of Hotfixes.<\/li>\n<li>The particularity is that the regression is fully tested and sometimes you can have new features or new enhancements.<\/li>\n<li>The frequency is about 1 per year per version. Generally, the Service Pack 4 is the last one.<\/li>\n<li>The recommendation is to install it (you have 1 year to install it) to continue to have the Microsoft support.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>Cumulative Update\n<ul>\n<li>Cumulative Update knows as CU is a set of bug fixes. The regression is not fully tested.<\/li>\n<li>The frequency is about 1 per 2-3 months per version. The next Service Pack included all CUs.<\/li>\n<li>The recommendation is to install it if you have one of the problems from the bugs list.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>FIX\n<ul>\n<li>FIX is a specific patch to fix a bug or a security problem. It is included in the next CU or SP.<\/li>\n<li>The recommendation is to install a bug fix only if you have a problem but a security fix is to install ASAP.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>GDR\/LDR\/QFE\n<ul>\n<li>In some cases, you find one of this trigram associated to a FIX.<\/li>\n<li>GDR is for &#8220;General Distribution Release&#8221; branch is more tested that a LDR (Limited Distribution Release) or a QFE (Quick Fix Engineering)<\/li>\n<li>In SQL Server, the GDR doesn&#8217;t include previous CUs but the QFE include all previous CUs<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>For example, the security fix KB2977325, MS14-044 for SQL Server 2012.<br \/>\nYou have a GDR and a QFE for SQL Server 2012 Service Pack 1.<br \/>\nGDR is the build 11.00.3153 and is directly after the Service pack 1 (build 11.00.3000)<br \/>\nQFE is the build 11.00.3460 and is between the CU 11 (build 11.00.3449) and the CU 12 (11.00.3470)<br \/>\nYou can see that you have a GDR and a QFE for SQL Server 2012 without the service pack.<\/p>\n<p>My first step was to see on google (like everyone) if a PowerShell command exists to see if I have a list of my Hotfix.<br \/>\nAnd surprise, Get-Hotfix exists, wonderful &#8212; I try it!<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Get-Hotfix.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Get-Hotfix.png\"><img decoding=\"async\" title=\"Get-Hotfix.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Get-Hotfix.png\" alt=\"Get-Hotfix.png\" \/><\/a><\/p>\n<p>I have a lot of KBs but there is no useful information to filter for SQL Server.<br \/>\nAnd when I search the specific KB2674319 for the SQL Server 2012 Service Pack 1, I don&#8217;t find it.<br \/>\nI have just updates and security fix&#8230; it&#8217;s a shame!<br \/>\nIn the note from the msdn <a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/hh849836.aspx\">here<\/a>, you find &#8220;This cmdlet uses the Win32_QuickFixEngineering WMI class&#8221; and then you understand that it is just for Quick Fix Engineering (QFE).<\/p>\n<p>I continue my investigation and find the PowerShell Object &#8220;Microsoft.Update.Session&#8221;.<br \/>\nLike Get-Hotfix, it is based on the Win32_QuickFixEngineering, I don&#8217;t have the SP1 but I have more information for hotfixes.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SP_list.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SP_list.png\"><img decoding=\"async\" title=\"SP_list.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SP_list.png\" alt=\"SP_list.png\" \/><\/a><\/p>\n<p>My last search was the good one. It is to check directly the registry on the uninstall key (old method can every time be the best).<\/p>\n<p>All installations are recorded in the key:\u00a0<strong>HKLM:\\SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Uninstall<\/strong><br \/>\nA filter with &#8220;<strong>Hotfix*SQL*<\/strong>&#8221; and &#8220;<strong>Service Pack*SQL*<\/strong>&#8221; is apply to have just information about SQL Server.<br \/>\nWe can add the version if needed like this: &#8220;Hotfix*SQL*2012*&#8221;<\/p>\n<p><code>Get-ChildItem -Path HKLM:\\SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Uninstall | Get-ItemProperty | Sort-Object -Property DisplayName | Select-Object -Property DisplayName, DisplayVersion, InstallDate | Where-Object {($_.DisplayName -like \"Hotfix*SQL*\") -or ($_.DisplayName -like \"Service Pack*SQL*\")}| Format-List<\/code><\/p>\n<p>And voila! I have all updates of SQL Server on my server.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"hotfix_sp_list.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/hotfix_sp_list.png\"><img decoding=\"async\" title=\"hotfix_sp_list.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/hotfix_sp_list.png\" alt=\"hotfix_sp_list.png\" \/><\/a><\/p>\n<p>Finally, the morality of this story is to take care when you use a PowerShell Command and search with the WMI Class associated to the cmdlet.<br \/>\nThis feature is included in our tool <a href=\"https:\/\/www.dbi-services.com\/offering\/products\/database-management-kit-dmk\/\">DMK SQL Server<\/a> to manage SQL Server instances.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this blog to remind you in a little introduction the different types of patches for SQL Server: Service Pack Service [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":4559,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[49,272,51,53],"type_dbi":[],"class_list":["post-4558","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-microsoft","tag-powershell","tag-sql-server","tag-windows-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server - Change Management: list all updates - dbi Blog<\/title>\n<meta name=\"description\" content=\"Search alll SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server - Change Management: list all updates\" \/>\n<meta property=\"og:description\" content=\"Search alll SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-18T06:41:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1049\" \/>\n\t<meta property=\"og:image:height\" content=\"655\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server &#8211; Change Management: list all updates\",\"datePublished\":\"2015-05-18T06:41:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/\"},\"wordCount\":609,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png\",\"keywords\":[\"Microsoft\",\"PowerShell\",\"SQL Server\",\"windows server\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/\",\"name\":\"SQL Server - Change Management: list all updates - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png\",\"datePublished\":\"2015-05-18T06:41:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Search alll SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png\",\"width\":1049,\"height\":655},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server &#8211; Change Management: list all updates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server - Change Management: list all updates - dbi Blog","description":"Search alll SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server - Change Management: list all updates","og_description":"Search alll SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/","og_site_name":"dbi Blog","article_published_time":"2015-05-18T06:41:38+00:00","og_image":[{"width":1049,"height":655,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server &#8211; Change Management: list all updates","datePublished":"2015-05-18T06:41:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/"},"wordCount":609,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png","keywords":["Microsoft","PowerShell","SQL Server","windows server"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/","name":"SQL Server - Change Management: list all updates - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png","datePublished":"2015-05-18T06:41:38+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Search alll SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/installed-update.png","width":1049,"height":655},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-management-list-all-updates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server &#8211; Change Management: list all updates"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4558"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4558\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4559"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4558"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}