{"id":11598,"date":"2018-08-29T13:19:39","date_gmt":"2018-08-29T11:19:39","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/"},"modified":"2018-08-29T13:19:39","modified_gmt":"2018-08-29T11:19:39","slug":"sql-server-tips-drop-a-database-user-attached-to-a-service","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/","title":{"rendered":"SQL Server Tips: Drop a database-user attached to a service\u2026"},"content":{"rendered":"<p>Few weeks ago, I have a little issue when I try to drop a database-user without login<\/p>\n<p>Unfortunately, I do a little mistake at the beginning\u2026<br \/>\nI receive like every morning a report if all AD logins (computers, groups, users) registered on SQL server instances are in the AD with the useful command sp_validatelogins<br \/>\nThis report indicates that a computer name <strong>dbi\\server_name$ <\/strong>was no more in the AD.<br \/>\nI drop the login without problem and without verifying the binding with database-users (this was my mistake\u2026). \ud83d\ude15<\/p>\n<p>The day after, I receive another alert that I have an orphan database-user on the SCOM database OperationManager12.<\/p>\n<p>My reaction was to connect to the instance and go dropping the user like usual when I become this alert.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27449 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg\" alt=\"error_drop_server01\" width=\"300\" height=\"64\" \/><\/a><br \/>\nAs you can see, I receive the error message:<br \/>\n<span style=\"color: red\">Msg 15284, Level 16, State 1, Line 15<br \/>\nThe database principal has granted or denied permissions to objects in the database and cannot be dropped.<\/span><br \/>\nI &#8220;google&#8221; the error and found some explanations.<br \/>\nThe user is owner of services in the service broker and I use this query to find the message:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select * from sys.database_permissions where grantor_principal_id = user_id('dbi\\server_name$')<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server02.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27450 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server02.jpg\" alt=\"error_drop_server02\" width=\"300\" height=\"111\" \/><\/a><br \/>\nThe user is linked to a service number 65536. I search now the service linked to this number.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server03.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27451 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server03.jpg\" alt=\"error_drop_server03\" width=\"300\" height=\"113\" \/><\/a><br \/>\nWith the name of the service, I can revoke the SEND permission from this user.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server04.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27452 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server04.jpg\" alt=\"error_drop_server04\" width=\"300\" height=\"92\" \/><\/a><br \/>\nAnd I receive this error:<br \/>\n<span style=\"color: red\">Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.<\/span><br \/>\nWith the Google\u2019s help, I re-try with the EXECUTE AS command with the server name as user:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">EXECUTE AS USER= 'dbi\\server_name$'\nREVOKE SEND ON SERVICE::Service_mid10_39_40_55_pid4288_adid2_r479087710 FROM [dbi\\server_name$]\nREVERT<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server05.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27453 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server05.jpg\" alt=\"error_drop_server05\" width=\"300\" height=\"78\" \/><\/a><br \/>\nAs excepted, I receive a new error:<br \/>\n<span style=\"color: red\">Msg 15404, Level 16, State 11, Line 37<br \/>\nCould not obtain information about Windows NT group\/user \u2018dbi\\server_name$\u2019, error code 0x534<\/span><br \/>\nThe login does not more exist, then it\u2019s normal to have this error.<br \/>\nAnd now, what to do?<br \/>\nThe only workaround that I found, is to drop the service, drop the user an recreate the service with dbo as owner(before dropping, create the create service statement before):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DROP SERVICE [Service_mid10_39_40_55_pid4288_adid2_r479087710]\nGO<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server06.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27454 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server06.jpg\" alt=\"error_drop_server06\" width=\"300\" height=\"98\" \/><\/a><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE [OperationsManager12]\nGO\nDROP USER [dbi\\server_name$]\nGO<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server07.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27455 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server07.jpg\" alt=\"error_drop_server07\" width=\"300\" height=\"155\" \/><\/a><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">CREATE SERVICE [Service_mid10_39_40_55_pid4288_adid2_r479087710]\u00a0 ON QUEUE [dbo].[Queue_mid10_39_40_55_pid4288_adid2_r479087710] ([http:\/\/schemas.microsoft.com\/SQL\/Notifications\/PostQueryNotification])\nGO<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server08.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-27456 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server08.jpg\" alt=\"error_drop_server08\" width=\"300\" height=\"231\" \/><\/a><br \/>\nEt voila! It was a little bit tricky to find out a solution but this one works! \ud83d\ude0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Few weeks ago, I have a little issue when I try to drop a database-user without login Unfortunately, I do a little mistake at the beginning\u2026 I receive like every morning a report if all AD logins (computers, groups, users) registered on SQL server instances are in the AD with the useful command sp_validatelogins This [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":11599,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[49,25,51],"type_dbi":[],"class_list":["post-11598","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-sql-server","tag-microsoft","tag-security","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 Tips: Drop a database-user attached to a service\u2026 - 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-tips-drop-a-database-user-attached-to-a-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Tips: Drop a database-user attached to a service\u2026\" \/>\n<meta property=\"og:description\" content=\"Few weeks ago, I have a little issue when I try to drop a database-user without login Unfortunately, I do a little mistake at the beginning\u2026 I receive like every morning a report if all AD logins (computers, groups, users) registered on SQL server instances are in the AD with the useful command sp_validatelogins This [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-29T11:19:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"785\" \/>\n\t<meta property=\"og:image:height\" content=\"168\" \/>\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-tips-drop-a-database-user-attached-to-a-service\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server Tips: Drop a database-user attached to a service\u2026\",\"datePublished\":\"2018-08-29T11:19:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/\"},\"wordCount\":358,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg\",\"keywords\":[\"Microsoft\",\"Security\",\"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-tips-drop-a-database-user-attached-to-a-service\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/\",\"name\":\"SQL Server Tips: Drop a database-user attached to a service\u2026 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg\",\"datePublished\":\"2018-08-29T11:19:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg\",\"width\":785,\"height\":168},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Tips: Drop a database-user attached to a service\u2026\"}]},{\"@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 Tips: Drop a database-user attached to a service\u2026 - 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-tips-drop-a-database-user-attached-to-a-service\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Tips: Drop a database-user attached to a service\u2026","og_description":"Few weeks ago, I have a little issue when I try to drop a database-user without login Unfortunately, I do a little mistake at the beginning\u2026 I receive like every morning a report if all AD logins (computers, groups, users) registered on SQL server instances are in the AD with the useful command sp_validatelogins This [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/","og_site_name":"dbi Blog","article_published_time":"2018-08-29T11:19:39+00:00","og_image":[{"width":785,"height":168,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.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-tips-drop-a-database-user-attached-to-a-service\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server Tips: Drop a database-user attached to a service\u2026","datePublished":"2018-08-29T11:19:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/"},"wordCount":358,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg","keywords":["Microsoft","Security","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-tips-drop-a-database-user-attached-to-a-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/","name":"SQL Server Tips: Drop a database-user attached to a service\u2026 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg","datePublished":"2018-08-29T11:19:39+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/error_drop_server01.jpg","width":785,"height":168},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-drop-a-database-user-attached-to-a-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Tips: Drop a database-user attached to a service\u2026"}]},{"@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\/11598","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=11598"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11598\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11599"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11598"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}