{"id":2391,"date":"2012-03-15T20:15:31","date_gmt":"2012-03-15T19:15:31","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/"},"modified":"2012-03-15T20:15:31","modified_gmt":"2012-03-15T19:15:31","slug":"sql-server-2012-how-to-create-a-server-role","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/","title":{"rendered":"SQL Server 2012: How to create a Server Role?"},"content":{"rendered":"<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">Recently, during one of my missions, a client asked me to give him access rights to the SQL Server logs from SSMS to his application managers. As you know, you must grant the role \u201c<strong>securityadmin<\/strong>\u201d to have such rights. However, with this role you can also manage logins, CREATE DATABASEs and change passwords.<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">These are \u201ctoo many rights\u201d for an IT manager, but there seems to be no other way \ud83d\ude25 \u00a0&#8230; or is there?<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">Of course, SQL Server 2012 can resolve this problem! <strong>How?<\/strong><\/p>\n<ul>\n<li><strong>\u00a0<\/strong>Since SQL Server 2012, you can <strong>create your own server roles<\/strong>.<\/li>\n<\/ul>\n<h3 lang=\"en-US\" style=\"margin-bottom: 0cm;\">Step 1: Create a user for my demo<\/h3>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">I can create a simple SQL server user with the right to be owner of the famous AdventureWorks Database.<\/p>\n<p style=\"margin-bottom: 0cm;\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png\" alt=\"Createuser1\" width=\"563\" height=\"315\" \/><\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">I can connect to SSMS (SQL Server Management Studio) with this account.<\/p>\n<p style=\"margin-bottom: 0cm;\">\u00a0<img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Connection.png\" alt=\"Connection\" width=\"286\" height=\"212\" \/><\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">Let&#8217;s try to look up the SQL Server Logs&#8230;<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ReadingLogsError.png\" alt=\"ReadingLogsError\" width=\"618\" height=\"230\" \/><\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">In the error message, we can read:<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">\u201c<em>Only members of the securityadmin role can execute this stored procedure<\/em>\u201d Error 15003<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">Naturally, the easiest way is to give \u201csecurityadmin\u201d role to my user Appli_Responsable, but I don&#8217;t want this user to be able to create new databases or new users.<br \/>\nMy new choice is to do <strong>my own role to read the logs:-D<\/strong><\/p>\n<h3 style=\"margin-bottom: 0cm;\">Step 2: Create a new server role<\/h3>\n<p style=\"margin-bottom: 0cm;\">Connect to your instance with sysadmin rights and then you can use the wizard or type directly in a query.<\/p>\n<p style=\"margin-bottom: 0cm;\">In my example, I created the server role \u201cReadingSQLServerLogs\u201d<\/p>\n<p style=\"margin-bottom: 0cm;\">I then granted the \u201c<strong>VIEW SERVER STATE<\/strong>\u201d to my role and the \u201cCONNECT\u201d by default.<\/p>\n<p style=\"margin-bottom: 0cm;\">These rights are sufficient to read the logs.<\/p>\n<p style=\"margin-bottom: 0cm;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AddRole.png\" alt=\"AddRole\" width=\"581\" height=\"432\" \/><\/p>\n<p style=\"margin-bottom: 0cm;\">Now, we can grant this role to the user Appli_Responsable like this:<\/p>\n<p style=\"margin-bottom: 0cm;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/GiveRoleToUser.png\" alt=\"GiveRoleToUser\" width=\"588\" height=\"315\" \/><\/p>\n<h3 style=\"margin-bottom: 0cm;\">Step 3: Read the Logs<\/h3>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">Let&#8217;s connect my user and\u2026hohoho\u2026:-)&#8230;I can read logs!<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ReadLogFile.png\" alt=\"ReadLogFile\" width=\"464\" height=\"513\" \/><\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">To finish my demo, I tried to create a database and a user and I cannot \u2026 not enough rights!<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\">These two pictures are proof:<\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CreateDatabase.png\" alt=\"CreateDatabase\" width=\"534\" height=\"477\" \/><\/p>\n<p lang=\"en-US\" style=\"margin-bottom: 0cm;\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CreateUser.png\" alt=\"CreateUser\" width=\"533\" height=\"392\" \/><\/p>\n<h3 lang=\"en-US\" style=\"margin-bottom: 0cm;\">Conclusion<\/h3>\n<p style=\"margin-bottom: 0cm;\">I just wanted to present this new simple and useful feature to you. I hope this gives you some good ideas for the security of your databases in the future!<\/p>\n","protected":false},"excerpt":{"rendered":"<p style=\"margin-bottom: 0cm;\" lang=\"en-US\">Recently, during my many missions, a client asked me to give access rights to the SQL Server Logs from SSMS to his application managers.<\/p>\n<p style=\"margin-bottom: 0cm;\" lang=\"en-US\">\u00a0<\/p>\n<p style=\"margin-bottom: 0cm;\" lang=\"en-US\">As you know, you must give the role \u201c<strong>securityadmin<\/strong>\u201d to have such rights but with this role you can also manage logins, CREATE DATABASEs and change passwords.<\/p>\n<p style=\"margin-bottom: 0cm;\" lang=\"en-US\">This is \u201ctoo many rights\u201d for this IT manager\u2026 but no other way!<img decoding=\"async\" src=\"plugins\/editors\/jce\/tiny_mce\/plugins\/emotions\/img\/smiley-cry.gif\" alt=\"Cry\" title=\"Cry\" border=\"0\" \/><\/p>\n","protected":false},"author":15,"featured_media":2392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[23,293,49,54],"type_dbi":[],"class_list":["post-2391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-dba","tag-denali","tag-microsoft","tag-sql-server-2012"],"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 2012: How to create a Server Role? - dbi Blog<\/title>\n<meta name=\"description\" content=\"Since SQL Server 2012, you can create your own server roles. This posting presents this new simple and useful feature using an example.\" \/>\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-2012-how-to-create-a-server-role\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012: How to create a Server Role?\" \/>\n<meta property=\"og:description\" content=\"Since SQL Server 2012, you can create your own server roles. This posting presents this new simple and useful feature using an example.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-15T19:15:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1013\" \/>\n\t<meta property=\"og:image:height\" content=\"570\" \/>\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-2012-how-to-create-a-server-role\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2012: How to create a Server Role?\",\"datePublished\":\"2012-03-15T19:15:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/\"},\"wordCount\":355,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png\",\"keywords\":[\"DBA\",\"Denali\",\"Microsoft\",\"SQL Server 2012\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/\",\"name\":\"SQL Server 2012: How to create a Server Role? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png\",\"datePublished\":\"2012-03-15T19:15:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Since SQL Server 2012, you can create your own server roles. This posting presents this new simple and useful feature using an example.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png\",\"width\":1013,\"height\":570},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012: How to create a Server Role?\"}]},{\"@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 2012: How to create a Server Role? - dbi Blog","description":"Since SQL Server 2012, you can create your own server roles. This posting presents this new simple and useful feature using an example.","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-2012-how-to-create-a-server-role\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012: How to create a Server Role?","og_description":"Since SQL Server 2012, you can create your own server roles. This posting presents this new simple and useful feature using an example.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/","og_site_name":"dbi Blog","article_published_time":"2012-03-15T19:15:31+00:00","og_image":[{"width":1013,"height":570,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.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-2012-how-to-create-a-server-role\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2012: How to create a Server Role?","datePublished":"2012-03-15T19:15:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/"},"wordCount":355,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png","keywords":["DBA","Denali","Microsoft","SQL Server 2012"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/","name":"SQL Server 2012: How to create a Server Role? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png","datePublished":"2012-03-15T19:15:31+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Since SQL Server 2012, you can create your own server roles. This posting presents this new simple and useful feature using an example.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Createuser1.png","width":1013,"height":570},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-how-to-create-a-server-role\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012: How to create a Server Role?"}]},{"@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\/2391","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=2391"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2392"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2391"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}