{"id":15661,"date":"2021-02-15T15:25:37","date_gmt":"2021-02-15T14:25:37","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/"},"modified":"2021-02-15T15:25:37","modified_gmt":"2021-02-15T14:25:37","slug":"first-steps-on-kusto-query-language-kql","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/","title":{"rendered":"First steps on Kusto Query Language (KQL)"},"content":{"rendered":"<p>Do you know this query language?\u00a0 No, it&#8217;s time to explain you and see what it is.<\/p>\n<p>&nbsp;<\/p>\n<p>\u201cA Kusto query is a read-only request to process data and return results.\u201d dixit Microsoft Documentation <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-explorer\/kusto\/query\/\" target=\"_blank\" rel=\"noopener\">here<\/a><\/p>\n<p>The KQL is very simple to understand and use. I can do it then you can also do it! \ud83d\ude1b<\/p>\n<p>The first thing to know is how to call the information on a table.<\/p>\n<p>In this case you\u00a0 need to call the table directly with the name of the table, in the place to do a SELECT * FROM Table.<\/p>\n<p>Microsoft give us the opportunity to test it directly on Azure Data Explorer <a href=\"https:\/\/dataexplorer.azure.com\/clusters\/help\/databases\/Samples\" target=\"_blank\" rel=\"noopener\">here<\/a><\/p>\n<p>In my example, I will use the table Covid19 and I just write the name of the table to have all information:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-47451 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL01.png\" alt=\"\" width=\"300\" height=\"159\" \/><\/a><\/p>\n<p>Using the pipe (|) delimiter, I add filters, transformations etc&#8230;<\/p>\n<p>My first test is to add a clause WHERE in the query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Covid19\n\n|\u00a0where\u00a0CountryCode\u00a0==\u00a0'CH'<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-47435 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL02.png\" alt=\"\" width=\"300\" height=\"113\" \/><\/a><br \/>\nI have all rows for Switzerland now.<\/p>\n<p>When you begin, i advise you to take a look on the query best practices page and have directly the good practice <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-explorer\/kusto\/query\/best-practices\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>To filter on some columns, you need to add \u201cProject\u201d in the query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Covid19\n| where CountryCode == 'CH'\n| project Timestamp, Country, Confirmed, Deaths<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-47434 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL03.png\" alt=\"\" width=\"300\" height=\"191\" \/><\/a><\/p>\n<p>The next step is to order the result and it\u2019s easy with an \u201corder by\u201d<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Covid19\n| where CountryCode == 'CH'\n| project Timestamp, Country, Confirmed, Deaths\n| order by Deaths desc<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-47433 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL04.png\" alt=\"\" width=\"300\" height=\"106\" \/><\/a><\/p>\n<p>Very easy, it\u2019s it!<\/p>\n<p>The last step for this first approach is to present the result in a graph.<\/p>\n<p>For this step, you will use the command render and with the intellisense, you have a lot of possibility<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-47432 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL05.png\" alt=\"\" width=\"300\" height=\"96\" \/><\/a><\/p>\n<p>I choose the TimeChart to have the progression during the period:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Covid19\n| where CountryCode == 'CH'\n| project Timestamp, Country, Confirmed, Deaths\n| order by Deaths desc \n| render timechart<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-47431 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png\" alt=\"\" width=\"300\" height=\"153\" \/><\/a><\/p>\n<p>Et voila, I do my first step in KQL!<\/p>\n<p>Easy to understand, easy to learn, easy to use, easy to have a quick overview of your data&#8230;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you know this query language?\u00a0 No, it&#8217;s time to explain you and see what it is. &nbsp; \u201cA Kusto query is a read-only request to process data and return results.\u201d dixit Microsoft Documentation here The KQL is very simple to understand and use. I can do it then you can also do it! \ud83d\ude1b [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":15667,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,368,99],"tags":[49,51],"type_dbi":[],"class_list":["post-15661","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-development-performance","category-sql-server","tag-microsoft","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>First steps on Kusto Query Language (KQL) - 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\/first-steps-on-kusto-query-language-kql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"First steps on Kusto Query Language (KQL)\" \/>\n<meta property=\"og:description\" content=\"Do you know this query language?\u00a0 No, it&#8217;s time to explain you and see what it is. &nbsp; \u201cA Kusto query is a read-only request to process data and return results.\u201d dixit Microsoft Documentation here The KQL is very simple to understand and use. I can do it then you can also do it! \ud83d\ude1b [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-15T14:25:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1909\" \/>\n\t<meta property=\"og:image:height\" content=\"972\" \/>\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=\"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\\\/first-steps-on-kusto-query-language-kql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"First steps on Kusto Query Language (KQL)\",\"datePublished\":\"2021-02-15T14:25:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/\"},\"wordCount\":296,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/KQL06.png\",\"keywords\":[\"Microsoft\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Development &amp; Performance\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/\",\"name\":\"First steps on Kusto Query Language (KQL) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/KQL06.png\",\"datePublished\":\"2021-02-15T14:25:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/KQL06.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/KQL06.png\",\"width\":1909,\"height\":972},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/first-steps-on-kusto-query-language-kql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"First steps on Kusto Query Language (KQL)\"}]},{\"@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":"First steps on Kusto Query Language (KQL) - 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\/first-steps-on-kusto-query-language-kql\/","og_locale":"en_US","og_type":"article","og_title":"First steps on Kusto Query Language (KQL)","og_description":"Do you know this query language?\u00a0 No, it&#8217;s time to explain you and see what it is. &nbsp; \u201cA Kusto query is a read-only request to process data and return results.\u201d dixit Microsoft Documentation here The KQL is very simple to understand and use. I can do it then you can also do it! \ud83d\ude1b [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/","og_site_name":"dbi Blog","article_published_time":"2021-02-15T14:25:37+00:00","og_image":[{"width":1909,"height":972,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png","type":"image\/png"}],"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\/first-steps-on-kusto-query-language-kql\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"First steps on Kusto Query Language (KQL)","datePublished":"2021-02-15T14:25:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/"},"wordCount":296,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png","keywords":["Microsoft","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","Development &amp; Performance","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/","url":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/","name":"First steps on Kusto Query Language (KQL) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png","datePublished":"2021-02-15T14:25:37+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/KQL06.png","width":1909,"height":972},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/first-steps-on-kusto-query-language-kql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"First steps on Kusto Query Language (KQL)"}]},{"@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\/15661","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=15661"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15661\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/15667"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=15661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=15661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=15661"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=15661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}