{"id":25225,"date":"2018-10-18T09:00:38","date_gmt":"2018-10-18T16:00:38","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25225"},"modified":"2024-01-22T22:51:19","modified_gmt":"2024-01-23T06:51:19","slug":"dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/","title":{"rendered":"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out"},"content":{"rendered":"<p>Whether you\u2019re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization\u2019s data to work. To turn the next-to-impossible into the practical, you need a comprehensive resource at your fingertips: SQL Server 2017 Administration Inside Out, by William Assaf, Randolph West, Sven Aelterman, and Mindy Curnutt. With this guide, you can get to know new and expanded SQL Server features like Columnstore, memory-optimized indexes, and Query Store, plus understand how to administer Microsoft Azure SQL Database or SQL Server 2017 virtual machines running on Azure.<\/p>\n<p>Here\u2019s just some of what you\u2019ll find in the ultimate guide to SQL Server 2017 (spoiler alert\u2014get free access to these chapters below):<\/p>\n<h2>Database server components<\/h2>\n<p>Even if you have a firm foundation in SQL Server configuration and administration, you want to keep the basics at-hand so you can easily refresh your memory. <a href=\"https:\/\/info.microsoft.com\/ww-landing-SQLDB-Pearson-Admin-Gated-Page-eBook.html\">SQL Server 2017 Administration Inside Out<\/a> provides a solid foundation in the infrastructure that makes up a database and how it works. The guide also offers helpful tips and best practices every DBA should know, like:<\/p>\n<ul>\n<li>Keep in mind that In-Memory OLTP requires RAM overhead that\u2019s two times the size of a memory-optimized object.<\/li>\n<li>Disable power saving everywhere. Power-saving settings in your operating system (OS) can result in poor query performance. Turn on High Performance at the OS and BIOS levels.<\/li>\n<li>Realize that Redundant Array of Independent Disks (RAID) shouldn\u2019t take the place of performing backups. It doesn\u2019t provide 100 percent protection from data loss.<\/li>\n<li>Ensure all TCP\/IP traffic to and from SQL Server is encrypted. If you\u2019re using the Shared Memory Protocol with applications that are all on the same server, this isn\u2019t required.<\/li>\n<\/ul>\n<h2>Securing the server and data<\/h2>\n<p>Recognizing that more frequent and complex cyberattacks are targeting your environment, SQL Server 2017 Administration Inside Out covers the security capabilities of SQL Server 2017 comprehensively. The guide helps you play defense to protect your data from attack and minimize the damage should you suffer a data breach. For example, you\u2019ll learn (or be reminded) that you can:<\/p>\n<ul>\n<li>Prevent common SQL injection attacks by making sure that all data is escaped, sanitized, and validated before input and that all SQL Server queries are parameterized.<\/li>\n<li>Use newer capabilities like Row-Level Security to restrict access through security policies based on group membership or execution context.<\/li>\n<li>Start SQL Server in single-user mode or with minimal configuration and remove the offending audit if that audit shuts down your SQL Server instance.<\/li>\n<\/ul>\n<h2>Performance tuning SQL Server<\/h2>\n<p>Ensuring your database performs at top speed is one of your highest priorities. You want to have an accurate and complete understanding of performance tuning concepts, the objects typically associated with tuning SQL Server database performance, and best practices that help your databases run at top speed. In SQL Server 2017 Administration Inside Out, you\u2019ll gain this critical knowledge, including:<\/p>\n<ul>\n<li>The NOLOCK hint (or READ UNCOMMITTED isolation level) can return invalid data. Not only can uncommitted data be read, but committed data can be read twice or skipped. You also run the risk of returning corrupt data or finding the query has failed.<\/li>\n<li>You can use the Query Store feature to help you analyze execution plan performance by looking at live Query Store data as it happens as well as at the history of statement execution. Query Store is one of the features that first appeared in Azure SQL Database and then moved to SQL Server on-premises.<\/li>\n<\/ul>\n<h2>All this info\u2014all in one place<\/h2>\n<p>This is only a small sample of the in-depth information you can find in SQL Server 2017 Administration Inside Out. Take the book for a test drive by <a href=\"https:\/\/info.microsoft.com\/ww-landing-SQLDB-Pearson-Admin-Gated-Page-eBook.html\">downloading a free custom excerpt<\/a>, including the three full chapters previewed above.<\/p>\n<h3 style=\"text-align: center\">With this excerpt, you\u2019ll also get an exclusive 50-percent discount code for the full 14-chapter e-book.<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25228 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/SQL-Server-2017-Administration-Inside-Out.png\" alt=\"\" width=\"294\" height=\"440\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/SQL-Server-2017-Administration-Inside-Out.webp 294w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/SQL-Server-2017-Administration-Inside-Out-200x300.webp 200w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/SQL-Server-2017-Administration-Inside-Out-167x250.webp 167w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/SQL-Server-2017-Administration-Inside-Out-234x350.webp 234w\" sizes=\"auto, (max-width: 294px) 100vw, 294px\" \/>Download the <a href=\"https:\/\/info.microsoft.com\/ww-landing-SQLDB-Pearson-Admin-Gated-Page-eBook.html\">free excerpt<\/a> from SQL Server 2017 Administration Inside Out today.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whether you\u2019re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization\u2019s data to work.<\/p>\n","protected":false},"author":1457,"featured_media":25786,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2391,5227,2406],"content-type":[2424],"topic":[2469,2475],"coauthors":[2487],"class_list":["post-25225","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-sql-database","product-sql","product-sql-server-2017","content-type-best-practices","topic-high-performance-database","topic-oltp-database-management"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out - 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\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Whether you\u2019re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization\u2019s data to work.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/\" \/>\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=\"2018-10-18T16:00:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"280\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"3 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\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out\",\"datePublished\":\"2018-10-18T16:00:38+00:00\",\"dateModified\":\"2024-01-23T06:51:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/\"},\"wordCount\":669,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/\",\"name\":\"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out - 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\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png\",\"datePublished\":\"2018-10-18T16:00:38+00:00\",\"dateModified\":\"2024-01-23T06:51:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png\",\"width\":280,\"height\":180,\"caption\":\"a group of people in a room\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out\"}]},{\"@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":"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out - 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\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/","og_locale":"en_US","og_type":"article","og_title":"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out - Microsoft SQL Server Blog","og_description":"Whether you\u2019re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization\u2019s data to work.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-10-18T16:00:38+00:00","article_modified_time":"2024-01-23T06:51:19+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png","type":"image\/png"}],"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":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out","datePublished":"2018-10-18T16:00:38+00:00","dateModified":"2024-01-23T06:51:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/"},"wordCount":669,"commentCount":2,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/","name":"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out - 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\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png","datePublished":"2018-10-18T16:00:38+00:00","dateModified":"2024-01-23T06:51:19+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/thumbnail-3.png","width":280,"height":180,"caption":"a group of people in a room"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/dba-essentials-sql-server-2017-security-performance-tuning-and-more-inside-out\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"DBA essentials\u2014SQL Server 2017 security, performance tuning, and more\u2014inside out"}]},{"@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\/25225","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=25225"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25225\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/25786"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=25225"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=25225"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=25225"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=25225"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=25225"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=25225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}