{"id":4949,"date":"2015-06-12T12:24:45","date_gmt":"2015-06-12T10:24:45","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/"},"modified":"2015-06-12T12:24:45","modified_gmt":"2015-06-12T10:24:45","slug":"sql-server-2016-native-support-for-json","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/","title":{"rendered":"SQL Server 2016: native support for JSON"},"content":{"rendered":"<div><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\" alt=\"\" \/><\/div>\n<p>A lot of discussions and most important, a feature requests in the Microsoft connect site <a href=\"https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/673824\/add-native-support-for-json-to-sql-server-a-la-xml-as-in-for-json-or-from-openjson\">here<\/a>\u00a0with more than 1000 votes is the origin of this new feature in SQL Server 2016.<\/p>\n<p>A lot of NoSQL have already this function and PostgreSQL for example have the json_extract_path_text functionality and you can at every time ask my colleague <a href=\"http:\/\/dbi-services.com\/blog\/author\/daniel-westermann\/\">Daniel Westermann<\/a> one of our expert in PostgreSQL of this subject.<\/p>\n<p>First, Json is represented by a NVARCHAR for several reasons like Migration (Json format is already stored as string in databases) or Cross feature compatibility (nvarchar is present in all sql server components).<\/p>\n<p>&nbsp;<\/p>\n<h3>FOR JSON Clause<\/h3>\n<p>Like the FOR XML clause, you have the FOR JSON clause and you can use it very easily in a SELECT query like this:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"JSON01.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON01.png\"><img decoding=\"async\" title=\"JSON01.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON01.png\" alt=\"JSON01.png\" \/><\/a><\/p>\n<p><strong>PATH<\/strong> option is used to define JSON paths for each generated property.<\/p>\n<p>I put a \u201cProduct\u201d object for the name and the color and I have a new query like this:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"JSON02.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON02.png\"><img decoding=\"async\" title=\"JSON02.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON02.png\" alt=\"JSON02.png\" \/><\/a><\/p>\n<p>You notice that I use 2 types of writing for the Product object:<\/p>\n<ul>\n<li>[Product.Name]<\/li>\n<li>\u2018Product.Color\u2019<\/li>\n<\/ul>\n<p>Like FOR XML, the <strong>AUTO<\/strong> option exists and generates automatically simple hierarchies:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"JSON03.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON03.png\"><img decoding=\"async\" title=\"JSON03.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON03.png\" alt=\"JSON03.png\" \/><\/a><\/p>\n<p>And if I put the \u201cProduct\u201d object like before, you can see that you haven\u2019t the Product hierarchy:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"JSON04.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON04.png\"><img decoding=\"async\" title=\"JSON04.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON04.png\" alt=\"JSON04.png\" \/><\/a><\/p>\n<p>The result is based on the order and names of columns from the table.<\/p>\n<p>Another option is <strong>ROOT<\/strong> like already FOR XML to specified a top-level object like for my example Product:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"JSON05.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON05.png\"><img decoding=\"async\" title=\"JSON05.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON05.png\" alt=\"JSON05.png\" \/><\/a><\/p>\n<p>The last and very cool option is <strong>INCLUDE_NULL_VALUES<\/strong>.<\/p>\n<p>By default, the JSON clause does not include JSON properties for NULL values in the results but you can use this option to have it:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"JSON06.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON06.png\"><img decoding=\"async\" title=\"JSON06.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON06.png\" alt=\"JSON06.png\" \/><\/a><\/p>\n<p>More information about FOR JSON clause on the msdn link <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn921882(v=sql.130).aspx\">here.<\/a><\/p>\n<h3>OPENJSON option<\/h3>\n<p>OPENJSON option is table-value function (TVF) that accepts a string with a JSON format who can be parsed to put in a table all values like this form:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">DECLARE @product NVARCHAR(2000);\nSET @product= N'{\"Product\": [{\"EnglishProductName\":\"Adjustable Race\",\"Color\":\"NA\",\"Status\":\"Current\"},{\"EnglishProductName\":\"Bearing Ball\",\"Color\":\"NA\",\"Status\":\"Current\"},{\"EnglishProductName\":\"BB Ball Bearing\",\"Color\":\"NA\",\"Status\":\"Current\"}]}';\n\u00a0SELECT EnglishProductName, Color, Status FROM OPENJSON(@product, '$.Product')\n\u00a0WITH (\n\u00a0\u00a0\u00a0 EnglishProductName varchar(50),\n\u00a0\u00a0\u00a0 Color varchar(15),\n\u00a0\u00a0\u00a0 Status varchar(7)\n\u00a0) AS Product;<\/pre>\n<p>&nbsp;<\/p>\n<p>But this option is not valid in the CPT2 and will be in the next release like other news functions <strong>ISJSON<\/strong> and<strong>\u00a0JSON_VALUE<\/strong>.<\/p>\n<p>I write another blog of this subject when these functions come out\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A lot of discussions and most important, a feature requests in the Microsoft connect site here\u00a0with more than 1000 votes is the origin of this new feature in SQL Server 2016. A lot of NoSQL have already this function and PostgreSQL for example have the json_extract_path_text functionality and you can at every time ask my [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":4856,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[49,501,51,566,521],"type_dbi":[],"class_list":["post-4949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey","tag-microsoft","tag-new-version","tag-sql-server","tag-sql-server-2016","tag-t-sql"],"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>SQL Server 2016: native support for JSON - dbi Blog<\/title>\n<meta name=\"description\" content=\"In SQL Server 2016, JSON is natively supported\" \/>\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-native-support-for-json\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: native support for JSON\" \/>\n<meta property=\"og:description\" content=\"In SQL Server 2016, JSON is natively supported\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-12T10:24:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"520\" \/>\n\t<meta property=\"og:image:height\" content=\"245\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"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-native-support-for-json\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: native support for JSON\",\"datePublished\":\"2015-06-12T10:24:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/\"},\"wordCount\":359,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"keywords\":[\"Microsoft\",\"New Version\",\"SQL Server\",\"SQL Server 2016\",\"T-SQL\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/\",\"name\":\"SQL Server 2016: native support for JSON - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"datePublished\":\"2015-06-12T10:24:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"In SQL Server 2016, JSON is natively supported\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg\",\"width\":520,\"height\":245},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: native support for JSON\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016: native support for JSON - dbi Blog","description":"In SQL Server 2016, JSON is natively supported","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-native-support-for-json\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: native support for JSON","og_description":"In SQL Server 2016, JSON is natively supported","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/","og_site_name":"dbi Blog","article_published_time":"2015-06-12T10:24:45+00:00","og_image":[{"width":520,"height":245,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","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-native-support-for-json\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: native support for JSON","datePublished":"2015-06-12T10:24:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/"},"wordCount":359,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","keywords":["Microsoft","New Version","SQL Server","SQL Server 2016","T-SQL"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/","name":"SQL Server 2016: native support for JSON - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","datePublished":"2015-06-12T10:24:45+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"In SQL Server 2016, JSON is natively supported","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sql2016.jpg","width":520,"height":245},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-native-support-for-json\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: native support for JSON"}]},{"@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\/4949","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=4949"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4856"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4949"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}