{"id":11967,"date":"2018-11-07T13:53:07","date_gmt":"2018-11-07T12:53:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/"},"modified":"2018-11-07T13:53:07","modified_gmt":"2018-11-07T12:53:07","slug":"sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/","title":{"rendered":"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle"},"content":{"rendered":"<p>After long hours of flights, Christophe Cosme and I finally arrived in Seattle at the SQL PASS Summit 2018. We picked up our badge and bag and now we are ready to begin&#8230;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/welcome2.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-29253 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/welcome2.png\" alt=\"welcome2\" width=\"300\" height=\"225\" \/><\/a><\/p>\n<p>This first day for me started with the pre-conference about SQL Server Security with Denny Cherry.<br \/>\nMany topics were discussed like:<\/p>\n<ul>\n<li>Network Designs (such as public IP vs. Private IP)<\/li>\n<li>Firewall configurations (such as Network Design between Public network, Internal network and DMZ)<\/li>\n<li>Physical Security Options (such as Cloud security)<\/li>\n<li>Data Encryption Options (such as Always Encrypted)<\/li>\n<li>Password Protection Options (such as rules to set a sql login password)<\/li>\n<li>Contained Databases (such as principle of contained Databases)<\/li>\n<li>Always On Availability Groups Security (such as new roles and sysadmin role)<\/li>\n<li>Internet-facing Applications (such as SQL CLR risks)<\/li>\n<li>SQL injections (Ascii characters that aren\u2019t actually ascii)<\/li>\n<li>Backups (such as backups encryption using TDE or Backup encryption)<\/li>\n<li>Antivirus (such as Best Practice for the Antivirus)<\/li>\n<li>SAN Security Designs (such as disk encryption option)<\/li>\n<li>SQL Server Auditing Options (such as setting up auditing)<\/li>\n<\/ul>\n<p>It will be a tough to go through all these subjects and all are interesting&#8230;<\/p>\n<p style=\"text-align: center\">\u00a0<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/preconf2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-29252\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/preconf2.png\" alt=\"preconf2\" width=\"300\" height=\"225\" \/><\/a><\/p>\n<p>I preferred focusing on the Antivirus topic and to give you a little update on that.<br \/>\nFirst, we know that Antivirus can cause issues (CPU, memory and IO) on SQL Server.<br \/>\nAs I always tell my customers, it is better not to install an antivirus on a server with SQL Server.<br \/>\nWhy? Performance can be impacted but also because it will corrupt your databases too.<br \/>\nIn the case that you have an Antivirus installed on a SQL Server, Denny gave us a good way to verify if it will inject itself into SQL Server:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.dm_os_loaded_modules where company != 'Microsoft Corporation'\n<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-29251 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.png\" alt=\"loaded_modules\" width=\"300\" height=\"127\" \/><\/a><br \/>\nThis is also a good way to verify for other providers too and see a security break!<br \/>\nBeside this, do not forget to exclude files, folders and SQL Server from the Antivirus.<br \/>\nThe list of exclusions is on the TechNet website <a title=\"Antivirus list of exclusion\" href=\"https:\/\/blogs.technet.microsoft.com\/raymond_ris\/2014\/01\/16\/windows-antivirus-exclusion-recommendations-servers-clients-and-role-specific\/ttp:\/\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a><\/p>\n<p>A point I really ignored was that SQL Server 2016 &amp; after, include and enabled Windows Defender but you can have very poor performance if is not setup correctly&#8230;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/antivirus.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-29255 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/antivirus.png\" alt=\"antivirus\" width=\"300\" height=\"117\" \/><\/a><\/p>\n<p>As conclusion, I will just write that Antivirus is good but not for SQL Server! \ud83d\ude0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After long hours of flights, Christophe Cosme and I finally arrived in Seattle at the SQL PASS Summit 2018. We picked up our badge and bag and now we are ready to begin&#8230; This first day for me started with the pre-conference about SQL Server Security with Denny Cherry. Many topics were discussed like: Network [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":11970,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99,48],"tags":[49,25,51,566],"type_dbi":[],"class_list":["post-11967","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","category-technology-survey","tag-microsoft","tag-security","tag-sql-server","tag-sql-server-2016"],"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 security pre-conference @SQL Pass Summit 2018 in Seattle - 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-security-pre-conference-sql-pass-summit-2018-in-seattle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle\" \/>\n<meta property=\"og:description\" content=\"After long hours of flights, Christophe Cosme and I finally arrived in Seattle at the SQL PASS Summit 2018. We picked up our badge and bag and now we are ready to begin&#8230; This first day for me started with the pre-conference about SQL Server Security with Denny Cherry. Many topics were discussed like: Network [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-07T12:53:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1374\" \/>\n\t<meta property=\"og:image:height\" content=\"580\" \/>\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-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle\",\"datePublished\":\"2018-11-07T12:53:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/\"},\"wordCount\":376,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/loaded_modules.png\",\"keywords\":[\"Microsoft\",\"Security\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"SQL Server\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/\",\"name\":\"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/loaded_modules.png\",\"datePublished\":\"2018-11-07T12:53:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/loaded_modules.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/loaded_modules.png\",\"width\":1374,\"height\":580},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle\"}]},{\"@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 security pre-conference @SQL Pass Summit 2018 in Seattle - 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-security-pre-conference-sql-pass-summit-2018-in-seattle\/","og_locale":"en_US","og_type":"article","og_title":"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle","og_description":"After long hours of flights, Christophe Cosme and I finally arrived in Seattle at the SQL PASS Summit 2018. We picked up our badge and bag and now we are ready to begin&#8230; This first day for me started with the pre-conference about SQL Server Security with Denny Cherry. Many topics were discussed like: Network [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/","og_site_name":"dbi Blog","article_published_time":"2018-11-07T12:53:07+00:00","og_image":[{"width":1374,"height":580,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.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-security-pre-conference-sql-pass-summit-2018-in-seattle\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle","datePublished":"2018-11-07T12:53:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/"},"wordCount":376,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.png","keywords":["Microsoft","Security","SQL Server","SQL Server 2016"],"articleSection":["Database Administration &amp; Monitoring","SQL Server","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/","name":"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.png","datePublished":"2018-11-07T12:53:07+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/loaded_modules.png","width":1374,"height":580},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-security-pre-conference-sql-pass-summit-2018-in-seattle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL server security pre-conference @SQL Pass Summit 2018 in Seattle"}]},{"@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\/11967","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=11967"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11967\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11970"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11967"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}