{"id":4866,"date":"2018-01-10T10:07:07","date_gmt":"2018-01-10T18:07:07","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4866"},"modified":"2018-01-10T10:07:07","modified_gmt":"2018-01-10T18:07:07","slug":"new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/","title":{"rendered":"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database"},"content":{"rendered":"<p style=\"text-align: justify;\">Erin\u2019s latest Pluralsight course has been published \u2013 <em>SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database<\/em>.\u00a0It\u2019s\u00a090 minutes\u00a0long, and from the course description:<\/p>\n<p style=\"text-align: justify;\"><em>There&#8217;s a whole new world of automated features in SQL Server, based on data, that are designed to make life easier for the data professional, and it&#8217;s time to start using them! Microsoft has invested a lot of effort in these tools that can automate areas of performance tuning and give you time to work on more interesting and creative tasks that can&#8217;t be automated. In this course, SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database, you&#8217;ll learn how Query Store has been upgraded to also collect wait statistics from queries, to allow you to identify performance bottlenecks at the query level and dig deeper to resolve them. Next, you&#8217;ll explore Automatic Plan Forcing, which allows SQL Server to identify queries where performance has regressed and automatically force a prior query plan that is more efficient. Finally, you&#8217;ll take a dive into Automatic Index Management, which gives SQL Server the capability to automatically create missing indexes and remove unused or duplicate indexes. By the end of this course, you&#8217;ll have the skills and knowledge to start enabling these features in appropriate parts of your SQL Server environment and taking back some of your precious time!<\/em><\/p>\n<p>The modules are:<\/p>\n<ul>\n<li>Introduction<\/li>\n<li>Finding and Using Wait Statistics in Query Store<\/li>\n<li>Using Automatic Plan Correction<\/li>\n<li>Using Automatic Index Management<\/li>\n<\/ul>\n<p>Check it out\u00a0<a href=\"https:\/\/app.pluralsight.com\/library\/courses\/sqlserver-azure-database\/table-of-contents\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">We now have more than 170 hours of SQLskills online training available (see all our\u00a056 courses\u00a0<a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/online-training\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>), all for as little as $29\/month through Pluralsight (including more than 6,000\u00a0other developer and IT training courses). That\u2019s unbeatable value that you can\u2019t afford to ignore.<\/p>\n<p>Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Erin\u2019s latest Pluralsight course has been published \u2013 SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database.\u00a0It\u2019s\u00a090 minutes\u00a0long, and from the course description: There&#8217;s a whole new world of automated features in SQL Server, based on data, that are designed to make life easier for the data professional, and it&#8217;s time to [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109,69,97],"tags":[],"class_list":["post-4866","post","type-post","status-publish","format-standard","hentry","category-azure","category-pluralsight","category-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database - Paul S. Randal<\/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.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Erin\u2019s latest Pluralsight course has been published \u2013 SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database.\u00a0It\u2019s\u00a090 minutes\u00a0long, and from the course description: There&#8217;s a whole new world of automated features in SQL Server, based on data, that are designed to make life easier for the data professional, and it&#8217;s time to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-10T18:07:07+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\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:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/\",\"name\":\"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2018-01-10T18:07:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database - Paul S. Randal","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.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database - Paul S. Randal","og_description":"Erin\u2019s latest Pluralsight course has been published \u2013 SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database.\u00a0It\u2019s\u00a090 minutes\u00a0long, and from the course description: There&#8217;s a whole new world of automated features in SQL Server, based on data, that are designed to make life easier for the data professional, and it&#8217;s time to [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/","og_site_name":"Paul S. Randal","article_published_time":"2018-01-10T18:07:07+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/","name":"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2018-01-10T18:07:07+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-automatic-tuning-in-sql-server-2017-and-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4866"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4866\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}