{"id":2490,"date":"2012-02-10T11:20:00","date_gmt":"2012-02-10T10:20:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/"},"modified":"2012-02-10T11:20:00","modified_gmt":"2012-02-10T10:20:00","slug":"sql-server-2012-new-features-for-integration-services-ssis","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/","title":{"rendered":"SQL Server 2012: new features for Integration Services (SSIS)"},"content":{"rendered":"<p>Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new &#8220;goodies&#8221; (from CTP1 to RC0), which can be powerful for DBAs and developers.<\/p>\n<h3>Since CTP1<\/h3>\n<ul>\n<li><strong>Deployment and Administration Enhancements<\/strong><\/li>\n<\/ul>\n<p>You have a new deployment model and ways to administer your data integration workloads in the company. The project deployment model provides the ability to define parameters for packages and projects and to modify the parameter values at runtime. More information\u00a0<a href=\"http:\/\/social.technet.microsoft.com\/wiki\/contents\/articles\/project-deployment-overview-in-sql-server-quot-denali-quot-ctp1-ssis.aspx\">here<\/a>.<\/p>\n<ul>\n<li><strong>Object Impact and Data Lineage Analysis<\/strong><\/li>\n<\/ul>\n<p>You can now view information about impact and data lineage between supported Integration Services objects that are deployed to the server and supported SQL Server SQL Server objects. More information <a href=\"http:\/\/social.technet.microsoft.com\/wiki\/contents\/articles\/project-deployment-overview-in-sql-server-quot-denali-quot-ctp1-ssis.aspx\">here<\/a>.<\/p>\n<ul>\n<li><strong>Usability Enhancements<\/strong><\/li>\n<\/ul>\n<p>SQL Server Data Tools (SSDT) has been updated to help new and experienced users develop packages more easily. A new Integration Services toolbox, designer refinements, and other usability enhancements help new users become productive quickly.<\/p>\n<ul>\n<li><strong>Reduced Memory Usage by the Merge and Merge Join Transformations<\/strong><\/li>\n<\/ul>\n<p>Microsoft has made the Integration Services Merge and Merge Join transformations more robust and reliable. This is achieved by reducing the risk that these components will consume excessive memory when the multiple inputs produce data at uneven rates. More information\u00a0<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ff877983(SQL.110).aspx\">here<\/a>.<\/p>\n<h3>Since CTP2<\/h3>\n<ul>\n<li><strong>New Reports for Troubleshooting Package Operations<\/strong><\/li>\n<\/ul>\n<p>In this release, two standard reports are available in SQL Server Management Studio to help you troubleshoot Integration Services packages that have been deployed to the Integration Services catalog. More information <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/gg471512(SQL.110).aspx\">here<\/a>.<\/p>\n<ul>\n<li><strong>Viewing Dependencies for Objects<\/strong><\/li>\n<\/ul>\n<p>You can now easily view dependencies for SQL Server objects and packages stored on different servers, using the Object Dependencies dialog box in SQL Server Management Studio.<\/p>\n<ul>\n<li><strong>Comparing and Merging Packages<\/strong><\/li>\n<\/ul>\n<p>The structure of .dtsx\u00a0package files has been modified to make it easier for you to compare packages. You can also more reliably merge packages that don\u2019t contain conflicting changes or changes stored in binary format.<\/p>\n<ul>\n<li><strong>Easier Access to Samples and Tutorials<\/strong><\/li>\n<\/ul>\n<p>The Getting Started window in the SSIS Designer provides links to samples, tutorials and videos. You can customize the window by adding links to additional content. For more information, see Integration Services User Interface. More information <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ms141730(SQL.110).aspx\">here<\/a>.<\/p>\n<p>The SSIS Toolbox in SQL Server Data Tools (SSDT) provides links to samples and Help content for Control Flow and Data Flow items. You can add links for custom components. More information <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ms403361(SQL.110).aspx\">here<\/a>.<\/p>\n<h3>Since CTP3<\/h3>\n<p>This build provides additional elements like views, stored procedures and functions to help you troubleshoot performance and data issues.<\/p>\n<table border=\"0\">\n<tbody>\n<tr>\n<td style=\"background-color: #0000cc\"><strong><span style=\"color: #ffffff\">Troubleshooting Capability<\/span><\/strong><\/td>\n<td style=\"background-color: #0000cc\"><strong><span style=\"color: #ffffff\">Views, Procedures, and Functions<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000\">Get performance statistics and other information for an execution<\/td>\n<td style=\"border: 1px solid #000000\"><a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ff878089(SQL.110).aspx\">catalog.executions (SSISDB Database)<\/a><br \/>\n<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh230981(SQL.110).aspx\">catalog.execution_component_phases<\/a><br \/>\n<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh230983(SQL.110).aspx\">dm_execution_performance_counters (SSISDB Database<\/a>)<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000\">Add, remove, and query data taps in a package data flow<\/td>\n<td style=\"border: 1px solid #000000\"><a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh230989(SQL.110).aspx\">catalog.add_data_tap<\/a><br \/>\n<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh230990(SQL.110).aspx\">catalog.remove_data_tap<\/a><br \/>\n<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh230985(SQL.110).aspx\">catalog.execution_data_taps<\/a><br \/>\n<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh230986(SQL.110).aspx\">catalog.execution_data_statistics<\/a><\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000\">Create a dump for a running package<\/td>\n<td style=\"border: 1px solid #000000\"><a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh230986(SQL.110).aspx\">catalog.create_execution_dump<\/a><\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #000000\">Set a parameter value in an instance of an execution<\/td>\n<td style=\"border: 1px solid #000000\"><a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ff877990(SQL.110).aspx\">catalog.set_execution_parameter_value (SSISDB Database)<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Since RC0<\/h3>\n<ul>\n<li><strong>Shared Connection Managers<\/strong><\/li>\n<\/ul>\n<p>This release allows you to create connection managers at the project level that can be shared by multiple packages in the project. The connection manager you create at the project level is automatically visible in the Connection Managers tab of the SSIS Designer window for all packages.<\/p>\n<ul>\n<li><strong>Parameters<\/strong><\/li>\n<\/ul>\n<p>Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package level. Project parameters are used to supply any external input the project receives to one or more packages in the project. Package parameters allow you to modify package execution without having to edit and redeploy the package. More information <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh213214(SQL.110).aspx\">here<\/a>.<\/p>\n<ul>\n<li><strong>Undo\/Redo in SSIS Designer<\/strong><\/li>\n<\/ul>\n<p>You can undo and redo up to 20 actions in the SSIS Designer. For a package, undo\/redo is available in the Control Flow, Data Flow, Event Handlers, and Parameters tabs, and in the Variables window. More information <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ms137973(SQL.110).aspx\">here<\/a>.<\/p>\n<h3>Conclusion<\/h3>\n<p>You can find all information about the new Integration Services <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ms141026(SQL.110).aspx\">here<\/a> on the Microsoft TechNet. At the moment, I have not tested all new features but I will and you will see it soon.<br \/>\nMy SQL Server 2012 series is to be continued&#8230;:-D<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Like the others products of SQL server 2012, Integration Services has a lot of new features and enhancements.<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[294],"tags":[263,49,54],"class_list":["post-2490","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","tag-integration-services","tag-microsoft","tag-sql-server-2012"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2012: new features for Integration Services (SSIS) - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new &quot;goodies&quot; (from CTP1 to RC0), which can be powerful for DBAs and developers.\" \/>\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-new-features-for-integration-services-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012: new features for Integration Services (SSIS)\" \/>\n<meta property=\"og:description\" content=\"Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new &quot;goodies&quot; (from CTP1 to RC0), which can be powerful for DBAs and developers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-10T10:20:00+00:00\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-new-features-for-integration-services-ssis\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server 2012: new features for Integration Services (SSIS)\",\"datePublished\":\"2012-02-10T10:20:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/\"},\"wordCount\":724,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"keywords\":[\"Integration services\",\"Microsoft\",\"SQL Server 2012\"],\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/\",\"name\":\"SQL Server 2012: new features for Integration Services (SSIS) - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2012-02-10T10:20:00+00:00\",\"description\":\"Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new \\\"goodies\\\" (from CTP1 to RC0), which can be powerful for DBAs and developers.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-new-features-for-integration-services-ssis\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012: new features for Integration Services (SSIS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012: new features for Integration Services (SSIS) - dbi services | Blog","description":"Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new \"goodies\" (from CTP1 to RC0), which can be powerful for DBAs and developers.","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-new-features-for-integration-services-ssis\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012: new features for Integration Services (SSIS)","og_description":"Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new \"goodies\" (from CTP1 to RC0), which can be powerful for DBAs and developers.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2012-02-10T10:20:00+00:00","author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server 2012: new features for Integration Services (SSIS)","datePublished":"2012-02-10T10:20:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/"},"wordCount":724,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"keywords":["Integration services","Microsoft","SQL Server 2012"],"articleSection":["Business Intelligence"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/","name":"SQL Server 2012: new features for Integration Services (SSIS) - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2012-02-10T10:20:00+00:00","description":"Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new \"goodies\" (from CTP1 to RC0), which can be powerful for DBAs and developers.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-new-features-for-integration-services-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012: new features for Integration Services (SSIS)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2490","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=2490"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2490\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}