{"id":6163,"date":"2015-11-02T16:55:25","date_gmt":"2015-11-02T15:55:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"},"modified":"2015-11-02T16:55:25","modified_gmt":"2015-11-02T15:55:25","slug":"sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","title":{"rendered":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!"},"content":{"rendered":"

For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features.
\nAll info about CTP3 are on SQL Server Blog here<\/a>.<\/p>\n

I wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON<\/em><\/a><\/p>\n

With this new CTP version, JSON support has new enhancements and especially the OPENJSON function<\/strong>. When I wrote my blog, this option was not available.
\nThree other functions are available: JSON_VALUE<\/strong>, ISJSON<\/strong> and JSON_QUERY<\/strong>!
\nNow, it is time to test it! \u27a1<\/p>\n

OPENJSON<\/h3>\n

The TVF (Table-Value Function) OPENJSON<\/strong> is the easy way to import the JSON format directly in a table.
\nThe principle is simple as you can see on this picture.<\/p>\n

\"JSON200\"<\/a><\/p>\n

How it works? I want to do exactly what is in the picture below.<\/p>\n

\"JSON201\"<\/a>
\nAs you can see, I use double quotes (“) for all data type in the JSON format.
\nIn a second time, I delete all double quotes (“) from the Salary values.<\/p>\n

\"JSON202\"<\/a><\/p>\n

The result is the same as previously.
\nI will do the date for the HireDate values.<\/p>\n

\"JSON203\"<\/a><\/p>\n

As you can see in this latest test, it doesn’t work!
\nFinally, the best is to keep double quotes (“) in the JSON values.
\nIn JSON structure<\/a>, double quotes are just for string but in SQL Server you can use it for number without problems.<\/p>\n

For more information, msdn link here.<\/a><\/p>\n

JSON_VALUE<\/h3>\n

This function returns a single text with the value of your stored JSON text.
\nAs example, I create a database JSON_TEST with a table JSON_EmployeesList and a jsonContent in nvarchar(MAX) to store the json text in the variable @JsonEmployeesArray.<\/p>\n

\"JSON204\"<\/a><\/p>\n

I use JSON_VALUE function on the 4 objects in EmployeesArray<\/p>\n

\"JSON205\"<\/a><\/p>\n

As you can see, we have the first line of the jsonContent.
\nWhy? JSON_VALUE extracts only a scalar value<\/strong> and not an object or an array like JSON_QUERY<\/p>\n

For more information, msdn link here.<\/a><\/p>\n

ISJSON<\/h3>\n

It is a function used to test if your text is a JSON text and return 1 if it is true.<\/p>\n

\"JSON206\"<\/a><\/p>\n

In the query plan, you can see that the filter is applied with my ISJSON function<\/p>\n

\"JSON207\"<\/a><\/p>\n

For more information, msdn link here<\/a>.<\/p>\n

JSON_QUERY<\/h3>\n

This function is the twin of JSON_VALUE but like a twin, it is not really the same…
\nJSON_VALUE return a scalar value and JSON_QUERY returns an object or an array<\/strong> with the values of your stored JSON text.<\/p>\n

\"JSON208\"<\/a><\/p>\n

As you can see in my example, the JSON_QUERY function returns an array for EmployeesArray and EmployeesArray.Name.
\nFor EmployeesArray.Department, the function return NULL. Department in this example is not an array.<\/p>\n

For more information, msdn link here.<\/a><\/p>\n

To conclude, if you are very interested by these functionalities, you find on msdn a good comparison between these 3 functions here.<\/a>
\nSee you soon!<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON With this… <\/p>\n","protected":false},"author":15,"featured_media":6173,"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":[99],"tags":[694,49,566],"class_list":["post-6163","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-json","tag-microsoft","tag-sql-server-2016"],"yoast_head":"\nSQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!<\/title>\n<meta name=\"description\" content=\"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY\" \/>\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-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\" \/>\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=\"2015-11-02T15:55:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/JSON200-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1231\" \/>\n\t<meta property=\"og:image:height\" content=\"659\" \/>\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: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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\",\"datePublished\":\"2015-11-02T15:55:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/\"},\"wordCount\":483,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/JSON200-1.png\",\"keywords\":[\"json\",\"Microsoft\",\"SQL Server 2016\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/\",\"name\":\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/JSON200-1.png\",\"datePublished\":\"2015-11-02T15:55:25+00:00\",\"description\":\"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/JSON200-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/JSON200-1.png\",\"width\":1231,\"height\":659},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\"}]},{\"@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 2016: JSON support updated with SQL Server 2016 CTP 3.0!","description":"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY","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-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!","og_description":"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2015-11-02T15:55:25+00:00","og_image":[{"width":1231,"height":659,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/JSON200-1.png","type":"image\/png"}],"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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!","datePublished":"2015-11-02T15:55:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"},"wordCount":483,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/JSON200-1.png","keywords":["json","Microsoft","SQL Server 2016"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","name":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/JSON200-1.png","datePublished":"2015-11-02T15:55:25+00:00","description":"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/JSON200-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/JSON200-1.png","width":1231,"height":659},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!"}]},{"@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\/6163","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=6163"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6163\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6173"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}