{"id":2820,"date":"2012-11-16T06:09:48","date_gmt":"2012-11-16T05:09:48","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/"},"modified":"2012-11-16T06:09:48","modified_gmt":"2012-11-16T05:09:48","slug":"sql-server-2012-service-pack-1-sp1-now-available","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/","title":{"rendered":"SQL Server 2012: Service Pack 1 (SP1) now available"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg\" alt=\"\" \/><\/p>\n<p>Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website.<\/p>\n<p>SQL Server 2012 Service Pack 1 includes SQL Server\u00a02012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included.<\/p>\n<h3>Which issues are fixed in the SP1:<\/h3>\n<p>There are 13 issues fixed:<\/p>\n<ul>\n<li>2 for Availability Group<\/li>\n<li>1 for SSIS<\/li>\n<li>1 for Data Quality Client<\/li>\n<li>4 for Data Quality Services<\/li>\n<li>1 for Cluster<\/li>\n<li>4 for Master Data Services<\/li>\n<\/ul>\n<p style=\"padding-left: 60px;\"><a class=\"easyblog-thumb-preview\" title=\"Chart2_SP1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Chart2_SP1.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Chart2_SP1.jpg\" alt=\"\" \/><\/a><\/p>\n<h3>What\u2019s new for SQL Server 2012 SP1:<\/h3>\n<ul>\n<li>Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade<\/li>\n<li>Selective XML Index<\/li>\n<li>DBCC SHOW_STATISTICS works with SELECT permission<\/li>\n<li>New DMV returns statistics properties(sys.dm_db_stats_properties)<\/li>\n<li>SSMS Complete in Express<\/li>\n<li>SlipStream Full Installation(You can install a SQL Server 2012 SP1 directly)<\/li>\n<li>Business Intelligence highlights (with SQL Server 2012 SP1, Office and SharePoint Server 2013 )<\/li>\n<li>Management Object Support Added for Resource Governor DDL<\/li>\n<\/ul>\n<h3>Historic of SQL Server 2012<\/h3>\n<p>If you update your SQL Server 2012, you will have a new build version: 11.00.3000.<br \/>\nI give you a quick summary of Microsoft SQL Server 2012 builds since the beginning:<\/p>\n<table border=\"0\">\n<tbody>\n<tr>\n<td style=\"background-color: #0000ff;\"><strong><span style=\"color: #ffffff;\">Date<\/span><\/strong><\/td>\n<td style=\"background-color: #0000ff;\"><strong><span style=\"color: #ffffff;\">SQL Server 2012 version<\/span><\/strong><\/td>\n<td style=\"background-color: #0000ff;\"><strong><span style=\"color: #ffffff;\">Build<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">November 2010<\/td>\n<td style=\"border: 1px solid #000000;\">Community Technology Preview 1 (CTP1)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.1103<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">July 2011<\/td>\n<td style=\"border: 1px solid #000000;\">Community Technology Preview 3 (CTP3)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.1440<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">November 2011<\/td>\n<td style=\"border: 1px solid #000000;\">Release Candidate 0 (RC0)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.1750<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">December 2011<\/td>\n<td style=\"border: 1px solid #000000;\">Release Candidate 1 (RC1)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.1913<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\"><strong>March 2012<\/strong><\/td>\n<td style=\"border: 1px solid #000000;\"><strong>RTM<\/strong><\/td>\n<td style=\"border: 1px solid #000000;\"><strong>11.00.2100<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">April 2012<\/td>\n<td style=\"border: 1px solid #000000;\">Cumulative Update 1 (CU1)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.2316<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">June 2012<\/td>\n<td style=\"border: 1px solid #000000;\">Cumulative Update 2 (CU2)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.2325<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">August 2012<\/td>\n<td style=\"border: 1px solid #000000;\">Cumulative Update 3 (CU3)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.2332<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">October 2012<\/td>\n<td style=\"border: 1px solid #000000;\">Microsoft Security Bulletin MS12-070<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.2376<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\">October 2012<\/td>\n<td style=\"border: 1px solid #000000;\">Cumulative Update 4 (CU4)<\/td>\n<td style=\"border: 1px solid #000000;\">11.00.2383<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000;\"><strong>November 2012<\/strong><\/td>\n<td style=\"border: 1px solid #000000;\"><strong>Service Pack 1 (SP1)<\/strong><\/td>\n<td style=\"border: 1px solid #000000;\"><strong>11.00.3000<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>If you want more informations and download this SQL Server 2012 Service Pack 1 click <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=35575\">here<\/a>.<\/p>\n<h3>Conclusion<\/h3>\n<p>After eight months Microsoft has released first Service Pack for SQL Server 2012.<br \/>\nSQL Server Service Pack 1 includes fixes to issues and also quit a lot of good new features.<br \/>\nService Pack are very critical and important for bug fixing point of view and product upgrade so take care to install it quickly.<br \/>\nMicrosoft has also released in october a Security Bulletin to resolve a vulnerability in Microsoft SQL Server on systems running SQL Server Reporting Service. So if you use SSRS don&#8217;t forget also to install this <a href=\"http:\/\/technet.microsoft.com\/en-us\/security\/bulletin\/ms12-070\">security patch<\/a>.<br \/>\nMicrosoft provides also <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=35580\">SQL Server 2012 Feature Pack<\/a> which is a collection of stand-alone packages which provide additional value for Microsoft SQL Server 2012 SP1.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website. SQL Server 2012 Service Pack 1 includes SQL Server\u00a02012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included. Which issues are fixed [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":2821,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[],"type_dbi":[],"class_list":["post-2820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey"],"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 2012: Service Pack 1 (SP1) now available - dbi Blog<\/title>\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-2012-service-pack-1-sp1-now-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012: Service Pack 1 (SP1) now available\" \/>\n<meta property=\"og:description\" content=\"Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website. SQL Server 2012 Service Pack 1 includes SQL Server\u00a02012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included. Which issues are fixed [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-16T05:09:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"473\" \/>\n\t<meta property=\"og:image:height\" content=\"65\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\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 Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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-2012-service-pack-1-sp1-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server 2012: Service Pack 1 (SP1) now available\",\"datePublished\":\"2012-11-16T05:09:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/\"},\"wordCount\":362,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg\",\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/\",\"name\":\"SQL Server 2012: Service Pack 1 (SP1) now available - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg\",\"datePublished\":\"2012-11-16T05:09:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg\",\"width\":473,\"height\":65},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012: Service Pack 1 (SP1) now available\"}]},{\"@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\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is 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. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012: Service Pack 1 (SP1) now available - dbi Blog","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-2012-service-pack-1-sp1-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012: Service Pack 1 (SP1) now available","og_description":"Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website. SQL Server 2012 Service Pack 1 includes SQL Server\u00a02012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included. Which issues are fixed [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/","og_site_name":"dbi Blog","article_published_time":"2012-11-16T05:09:48+00:00","og_image":[{"width":473,"height":65,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server 2012: Service Pack 1 (SP1) now available","datePublished":"2012-11-16T05:09:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/"},"wordCount":362,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg","articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/","name":"SQL Server 2012: Service Pack 1 (SP1) now available - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg","datePublished":"2012-11-16T05:09:48+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2012.jpg","width":473,"height":65},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-service-pack-1-sp1-now-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012: Service Pack 1 (SP1) now available"}]},{"@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\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is 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. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2820","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\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2820"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2820\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2821"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2820"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}