{"id":3273,"date":"2012-08-02T09:00:00","date_gmt":"2012-08-02T16:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/"},"modified":"2024-01-22T22:49:35","modified_gmt":"2024-01-23T06:49:35","slug":"guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/","title":{"rendered":"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test?"},"content":{"rendered":"

Guest Blog Authors:<\/em>
\nBuck Woody<\/strong>, Senior Technical Professional, Windows Azure and Cloud Computing at Microsoft<\/span>
\nboB Taylor<\/strong>, Principal Content Publishing Manager MCSM at Microsoft<\/span><\/span><\/p>\n

When we put our heads together to figure out the challenges for the reality show Be the Next Microsoft<\/i> Employee<\/i>, we had a few requirements that we used as a filter: 1) real-world, 2) top-of-mind, and 3) a must-know for any member of the USIT team.<\/span><\/p>\n

It was clear \u2018security\u2019 was going to need to be its own challenge, given its increasing importance.<\/span><\/p>\n

We thought long and hard about what the challenge should include\u2014there\u2019s no shortage of security challenges to tackle. In the end, we had them focus specifically on least privilege, among other things.<\/span><\/p>\n

The nitty gritty<\/span><\/b><\/p>\n

This week\u2019s challenge asked contestants to use the AdventureWorks 2005 database they installed on their laptops at the start of the show to assign three new (fictional) hires various levels of access. It seemed simple enough, but there was a lot more to it than met the eye. (Read a <\/span>complete overview of the challenge<\/span><\/a> for the various twists and turns we served up.) Specifically, the contestants were asked to support specific types of activities such as updating a certain record. While some of the contestants were able to apply the correct UPDATE permissions, they failed to allow SELECT permissions \u2013 which were required in order to find the specific record that had to be updated. For example, the challenge asked the contestants to allow Dave Salesperson to update the address of a person when provided with an AddressID. To do so requires T-SQL of the following form:<\/span><\/p>\n

UPDATE<\/span> Person.<\/span>Address
\n<\/span><\/span>SET<\/span> AddressLine1 =<\/span> ‘123 Here Street’<\/span>
\n<\/span>WHERE<\/span> AddressID<\/span> = 20731;<\/span><\/span><\/p><\/blockquote>\n

If the user only had UPDATE permissions, this would fail with SELECT permission issue as seen in this error message:<\/span><\/p>\n

Msg 15517, Level 16, State 1, Line 103
\nCannot execute as the database principal because the principal “DaveSalesperson2” does not exist, this type of principal cannot be impersonated, or you do not have permission.<\/span><\/p>\n

The contestants were also judged on several \u2018extra credit\u2019 activities such as setting a default database and default schema for their logins and users. The ultimate icing on the cake, however, would have been if one of them had used flexible database roles, allowing permissions to be granted to groups of users instead of on an individual basis.<\/span><\/p>\n

Real-world results?<\/span><\/b><\/p>\n

This week\u2019s challenge caught more than one of our contestants off-guard, as evident in the <\/span>presentation of their solutions<\/span><\/a> to the judges\u2019 panel. In the end, one of them emerged as the clear winner, but no one was able to completely<\/i> solve the problem in the 100 minutes allowed. (In fact, when we ran the script to test their solutions on their laptops, every contestant failed to pass it!)<\/span><\/p>\n

Did we meet the real-world filter with this challenge? You bet. This week\u2019s challenge highlights how important it is for database administrators to unearth the real<\/i> challenge underlying a \u201cpresenting problem,\u201d to use existing documentation and support rather than re-inventing the wheel, and to go after the big things first. Have you had to employ those same tactics in your work as a DBA?<\/span><\/p>\n

Watch Episode 2<\/span><\/a> to see what steps the contestants missed and why we chose our winner even though he\/she failed to pass the script.<\/span><\/p>\n

Wanna play?<\/span><\/b><\/p>\n

Have your own idea for a great security challenge to test the real-world skills of DBAs? Submit it to our <\/span>Play @ Home challenge<\/span><\/a> this week. If your proposed security challenge is selected, you\u2019ll win a free eBook from Microsoft Press and have a shot at the grand prize \u2013 an HP Folio 13 Ultrabook. <\/span><\/p>\n

Next week<\/span><\/a>, we\u2019ll see if we can activate the top-of-mind and must-know filters a bit more!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Guest Blog Authors: Buck Woody, Senior Technical Professional, Windows Azure and Cloud Computing at Microsoft boB Taylor, Principal Content Publishing Manager MCSM at Microsoft When we put our heads together to figure out the challenges for the reality show Be the Next Microsoft Employee, we had a few requirements that we used as a filter:.<\/p>\n","protected":false},"author":1457,"featured_media":33506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2445],"topic":[],"coauthors":[2487],"class_list":["post-3273","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-thought-leadership","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-free-1593619513-128","review-flag-new-1593580247-437"],"yoast_head":"\nGuest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test? - Microsoft SQL Server 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.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test? - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Guest Blog Authors: Buck Woody, Senior Technical Professional, Windows Azure and Cloud Computing at Microsoft boB Taylor, Principal Content Publishing Manager MCSM at Microsoft When we put our heads together to figure out the challenges for the reality show Be the Next Microsoft Employee, we had a few requirements that we used as a filter:.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-02T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test?\",\"datePublished\":\"2012-08-02T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/\"},\"wordCount\":634,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/\",\"name\":\"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test? - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg\",\"datePublished\":\"2012-08-02T16:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg\",\"width\":1280,\"height\":720,\"caption\":\"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test? - Microsoft SQL Server 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.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/","og_locale":"en_US","og_type":"article","og_title":"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test? - Microsoft SQL Server Blog","og_description":"Guest Blog Authors: Buck Woody, Senior Technical Professional, Windows Azure and Cloud Computing at Microsoft boB Taylor, Principal Content Publishing Manager MCSM at Microsoft When we put our heads together to figure out the challenges for the reality show Be the Next Microsoft Employee, we had a few requirements that we used as a filter:.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-08-02T16:00:00+00:00","article_modified_time":"2024-01-23T06:49:35+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg","type":"image\/jpeg"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test?","datePublished":"2012-08-02T16:00:00+00:00","dateModified":"2024-01-23T06:49:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/"},"wordCount":634,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/","name":"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test? - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg","datePublished":"2012-08-02T16:00:00+00:00","dateModified":"2024-01-23T06:49:35+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/guest-blog-post-be-the-next-cont.jpg","width":1280,"height":720,"caption":"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test?"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/02\/guest-blog-post-be-the-next-contestants-tackle-sql-server-security-but-do-they-pass-the-test\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Guest Blog Post: Be the Next contestants tackle SQL Server Security \u2013 but do they pass the test?"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3273"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3273\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/33506"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3273"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3273"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3273"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3273"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3273"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}