{"id":17607,"date":"2021-11-22T18:57:51","date_gmt":"2021-11-22T13:27:51","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=17607"},"modified":"2021-11-22T18:57:51","modified_gmt":"2021-11-22T13:27:51","slug":"dp-300-day3","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/","title":{"rendered":"[DP-300] Day3 Q\/A Review: Implement A Secure Environment"},"content":{"rendered":"<p><b data-stringify-type=\"bold\">Implement a secure environment<\/b><\/p>\n<p>Azure SQL Database has several authentication and authorization options that are different from the options in SQL Server. This is because Azure SQL Database and Azure SQL Managed Instance rely on Azure Active Directory instead of Windows Server Active Directory. In Azure, while implementing a secure environment we explore encryptions, firewalls, advanced threat protection, and how to achieve the policy of least privileges.<\/p>\n<p><b data-stringify-type=\"bold\">Name the SQL Server Authentication options.<\/b><\/p>\n<p>\u2022 Windows Authentication: User login information is stored in Active Directory.<br \/>\n\u2022SQL Server Authentication: User login information is stored in the master or user database.<\/p>\n<p><b data-stringify-type=\"bold\">What is Azure Active Directory Authentication?<\/b><\/p>\n<p>\u2022 Azure Active Directory can be synced to on-premises Active Directory. Azure Active Directory authentication can allow Windows Style Authentication into cloud-hosted databases. Multi-factor authentication is fully supported.<br \/>\n\u2022 The Active Directory Admin will have full rights to the SQL Database server, similar to being a member of the sysadmin fixed server role in an on-premises install of SQL Server.<br \/>\n\u2022In order to add Users with Azure Active Directory Authentication, you must first configure the AAD admin.<\/p>\n<p>Do Check Our Blog at\u00a0<a href=\"https:\/\/k21academy.com\/microsoft-azure\/database-administrator\/dp-300-day3\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp300day3_november21\"><em><strong>k21academy.com\/dp300day3<\/strong><\/em><\/a><\/p>\n<p><b data-stringify-type=\"bold\">What are the Security Principals?<\/b><\/p>\n<p>Security Principals are entities that can request SQL Server resources and to which you can (usually) grant permissions.<\/p>\n<p>There are several sets of security principles in SQL Server. Security principals exist at either the server level or the database level and can be either individuals or collections.<\/p>\n<p>If you are planning to become a Microsoft Azure Database Administrator Associate, then join the\u00a0<strong>FREE CLASS<\/strong>\u00a0now at\u00a0<a href=\"https:\/\/k21academy.com\/microsoft-azure-database-training-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30002_November21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/ dp30002<\/strong><\/em><\/a><\/p>\n<p><a href=\"https:\/\/k21academy.com\/microsoft-azure-database-training-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30002_November21\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/k21academy.com\/wp-content\/uploads\/2021\/06\/DBAdmin_CU.gif\" alt=\"DBAdmin_CU\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Implement a secure environment Azure SQL Database has several authentication and authorization options that are different from the options in [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":17608,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[568,540],"tags":[],"class_list":["post-17607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dp-300","category-microsoft-azure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[DP-300] Day3 Q\/A Review: Implement A Secure Environment<\/title>\n<meta name=\"description\" content=\"This post will go through some quick tips including Q\/A and related blog posts we covered in implement a secure environment\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[DP-300] Day3 Q\/A Review: Implement A Secure Environment\" \/>\n<meta property=\"og:description\" content=\"This post will go through some quick tips including Q\/A and related blog posts we covered in implement a secure environment\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-22T13:27:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1125\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/\",\"name\":\"[DP-300] Day3 Q\/A Review: Implement A Secure Environment\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png\",\"datePublished\":\"2021-11-22T13:27:51+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"This post will go through some quick tips including Q\/A and related blog posts we covered in implement a secure environment\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png\",\"width\":1125,\"height\":629,\"caption\":\"DP300\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[DP-300] Day3 Q\/A Review: Implement A Secure Environment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[DP-300] Day3 Q\/A Review: Implement A Secure Environment","description":"This post will go through some quick tips including Q\/A and related blog posts we covered in implement a secure environment","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:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/","og_locale":"en_US","og_type":"article","og_title":"[DP-300] Day3 Q\/A Review: Implement A Secure Environment","og_description":"This post will go through some quick tips including Q\/A and related blog posts we covered in implement a secure environment","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/","article_published_time":"2021-11-22T13:27:51+00:00","og_image":[{"width":1125,"height":629,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png","type":"image\/png"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/","name":"[DP-300] Day3 Q\/A Review: Implement A Secure Environment","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png","datePublished":"2021-11-22T13:27:51+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"This post will go through some quick tips including Q\/A and related blog posts we covered in implement a secure environment","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/11\/DP300_Day3.png","width":1125,"height":629,"caption":"DP300"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/11\/22\/dp-300-day3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"[DP-300] Day3 Q\/A Review: Implement A Secure Environment"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/17607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=17607"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/17607\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/17608"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=17607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=17607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=17607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}