{"id":16952,"date":"2021-12-08T08:14:57","date_gmt":"2021-12-08T07:14:57","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/"},"modified":"2021-12-08T08:14:57","modified_gmt":"2021-12-08T07:14:57","slug":"sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/","title":{"rendered":"SQL Server: how to have the number of core-based licenses used on my environment?"},"content":{"rendered":"<p>This week, a customer asks me to find out how many SQL Server Standard licenses are used in their environment. The licensing is core based and to not be used for Sserver + Cals licenses.<br \/>\nTo have an idea, I create a script following the Microsoft document about the licensing <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/editions-and-components-of-sql-server-version-15?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>This script is valid for the SQL Server 2016, SQL Server 2017 and SQL Server 2019.<\/p>\n<p>If you have another version of SQL Server, please consult the Microsoft documentation before using the script, adapt it and share it with me! \ud83d\ude09<\/p>\n<p>If your host servers are licensed with Enterprise Edition (in the past, it was Datacenter Edition), you don&#8217;t need this script. In my case, it was useful to find all Standard Edition used by my customer.<br \/>\nThe Microsoft requirement is very easy:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-52955 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing02.png\" alt=\"\" width=\"300\" height=\"218\" \/><\/a><br \/>\nIn the script, I search to have the SQL Server edition, the logical CPU count, the number of sockets and the number of cores per socket to do the calculation.<br \/>\nImportant: <strong>One license is for 2 cores<\/strong>.<br \/>\nI search the information for the SQL Server edition through <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/functions\/serverproperty-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">SERVERPROPERTY<\/a>(N&#8217;Edition&#8217;) and the others information with the system view <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-os-sys-info-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">[sys].[dm_os_sys_info]<\/a>.<\/p>\n<p>With these information&#8217;s, I will be able to calculate the number of licenses used by every server:<\/p>\n<ul>\n<li>The first case is easy with the Express and Developer Edition, no licenses at all.<\/li>\n<li>The second case is if you have less than 4 cores, it&#8217;s 2 licenses (1 license for 2 cores)<\/li>\n<li>The third case is if you have a standard edition and you are limited to 4 sockets and 24 cores<\/li>\n<li>The fourth case is if you have a web edition and you are limited to 4 socket and 16 cores<\/li>\n<\/ul>\n<p>The default is for Enterprise and no limitation on the web or standard edition.<\/p>\n<p>Here the magic query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT  @@SERVERNAME as [Server Name],SERVERPROPERTY(N'Edition') AS Edition,cpu_count AS [Logical CPU Count],  \n             cpu_count\/hyperthread_ratio AS [Sockets],  hyperthread_ratio AS [Cores Per Socket], \n    CASE\n       -- Developer Edition,Express Edition,Express Edition with Advanced Services = 0 licenses\n\t   WHEN ((UPPER(Cast(SERVERPROPERTY(N'Edition') as sysname)) like N'%EXPRESS%') OR (UPPER(Cast(SERVERPROPERTY(N'Edition') as sysname)) like '%DEVELOPER%'))\n\t\t\tTHEN 0 \n\t   -- less then 4 cores = 2 licenses for Standard and Enterprise Edition\n\t   WHEN ((cpu_count\/2)&lt;4) \n\t\t\tTHEN 2 \n       -- Limited to 4 sockets &amp; 24 cores for Standard Edition \n\t   WHEN ((cpu_count\/hyperthread_ratio)&gt; 4) AND UPPER(Cast(SERVERPROPERTY(N'Edition') as sysname)) like N'%STANDARD%'  AND 4*(hyperthread_ratio\/2) &lt;= 24\n\t\t\tTHEN (4*(hyperthread_ratio))\/2  \n\t   WHEN ((cpu_count\/hyperthread_ratio)&lt;= 4) AND UPPER( Cast(SERVERPROPERTY(N'Edition') as sysname)) like N'%STANDARD%'  AND 4*(hyperthread_ratio\/2) &gt; 24\n\t\t\tTHEN 24\/2 \n       -- Limited to 4 sockets &amp; 16 cores for Web Edition \n\t   WHEN ((cpu_count\/hyperthread_ratio)&gt; 4) AND UPPER(Cast(SERVERPROPERTY(N'Edition') as sysname)) like '%WEB%'  AND 4*(hyperthread_ratio\/2) &lt;= 16\n\t\t\tTHEN (4*(hyperthread_ratio))\/2  \n\t   WHEN ((cpu_count\/hyperthread_ratio)&lt;= 4) AND UPPER(Cast(SERVERPROPERTY(N'Edition') as sysname)) like '%WEB%'  AND 4*(hyperthread_ratio\/2) &gt; 16\n\t\t\tTHEN 16\/2 \n       --Logical cores for Enterprise (unlimited)\n\t   ELSE cpu_count\/2   \n     END as [Number of licenses]\nFROM [sys].[dm_os_sys_info]<\/pre>\n<p>I run the query through a CMS (Central Management Server) and have some very interesting result to analyse:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52954 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png\" alt=\"\" width=\"447\" height=\"79\" \/><\/a><br \/>\nWhat we can analyse on this table result:<\/p>\n<ul>\n<li>For the server1, only 2 cores but you need to license 4 cores minimum then 2 licenses are needed<\/li>\n<li>For server2 and server3, no problem, it&#8217;s an Enterprise edition Number of License = number of cores\/2<\/li>\n<li>For the server4 it&#8217;s a standard edition with 4 cores and 4 sockets, no problem Number of License = number of cores\/2<\/li>\n<li>For the server5, a standard edition but with 6 sockets then limitation is 4 then Number of License = 4*4cores\/2<\/li>\n<li>For the server6 and server 7, we have an Express Edition and Developer Edition, no license needed<\/li>\n<\/ul>\n<p>I don&#8217;t test all cases but if you use it, I&#8217;m very interested by your feedback.<br \/>\nI hope this can help you also to have a good picture of your used core-based licenses in your environment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This week, a customer asks me to find out how many SQL Server Standard licenses are used in their environment. The licensing is core based and to not be used for Sserver + Cals licenses. To have an idea, I create a script following the Microsoft document about the licensing here. This script is valid [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":16954,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,368,99],"tags":[536,67,51],"type_dbi":[],"class_list":["post-16952","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-license","tag-performance","tag-sql-server"],"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: how to have the number of core-based licenses used on my environment? - 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\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: how to have the number of core-based licenses used on my environment?\" \/>\n<meta property=\"og:description\" content=\"This week, a customer asks me to find out how many SQL Server Standard licenses are used in their environment. The licensing is core based and to not be used for Sserver + Cals licenses. To have an idea, I create a script following the Microsoft document about the licensing here. This script is valid [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-08T07:14:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"605\" \/>\n\t<meta property=\"og:image:height\" content=\"106\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server: how to have the number of core-based licenses used on my environment?\",\"datePublished\":\"2021-12-08T07:14:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/\"},\"wordCount\":460,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png\",\"keywords\":[\"License\",\"Performance\",\"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\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/\",\"name\":\"SQL Server: how to have the number of core-based licenses used on my environment? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png\",\"datePublished\":\"2021-12-08T07:14:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png\",\"width\":605,\"height\":106},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: how to have the number of core-based licenses used on my environment?\"}]},{\"@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: how to have the number of core-based licenses used on my environment? - 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\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: how to have the number of core-based licenses used on my environment?","og_description":"This week, a customer asks me to find out how many SQL Server Standard licenses are used in their environment. The licensing is core based and to not be used for Sserver + Cals licenses. To have an idea, I create a script following the Microsoft document about the licensing here. This script is valid [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/","og_site_name":"dbi Blog","article_published_time":"2021-12-08T07:14:57+00:00","og_image":[{"width":605,"height":106,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server: how to have the number of core-based licenses used on my environment?","datePublished":"2021-12-08T07:14:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/"},"wordCount":460,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png","keywords":["License","Performance","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\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/","name":"SQL Server: how to have the number of core-based licenses used on my environment? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png","datePublished":"2021-12-08T07:14:57+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Scriptlicensing01.png","width":605,"height":106},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-have-the-number-of-core-based-licenses-used-on-my-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: how to have the number of core-based licenses used on my environment?"}]},{"@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\/16952","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=16952"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16952\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16954"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16952"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}