{"id":11036,"date":"2018-03-20T12:18:19","date_gmt":"2018-03-20T11:18:19","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/"},"modified":"2018-03-20T12:18:19","modified_gmt":"2018-03-20T11:18:19","slug":"sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/","title":{"rendered":"SQL Server 2017: Can I run a &#8220;standard&#8221; rebuild on the index after a Resumable Online Index Rebuild is suspended?"},"content":{"rendered":"<p>This article is an additional article to my precedent about \u201c<a title=\"SQL Server 2017: What\u2019s happens with an interruption during a Resumable Online Index Rebuild\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-whats-happens-with-an-interruption-during-a-resumable-online-index-rebuild\/\" target=\"_blank\">SQL Server 2017: What\u2019s happens with an interruption during a Resumable Online Index Rebuild?<\/a>\u201d<\/p>\n<p>The goal is to see after I suspend the rebuild, if I can run a traditional rebuild without the option RESUME.<\/p>\n<p>&nbsp;<\/p>\n<p>I start an index rebuild with the option Resumable:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ALTER INDEX [NCI_dbo_Transaction] ON [dbo].[Transaction]\nREBUILD WITH (RESUMABLE = ON, ONLINE = ON)\nGO\n<\/pre>\n<p>&nbsp;<\/p>\n<p>In a new query window, I stopped the rebuild:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE [WideWorldImportersDW]\nGO\nALTER INDEX [NCI_dbo_Transaction] ON [dbo].[Transaction] \nPAUSE\nGO\n<\/pre>\n<p>&nbsp;<\/p>\n<p>As you can see, the index rebuild is stopped:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_00.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-21912 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_00.jpg\" alt=\"riro2_00\" width=\"300\" height=\"116\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>I have a look on the index state with the DMV sys.index_resumable_operations:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-21911 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_01.jpg\" alt=\"riro2_01\" width=\"300\" height=\"104\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>To restart, I run the rebuild without the RESUME or ABORT options:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-21910 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg\" alt=\"riro2_02\" width=\"300\" height=\"70\" \/><\/a><\/p>\n<p>As you can see, the query does not work and you have this error message:<br \/>\n<em><span style=\"color: red\">Msg 10637, Level 16, State 1, Line 14<br \/>\nCannot perform this operation on &#8216;object&#8217; with ID 430624577 as one or more indexes are currently in resumable index rebuild state. Please refer to sys.index_resumable_operations for more details.<br \/>\n<\/span><\/em><\/p>\n<p>The standard rebuild will not change the status of the resumable rebuild and begin from scratch in order to do the rebuild from beginning.<br \/>\nFinally, the only way to rebuild the index is really to use the RESUME option and continue where it&#8217;s stopped.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is an additional article to my precedent about \u201cSQL Server 2017: What\u2019s happens with an interruption during a Resumable Online Index Rebuild?\u201d The goal is to see after I suspend the rebuild, if I can run a traditional rebuild without the option RESUME. &nbsp; I start an index rebuild with the option Resumable: [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":11039,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368,99,48],"tags":[49,67,51,1077],"type_dbi":[],"class_list":["post-11036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-development-performance","category-sql-server","category-technology-survey","tag-microsoft","tag-performance","tag-sql-server","tag-sql-server-2017"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2017: Can I run a &quot;standard&quot; rebuild on the index after a Resumable Online Index Rebuild is suspended? - 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-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2017: Can I run a &quot;standard&quot; rebuild on the index after a Resumable Online Index Rebuild is suspended?\" \/>\n<meta property=\"og:description\" content=\"This article is an additional article to my precedent about \u201cSQL Server 2017: What\u2019s happens with an interruption during a Resumable Online Index Rebuild?\u201d The goal is to see after I suspend the rebuild, if I can run a traditional rebuild without the option RESUME. &nbsp; I start an index rebuild with the option Resumable: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-20T11:18:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1009\" \/>\n\t<meta property=\"og:image:height\" content=\"236\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"1 minute\" \/>\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-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2017: Can I run a &#8220;standard&#8221; rebuild on the index after a Resumable Online Index Rebuild is suspended?\",\"datePublished\":\"2018-03-20T11:18:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/\"},\"wordCount\":217,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/riro2_02.jpg\",\"keywords\":[\"Microsoft\",\"Performance\",\"SQL Server\",\"SQL Server 2017\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Development &amp; Performance\",\"SQL Server\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/\",\"name\":\"SQL Server 2017: Can I run a \\\"standard\\\" rebuild on the index after a Resumable Online Index Rebuild is suspended? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/riro2_02.jpg\",\"datePublished\":\"2018-03-20T11:18:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/riro2_02.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/riro2_02.jpg\",\"width\":1009,\"height\":236},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2017: Can I run a &#8220;standard&#8221; rebuild on the index after a Resumable Online Index Rebuild is suspended?\"}]},{\"@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 2017: Can I run a \"standard\" rebuild on the index after a Resumable Online Index Rebuild is suspended? - 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-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2017: Can I run a \"standard\" rebuild on the index after a Resumable Online Index Rebuild is suspended?","og_description":"This article is an additional article to my precedent about \u201cSQL Server 2017: What\u2019s happens with an interruption during a Resumable Online Index Rebuild?\u201d The goal is to see after I suspend the rebuild, if I can run a traditional rebuild without the option RESUME. &nbsp; I start an index rebuild with the option Resumable: [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/","og_site_name":"dbi Blog","article_published_time":"2018-03-20T11:18:19+00:00","og_image":[{"width":1009,"height":236,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2017: Can I run a &#8220;standard&#8221; rebuild on the index after a Resumable Online Index Rebuild is suspended?","datePublished":"2018-03-20T11:18:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/"},"wordCount":217,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg","keywords":["Microsoft","Performance","SQL Server","SQL Server 2017"],"articleSection":["Database Administration &amp; Monitoring","Development &amp; Performance","SQL Server","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/","name":"SQL Server 2017: Can I run a \"standard\" rebuild on the index after a Resumable Online Index Rebuild is suspended? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg","datePublished":"2018-03-20T11:18:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/riro2_02.jpg","width":1009,"height":236},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-can-i-run-a-standard-rebuild-on-the-index-after-a-resumable-online-index-rebuild-is-suspended\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2017: Can I run a &#8220;standard&#8221; rebuild on the index after a Resumable Online Index Rebuild is suspended?"}]},{"@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\/11036","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=11036"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11036\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11039"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11036"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}