{"id":7894,"date":"2016-05-10T14:45:08","date_gmt":"2016-05-10T12:45:08","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/"},"modified":"2016-05-10T14:45:08","modified_gmt":"2016-05-10T12:45:08","slug":"sql-server-now-cumulative-updates-cu-need-to-be-install","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/","title":{"rendered":"SQL Server: Now Cumulative Updates (CU) need to be install!"},"content":{"rendered":"<p style=\"color: red\"><strong>\u00a0Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP)<\/strong><\/p>\n<p>In the past, Microsoft always recommended to apply the Service Packs and security fixes for SQL Server.<br \/>\nCumulative Updates were applied only if you had a specific problem in order to resolve it.<\/p>\n<p>Now, we need to follow a new rule:<br \/>\n<em>\u201c Microsoft recommends ongoing, proactive installation of SQL Server CUs as they become available:<\/em><br \/>\n<em> SQL Server CUs are certified to the same levels as Service Packs, and should be installed with the same level of confidence<\/em><br \/>\n<em> Historical data show a significant number of support cases involve an issue that has already been addressed in a released CU<\/em><br \/>\n<em> CUs may contain added value over and above hotfixes such as supportability, manageability, and reliability updates<\/em><br \/>\n<em> As with SQL Server Service packs, Microsoft recommends that you test CUs before deploying to production environments\u201d<\/em><br \/>\nThe update strategy for SQL Server was easy to manage because a Service Pack comes out one per year and you have one year to apply it. For Cumulative Update, the frequency is one per month and it is very difficult to be up to date\u2026<\/p>\n<h3>How to find your current CU &amp; SP?<\/h3>\n<p>You have the classical query with <strong> @@Version<\/strong> which has to be compared to the build version but you have also the possibility to have the information with the <a title=\"MSDN link to SERVERPROPERTY\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms174396.aspx\" target=\"_blank\"><strong>SERVERPROPERTY<\/strong><\/a> function.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT @@VERSION as [Current Version]\nSELECT SERVERPROPERTY('ProductBuildType') as [Current Build]\nSELECT SERVERPROPERTY('PRODUCTLEVEL') as [Current Service Pack version]\nSELECT SERVERPROPERTY('PRODUCTUPDATELEVEL') as [Current Cumulative Update]<\/pre>\n<p>A little example with my VM in SQL Server 2014.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8572 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU01.png\" alt=\"SQL_CU01\" width=\"300\" height=\"163\" \/><\/a><br \/>\nAs you can see, I have only the Service Pack 1 installed on my VM and I apply the latest CU for SQL Server 2014 SP1<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8571 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02.png\" alt=\"SQL_CU02\" width=\"300\" height=\"157\" \/><\/a><br \/>\nEt voila! I\u2019m up to date with my instance until the next CU\u2026 \ud83d\ude09<\/p>\n<h3>How to find the latest CU available?<\/h3>\n<p>Now, you have direct link to find the latest CU:<\/p>\n<ul>\n<li><a title=\"Latest Cumulative Update for SQL Server 2012 SP3\" href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=50733\" target=\"_blank\">Latest Cumulative update for SQL Server 2012 SP3<\/a><\/li>\n<li><a title=\"Latest Cumulative Update for SQL Server 2014 SP1\" href=\"\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=51186\" target=\"_blank\">Latest Cumulative update for SQL Server 2014 SP1<\/a><\/li>\n<\/ul>\n<p>And the old way with the website <a title=\"Microsoft SQL Server Version List\" href=\"http:\/\/sqlserverbuilds.blogspot.ch\/\" target=\"_blank\">\u201cMicrosoft SQL Server Version List<\/a>\u201d\u00a0 is still available of course.<\/p>\n<h3>What are Microsoft recommendations?<\/h3>\n<p><strong><span style=\"text-decoration: underline\">SQL Server 2008 and 2008\/R2<\/span><\/strong><br \/>\nWe recommend to follow your current rule for the patching and apply the new patching strategy only for SQL Server 2012 and later.<br \/>\nIn the most SQL Server 2008\/R2 instances, you will or you are currently migrating to a most recent version. It makes no sense to change the lifetime strategy of your SQL Server 2008\/R2.<\/p>\n<p><strong><span style=\"text-decoration: underline\">SQL Server 2012 and later<\/span><\/strong><br \/>\nFor a new shared instance, install every time the latest Service Pack and the latest Cumulative Update in order to be up to date.<br \/>\nFor a new dedicated instance, check the application recommendation. If the latest Service Pack is supported applied it and apply also the Cumulative Update following the supported Service Pack.<br \/>\nFor a shared or dedicated instance already installed, we recommend to install as soon as possible the latest Service Pack and the latest Cumulative Update with a check frequency of 3 months and every time check with the application of course.<\/p>\n<p>I notice 3 months, why?<br \/>\nIt is very simple, if you have 3 environments like a Test, a UAT\/Pre-Prod and a Prod, per experience, it is good to let one month between all environment patching.<\/p>\n<p style=\"color: red\"><strong>BUT in every case, TEST, TEST and TEST before you patch your Production instances.<\/strong><\/p>\n<p>This is a global recommendation and must be, of course, adapted to your context.<\/p>\n<p><strong>As SQL Server Expert, dbi services also advises to follow these recommendations because a lot of bugs are corrected in the CU and are consolidated by a very strong test plan. As from now, a CU is as reliable as a SP!<\/strong><\/p>\n<p>Don\u2019t hesitate to contact us if you need assist in your patching strategy! \ud83d\ude0e<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP) In the past, Microsoft always recommended to apply the Service Packs and security fixes for SQL Server. Cumulative Updates were applied only if you had a specific problem in order to resolve it. Now, we need to follow a new rule:&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":7897,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[49,155,566],"class_list":["post-7894","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-microsoft","tag-patching","tag-sql-server-2016"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server: Now Cumulative Updates (CU) need to be install! - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP). As SQL Server Expert, dbi services also advises to follow these recommendations because a lot of bugs are corrected in the CU and are consolidated by a very strong test plan. As from now, a CU is as reliable as a SP\" \/>\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-now-cumulative-updates-cu-need-to-be-install\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Now Cumulative Updates (CU) need to be install!\" \/>\n<meta property=\"og:description\" content=\"Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP). As SQL Server Expert, dbi services also advises to follow these recommendations because a lot of bugs are corrected in the CU and are consolidated by a very strong test plan. As from now, a CU is as reliable as a SP\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-10T12:45:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1019\" \/>\n\t<meta property=\"og:image:height\" content=\"532\" \/>\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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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-now-cumulative-updates-cu-need-to-be-install\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server: Now Cumulative Updates (CU) need to be install!\",\"datePublished\":\"2016-05-10T12:45:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/\"},\"wordCount\":615,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SQL_CU02-1.png\",\"keywords\":[\"Microsoft\",\"Patching\",\"SQL Server 2016\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/\",\"name\":\"SQL Server: Now Cumulative Updates (CU) need to be install! - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SQL_CU02-1.png\",\"datePublished\":\"2016-05-10T12:45:08+00:00\",\"description\":\"Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP). As SQL Server Expert, dbi services also advises to follow these recommendations because a lot of bugs are corrected in the CU and are consolidated by a very strong test plan. As from now, a CU is as reliable as a SP\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SQL_CU02-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SQL_CU02-1.png\",\"width\":1019,\"height\":532},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-now-cumulative-updates-cu-need-to-be-install\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: Now Cumulative Updates (CU) need to be install!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: Now Cumulative Updates (CU) need to be install! - dbi services | Blog","description":"Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP). As SQL Server Expert, dbi services also advises to follow these recommendations because a lot of bugs are corrected in the CU and are consolidated by a very strong test plan. As from now, a CU is as reliable as a SP","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-now-cumulative-updates-cu-need-to-be-install\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Now Cumulative Updates (CU) need to be install!","og_description":"Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP). As SQL Server Expert, dbi services also advises to follow these recommendations because a lot of bugs are corrected in the CU and are consolidated by a very strong test plan. As from now, a CU is as reliable as a SP","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2016-05-10T12:45:08+00:00","og_image":[{"width":1019,"height":532,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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-now-cumulative-updates-cu-need-to-be-install\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server: Now Cumulative Updates (CU) need to be install!","datePublished":"2016-05-10T12:45:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/"},"wordCount":615,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02-1.png","keywords":["Microsoft","Patching","SQL Server 2016"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/","name":"SQL Server: Now Cumulative Updates (CU) need to be install! - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02-1.png","datePublished":"2016-05-10T12:45:08+00:00","description":"Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP). As SQL Server Expert, dbi services also advises to follow these recommendations because a lot of bugs are corrected in the CU and are consolidated by a very strong test plan. As from now, a CU is as reliable as a SP","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SQL_CU02-1.png","width":1019,"height":532},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-now-cumulative-updates-cu-need-to-be-install\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: Now Cumulative Updates (CU) need to be install!"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7894","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=7894"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7894\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7897"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}