{"id":2285,"date":"2011-09-02T13:04:00","date_gmt":"2011-09-02T11:04:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/"},"modified":"2011-09-02T13:04:00","modified_gmt":"2011-09-02T11:04:00","slug":"changing-the-reference-instance-for-sql-server-integration-service-ssis","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/","title":{"rendered":"Changing the reference instance for SQL Server Integration Service (SSIS)"},"content":{"rendered":"<p>Many people do not know how to manage multiple database instances and Integration Services, while facing the end of life for Integration Services reference instance. Let&#8217;s take a small example with Integration Service installed using instance &#8220;TOTO&#8221;, which comes end of line. We will have a look to SSIS information transfer to a second instance &#8220;TITI&#8221;. This article proposes a small working method to transfer these information correctly. We start with the folders transfer and then get an eye on SSIS packages transfer.<\/p>\n<h3>Environment for the Lab<\/h3>\n<p>SQL 2008 R2 on Windows 2008 installed with two instances:<\/p>\n<ul>\n<li>TOTO: SQL Server Engine \/ SQL Server Agent \/ Integration Services (SSIS)<\/li>\n<li>TITI: SQL Server Engine \/ SQL Server Agent<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png\" alt=\"1InstalledServices\" width=\"357\" height=\"137\" \/><\/p>\n<p>Note that Integration Services is not attached to an instance like the others services in the &#8220;SQL Server Configuration Manager&#8221; tool.<br \/>\nIn Integration Service, we create two folders: TITIDB and TOTODB in &#8220;Stored Packages&#8221; &#8211; &#8220;MSDB&#8221; folder<br \/>\nHave a look down there:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1Explorer.png\" alt=\"1Explorer\" width=\"315\" height=\"345\" \/><\/p>\n<h3>Looking for the SSIS folder information<\/h3>\n<p>Folders are stored in the MSDB system database of the Instance with which Integration Services is installed. The table is &#8220;sysssispackagefolders&#8221; in the system tables.<\/p>\n<p>Just do for each instance a <code>SELECT * FROM [msdb]. [Dbo]. [Sysssispackagefolders]<\/code><\/p>\n<p><strong>Instance TOTO<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2ExplorertotoV2.png\" alt=\"2ExplorertotoV2\" width=\"555\" height=\"258\" \/><\/p>\n<p><strong>Instance TITI<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2explorertitiV2.png\" alt=\"\" width=\"558\" height=\"259\" \/><\/p>\n<p>Note that the instance TOTO has the two folders information and TITI has no information.<\/p>\n<h3>Methodology to transfer folders information<\/h3>\n<ol>\n<li>As start point, stop Integration Services with &#8220;SQL Server Configuration Manager&#8221; tool<img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3StopSSISServices.png\" alt=\"3StopSSISServices\" width=\"542\" height=\"145\" \/><\/li>\n<li>Then, copy the 2 lines from the Sysssispackagefolders table from the instance TOTO and paste them with a right-click in the Sysssispackagefolders table of the instance TITI.<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3pastefolder.png\" alt=\"3pastefolder\" width=\"554\" height=\"185\" \/><\/li>\n<li>Now, change the default instance of the XML configuration file for SSIS. To do so edit the file\u00a0 &#8220;MsDtsSrvr.ini.xml&#8221; in the folder &#8220;C:Program FilesMicrosoft SQL Server100DTSBinn&#8221;. Simply replace the tag\u00a0.TOTO by .TITI and save the file.<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3SSISFileToChange.png\" alt=\"\" width=\"639\" height=\"288\" \/><\/li>\n<li>Stop Instance TOTO with &#8220;SQL Server Configuration Manager&#8221; tool<img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3sqlserverstop.png\" alt=\"\" \/><\/li>\n<li>Start Integration Services with &#8220;SQL Server Configuration Manager&#8221; tool<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3start.png\" alt=\"\" width=\"562\" height=\"156\" \/><\/li>\n<li>Verify that it&#8217;s running. A good test is to create a folder or subfolder in Integration Services<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3CreateSubFolderEnd.png\" alt=\"\" width=\"596\" height=\"298\" \/><\/li>\n<\/ol>\n<p>If it doesn&#8217;t work, you may have an error message&#8230;<\/p>\n<p>With the method shown, you can easily change the default instance and their folders in Integration services (SSIS). Of course re-creation the whole folder structure still work but the step 3 will have to be made in any case.<\/p>\n<h3>Facing and Error?<\/h3>\n<p>If your are testing your Integration Services environment but the transfer didn-t properly complete, then you will face the following error:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/4ErrorMessage.png\" alt=\"\" width=\"499\" height=\"262\" \/><\/p>\n<p>This message is not really explicit. The best is to give one more try by following step by step the method shown above.<\/p>\n<h3>Package transfer<\/h3>\n<p>The last step is to transfer all SSIS packages, using import, to the new reference instance. Start by running the follwing SQL statement SELECT *\u00a0 FROM [msdb].[dbo].[sysssispackages] on the instance TOTO in order to check all SSIS Packages registered. Then import all of them one by one through each folder and sub-folder.<\/p>\n<p><img decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/5importPackage.png\" alt=\"\" \/><\/p>\n<p>So I hope that this article will help for future Integration Services migration and if you need any information feel free to <a href=\"index.php\/about-us\/contact-us?view=message&amp;layout=message&amp;pf=1\">contact us<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services.<\/p>\n<p> When Integration Service is installed with the instance &#8220;TOTO&#8221; and that it is at the end of his life, we&#8217;ll see how to transfer information to the second instance &#8220;TITI&#8221;. We present you a small working method to transfer information correctly. <\/p>\n<p>Only the folders transfert is presented in this article and the&nbsp; transfert of the SSIS packages are explained at the end.<\/p>\n","protected":false},"author":15,"featured_media":2286,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[280,263,265],"type_dbi":[],"class_list":["post-2285","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-database","tag-integration-services","tag-sql-server-2008"],"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>Changing the reference instance for SQL Server Integration Service (SSIS) - dbi Blog<\/title>\n<meta name=\"description\" content=\"This is a presentation to change the reference instance for SQL Server Integration Service (SSIS) and transfert the associated folders\" \/>\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\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Changing the reference instance for SQL Server Integration Service (SSIS)\" \/>\n<meta property=\"og:description\" content=\"This is a presentation to change the reference instance for SQL Server Integration Service (SSIS) and transfert the associated folders\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-02T11:04:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png\" \/>\n\t<meta property=\"og:image:width\" content=\"357\" \/>\n\t<meta property=\"og:image:height\" content=\"137\" \/>\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\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"Changing the reference instance for SQL Server Integration Service (SSIS)\",\"datePublished\":\"2011-09-02T11:04:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/\"},\"wordCount\":516,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png\",\"keywords\":[\"database\",\"Integration services\",\"SQL Server 2008\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/\",\"name\":\"Changing the reference instance for SQL Server Integration Service (SSIS) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png\",\"datePublished\":\"2011-09-02T11:04:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"This is a presentation to change the reference instance for SQL Server Integration Service (SSIS) and transfert the associated folders\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png\",\"width\":357,\"height\":137},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Changing the reference instance for SQL Server Integration Service (SSIS)\"}]},{\"@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":"Changing the reference instance for SQL Server Integration Service (SSIS) - dbi Blog","description":"This is a presentation to change the reference instance for SQL Server Integration Service (SSIS) and transfert the associated folders","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\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/","og_locale":"en_US","og_type":"article","og_title":"Changing the reference instance for SQL Server Integration Service (SSIS)","og_description":"This is a presentation to change the reference instance for SQL Server Integration Service (SSIS) and transfert the associated folders","og_url":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/","og_site_name":"dbi Blog","article_published_time":"2011-09-02T11:04:00+00:00","og_image":[{"width":357,"height":137,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.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\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"Changing the reference instance for SQL Server Integration Service (SSIS)","datePublished":"2011-09-02T11:04:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/"},"wordCount":516,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png","keywords":["database","Integration services","SQL Server 2008"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/","url":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/","name":"Changing the reference instance for SQL Server Integration Service (SSIS) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png","datePublished":"2011-09-02T11:04:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"This is a presentation to change the reference instance for SQL Server Integration Service (SSIS) and transfert the associated folders","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1InstalledServices.png","width":357,"height":137},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/changing-the-reference-instance-for-sql-server-integration-service-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Changing the reference instance for SQL Server Integration Service (SSIS)"}]},{"@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\/2285","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=2285"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2285\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2286"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2285"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}