{"id":455,"date":"2021-12-27T16:31:34","date_gmt":"2021-12-27T15:31:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/2021\/12\/27\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/"},"modified":"2022-04-06T08:26:16","modified_gmt":"2022-04-06T06:26:16","slug":"sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/","title":{"rendered":"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist"},"content":{"rendered":"<p>By a customer this month, I see a very big big ErrorLog file (more than 1,5GB).<br \/>\nWhen I open the file, every 5 seconds, the following message is added:<\/p>\n<p style=\"color: red\">The activated proc &#8216;[dbo].[IdentityServerNotificationCleanup]&#8217; running on queue &#8216;&lt;database&gt;.dbo.IdentityServerNotificationsQueue&#8217; output the following:\u00a0 &#8216;Cannot execute as the database principal because the principal &#8220;dbo&#8221; does not exist, this type of principal cannot be impersonated, or you do not have permission.&#8217;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53349 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_02.png\" alt=\"\" width=\"300\" height=\"47\" \/><\/a>My first reflex was to open SSMS and right-click on the database to see the properties but I receive the this error message:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53350 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_01.png\" alt=\"\" width=\"300\" height=\"101\" \/><\/a><\/p>\n<p style=\"color: red\">\u201cProperty Owner is not available for Database &lt;database&gt;\u201d not allows me to open the properties.<\/p>\n<p>I open a query and ask to show all owner_sid with the view sys.databases:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT name, owner_sid FROM sys.databases<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53348 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_03.png\" alt=\"\" width=\"223\" height=\"300\" \/><\/a><\/p>\n<p>The result give me 2 type of sid:<\/p>\n<ul>\n<li>0x01 who is the SQL Login SA<\/li>\n<li>0x0105&#8230;. where is windows authentication<\/li>\n<\/ul>\n<p>To have more information, I use SUSER_SNAME to have the name associad with the owner_sid:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT name, owner_sid, SUSER_SNAME(owner_sid) as owner_name FROM sys.databases<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53347 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_04.png\" alt=\"\" width=\"300\" height=\"285\" \/><\/a><\/p>\n<p>As you can see in the result, some owner_name are NULL for a lot of database.<\/p>\n<p>To avoid this situation, I will force the \u2018sa\u2019 account to be the owner.<\/p>\n<p>I generate for each line, the command using sp_changedbowner and a clause where SNAME(owner_sid) is null in my query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT name, owner_sid,SUSER_SNAME(owner_sid) as owner_name,N'use ['+name+N'];EXEC sp_changedbowner ''sa'';' as Script_change_owner FROM sys.databases where SUSER_SNAME(owner_sid) is null<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53346 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.png\" alt=\"\" width=\"300\" height=\"87\" \/><\/a><\/p>\n<p>Applying the script generated and all databases have again a valid owner.<\/p>\n<p>Finally, I don\u2019t have anymore the message in the errorlog every 5 seconds and can correctly read the file after recycling it.<br \/>\nAnd of course, now I can open the properties through SSMS without error message.<\/p>\n<p>I hope this blog and script can help you if you have the same error message&#8230;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By a customer this month, I see a very big big ErrorLog file (more than 1,5GB). When I open the file, every 5 seconds, the following message is added: The activated proc &#8216;[dbo].[IdentityServerNotificationCleanup]&#8217; running on queue &#8216;&lt;database&gt;.dbo.IdentityServerNotificationsQueue&#8217; output the following:\u00a0 &#8216;Cannot execute as the database principal because the principal &#8220;dbo&#8221; does not exist, this type [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":460,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[49,51],"type_dbi":[],"class_list":["post-455","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","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>SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist - 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-cannot-execute-as-the-database-principal-dbo-does-not-exist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist\" \/>\n<meta property=\"og:description\" content=\"By a customer this month, I see a very big big ErrorLog file (more than 1,5GB). When I open the file, every 5 seconds, the following message is added: The activated proc &#8216;[dbo].[IdentityServerNotificationCleanup]&#8217; running on queue &#8216;&lt;database&gt;.dbo.IdentityServerNotificationsQueue&#8217; output the following:\u00a0 &#8216;Cannot execute as the database principal because the principal &#8220;dbo&#8221; does not exist, this type [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-27T15:31:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-06T06:26:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1369\" \/>\n\t<meta property=\"og:image:height\" content=\"396\" \/>\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\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist\",\"datePublished\":\"2021-12-27T15:31:34+00:00\",\"dateModified\":\"2022-04-06T06:26:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/\"},\"wordCount\":292,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/db_owner_05.png\",\"keywords\":[\"Microsoft\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/\",\"name\":\"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/db_owner_05.png\",\"datePublished\":\"2021-12-27T15:31:34+00:00\",\"dateModified\":\"2022-04-06T06:26:16+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/db_owner_05.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/db_owner_05.png\",\"width\":1369,\"height\":396},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist\"}]},{\"@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: Cannot execute as the database principal \u201cdbo\u201d does not exist - 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-cannot-execute-as-the-database-principal-dbo-does-not-exist\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist","og_description":"By a customer this month, I see a very big big ErrorLog file (more than 1,5GB). When I open the file, every 5 seconds, the following message is added: The activated proc &#8216;[dbo].[IdentityServerNotificationCleanup]&#8217; running on queue &#8216;&lt;database&gt;.dbo.IdentityServerNotificationsQueue&#8217; output the following:\u00a0 &#8216;Cannot execute as the database principal because the principal &#8220;dbo&#8221; does not exist, this type [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/","og_site_name":"dbi Blog","article_published_time":"2021-12-27T15:31:34+00:00","article_modified_time":"2022-04-06T06:26:16+00:00","og_image":[{"width":1369,"height":396,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.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\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist","datePublished":"2021-12-27T15:31:34+00:00","dateModified":"2022-04-06T06:26:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/"},"wordCount":292,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.png","keywords":["Microsoft","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/","name":"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.png","datePublished":"2021-12-27T15:31:34+00:00","dateModified":"2022-04-06T06:26:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db_owner_05.png","width":1369,"height":396},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-cannot-execute-as-the-database-principal-dbo-does-not-exist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: Cannot execute as the database principal \u201cdbo\u201d does not exist"}]},{"@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\/455","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=455"}],"version-history":[{"count":8,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/455\/revisions"}],"predecessor-version":[{"id":17016,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/455\/revisions\/17016"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/460"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=455"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}