{"id":16004,"date":"2021-03-19T09:36:23","date_gmt":"2021-03-19T08:36:23","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/"},"modified":"2021-03-19T09:36:23","modified_gmt":"2021-03-19T08:36:23","slug":"copy-or-migrate-a-ssisdb-environment-2-0","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/","title":{"rendered":"Copy or Migrate a SSISDB environment 2.0"},"content":{"rendered":"<p>Based on the blog &#8220;<a href=\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment\/\" target=\"_blank\" rel=\"noopener\">Copy or Migrate a SSISDB environment<\/a>&#8221; of my colleague Christophe, I create a new one named 2.0.<\/p>\n<p>In the precedent script, you need to give the folder name and environment name and he generates all environment variables for these 2 parameters.<br \/>\nIn my case, I need to generate all folders and what are in these folders.<\/p>\n<p>The 2.0 script will generate the creation of the folder and the environment name if they not exist in add of all environment variables.<br \/>\nIt is a little bit more global! \ud83d\ude1b<\/p>\n<p>To create a Folder, I need to generate this type of script:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DECLARE @FolderName nvarchar(128) = NULL; \nSET @FolderName = 'MyFolfer';\nIF ((SELECT count(*) from [SSISDB].[catalog].folders where name=@FolderName)=0) \nBEGIN\n       EXEC [SSISDB].[catalog].[create_folder] @folder_name=@FolderName; \nEND;\n<\/pre>\n<p>To create the environment name, I need to generate this type of script:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"> \nDECLARE @EnvName nvarchar(128)= NULL;\nSET @EnvName = 'DEV_ENV';\nIF ((SELECT count(*) from [SSISDB].[catalog].environments where name=@EnvName)=0)\nBEGIN\n\tEXEC [SSISDB].[catalog].[create_environment] @folder_name=@FolderName, @environment_name=@EnvName, @environment_description=N'';\n\nEND;\n<\/pre>\n<p>After, we generate like Christophe does,\u00a0 environment variables:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">EXEC [SSISDB].[catalog].[create_environment_variable] @folder_name=@FolderName, @environment_name=@EnvName, @variable_name=N'myVariable',@data_type=N'String',@sensitive=0, @value = N'\\\\myshare\\',@description=N'';\n<\/pre>\n<p>To create all scripts, I will just insert in the migration script both above scripts in my SELECT:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"> \nSELECT 'DECLARE @FolderName nvarchar(128) = NULL; DECLARE @EnvName nvarchar(128)= NULL;'\nSELECT \n'SET @EnvName = ''' + e.name + ''';' + \n'SET @FolderName = ''' + f.name + ''';'+\n'IF ((SELECT count(*) from [SSISDB].[catalog].folders where name=@FolderName)=0) \nBEGIN\n       EXEC [SSISDB].[catalog].[create_folder] @folder_name=@FolderName; \nEND;'\n+\n'IF ((SELECT count(*) from [SSISDB].[catalog].environments where name=@EnvName)=0)\nBEGIN\nEXEC [SSISDB].[catalog].[create_environment] @folder_name=@FolderName, @environment_name=@EnvName, @environment_description=N''' + COALESCE(e.description, '') + '''' +'; END;'\n+' EXEC [SSISDB].[catalog].[create_environment_variable] \n@folder_name=@FolderName, \n@environment_name=@EnvName, \n@variable_name=N'''+ ev.name + ''', \n@data_type=N'''+ ev.type + ''', \n@sensitive='+ CONVERT(NCHAR,ev.sensitive) +', \n@value = ' + \nCASE ev.sensitive\nWHEN 0 THEN \nCASE ev.type \nWHEN 'Date Time' THEN ''''+ CONVERT(NVARCHAR(max),ev.value) + ''''\nWHEN 'String' THEN 'N'''+ CONVERT(NVARCHAR(max),ev.value) + ''''\nELSE CONVERT(NVARCHAR(max),ev.value)\nEND \nWHEN 1 THEN \n'##########'\nEND + ',\n@description=N'''+ ev.description + ''';'\nas tsql_EnvVarcreate\nFROM SSISDB.catalog.folders f\nINNER JOIN SSISDB.catalog.environments e on e.folder_id = f.folder_id\nINNER JOIN SSISDB.catalog.environment_variables ev on ev.environment_id = e.environment_id\n<\/pre>\n<p>The first Select is just to declare the 2 variables @FolderName and @EnvName<br \/>\nThe second select will create all our environment variables with the folder and environment name.<br \/>\nHere below a screenshot of the result of the script, when I run the script<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-48650 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1-4.png\" alt=\"\" width=\"300\" height=\"165\" \/><\/a><\/p>\n<p>As you can see, for all environment variables, this script will have the &#8220;exist&#8221; test and creation of the folder and environment name.<br \/>\nCopy the result of the script (column tsql_EnvCopy) in a copy it in a SSMS Query window connected to the server where you want to deploy your environment<br \/>\nBe careful and verify before running the result script that you have the good name for all folders, environment name and variable name<br \/>\nLast step is just to run the script:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable2-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-48647 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable2-1.png\" alt=\"\" width=\"300\" height=\"177\" \/><\/a><\/p>\n<p>Et voila, I do my first SSIS Catalog environment migration successfully!<\/p>\n<p>Thank you<a href=\"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/\" target=\"_blank\" rel=\"noopener\"> Christophe<\/a> for showing the way with your first blog \ud83d\ude0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Based on the blog &#8220;Copy or Migrate a SSISDB environment&#8221; of my colleague Christophe, I create a new one named 2.0. In the precedent script, you need to give the folder name and environment name and he generates all environment variables for these 2 parameters. In my case, I need to generate all folders and [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":16007,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[49,51,592,655],"type_dbi":[],"class_list":["post-16004","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-sql-server","tag-microsoft","tag-sql-server","tag-ssis","tag-ssisdb"],"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>Copy or Migrate a SSISDB environment 2.0 - 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\/copy-or-migrate-a-ssisdb-environment-2-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Copy or Migrate a SSISDB environment 2.0\" \/>\n<meta property=\"og:description\" content=\"Based on the blog &#8220;Copy or Migrate a SSISDB environment&#8221; of my colleague Christophe, I create a new one named 2.0. In the precedent script, you need to give the folder name and environment name and he generates all environment variables for these 2 parameters. In my case, I need to generate all folders and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-19T08:36:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1342\" \/>\n\t<meta property=\"og:image:height\" content=\"737\" \/>\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\/copy-or-migrate-a-ssisdb-environment-2-0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"Copy or Migrate a SSISDB environment 2.0\",\"datePublished\":\"2021-03-19T08:36:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/\"},\"wordCount\":294,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SSIS\",\"SSISDB\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/\",\"name\":\"Copy or Migrate a SSISDB environment 2.0 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png\",\"datePublished\":\"2021-03-19T08:36:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png\",\"width\":1342,\"height\":737},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Copy or Migrate a SSISDB environment 2.0\"}]},{\"@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":"Copy or Migrate a SSISDB environment 2.0 - 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\/copy-or-migrate-a-ssisdb-environment-2-0\/","og_locale":"en_US","og_type":"article","og_title":"Copy or Migrate a SSISDB environment 2.0","og_description":"Based on the blog &#8220;Copy or Migrate a SSISDB environment&#8221; of my colleague Christophe, I create a new one named 2.0. In the precedent script, you need to give the folder name and environment name and he generates all environment variables for these 2 parameters. In my case, I need to generate all folders and [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/","og_site_name":"dbi Blog","article_published_time":"2021-03-19T08:36:23+00:00","og_image":[{"width":1342,"height":737,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.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\/copy-or-migrate-a-ssisdb-environment-2-0\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"Copy or Migrate a SSISDB environment 2.0","datePublished":"2021-03-19T08:36:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/"},"wordCount":294,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png","keywords":["Microsoft","SQL Server","SSIS","SSISDB"],"articleSection":["Database Administration &amp; Monitoring","Database management","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/","url":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/","name":"Copy or Migrate a SSISDB environment 2.0 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png","datePublished":"2021-03-19T08:36:23+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSIS_Set_Variable1.png","width":1342,"height":737},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/copy-or-migrate-a-ssisdb-environment-2-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Copy or Migrate a SSISDB environment 2.0"}]},{"@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\/16004","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=16004"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16004\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16007"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16004"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}