{"id":5020,"date":"2019-11-19T08:49:48","date_gmt":"2019-11-19T16:49:48","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=5020"},"modified":"2019-11-19T08:49:48","modified_gmt":"2019-11-19T16:49:48","slug":"new-pluralsight-course-sql-server-using-sentryone-plan-explorer","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/","title":{"rendered":"New Pluralsight course: SQL Server: Using SentryOne Plan Explorer"},"content":{"rendered":"<p>Jonathan&#8217;s latest Pluralsight course has been published: <em>SQL Server: Using SentryOne Plan Explorer<\/em>.\u00a0It\u2019s\u00a0almost 3\u00a0hours long, and from the course description:<\/p>\n<p style=\"text-align: justify;\"><em>Query plan analysis is both a science and an art, and the best tool for the job is SentryOne Plan Explorer. In this course, SQL Server: Using SentryOne Plan Explorer, you will learn how to make the most of the tool to make query plan analysis and performance tuning much easier and more intuitive than using SQL Server Management Studio. First, you will gain an understanding of how Plan Explorer compares to Management Studio, demonstrating how Plan Explorer solves the problems and shortcomings that Management Studio has. Next, you will discover how to use the the Plan Explorer user interface, including how the various information displays can help with performance analysis and tuning, and the various methods for getting query plans into the tool. Finally, you will explore how to use the more advanced features of the tool like index and statistics analysis, and profiling query performance using live query statistics. When you are finished with this course, you will have the skills and knowledge to start using the powerful SentryOne Plan Explorer tool to greatly improve your query plan analysis and performance tuning capabilities.<\/em><\/p>\n<p>It\u2019s\u00a0a complete update for his 2013 course, and covers the very latest release of SentryOne&#8217;s fantastic (and free!) tool.<\/p>\n<p>The modules are:<\/p>\n<ul>\n<li>Introduction<\/li>\n<li>Comparing Plan Explorer to SSMS<\/li>\n<li>Using the Plan Explorer UI<\/li>\n<li>Getting Execution Plans to Plan Explorer<\/li>\n<li>Using Index and Statistics Analysis<\/li>\n<li>Profiling Query Performance<\/li>\n<\/ul>\n<p>Check it out\u00a0<a href=\"https:\/\/www.pluralsight.com\/courses\/sqlserver-using-sentryone-plan-explorer\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<p>We now have more than 180 hours of SQLskills online training available (see all our 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>Jonathan&#8217;s latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer.\u00a0It\u2019s\u00a0almost 3\u00a0hours long, and from the course description: Query plan analysis is both a science and an art, and the best tool for the job is SentryOne Plan Explorer. In this course, SQL Server: Using SentryOne Plan Explorer, you will learn how 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":[69,73,95,97],"tags":[],"class_list":["post-5020","post","type-post","status-publish","format-standard","hentry","category-pluralsight","category-query-tuning","category-tools","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: SQL Server: Using SentryOne Plan Explorer - 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-sql-server-using-sentryone-plan-explorer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New Pluralsight course: SQL Server: Using SentryOne Plan Explorer - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Jonathan&#8217;s latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer.\u00a0It\u2019s\u00a0almost 3\u00a0hours long, and from the course description: Query plan analysis is both a science and an art, and the best tool for the job is SentryOne Plan Explorer. In this course, SQL Server: Using SentryOne Plan Explorer, you will learn how to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-19T16:49:48+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=\"2 minutes\" \/>\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-sql-server-using-sentryone-plan-explorer\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/\",\"name\":\"New Pluralsight course: SQL Server: Using SentryOne Plan Explorer - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2019-11-19T16:49:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New Pluralsight course: SQL Server: Using SentryOne Plan Explorer\"}]},{\"@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: SQL Server: Using SentryOne Plan Explorer - 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-sql-server-using-sentryone-plan-explorer\/","og_locale":"en_US","og_type":"article","og_title":"New Pluralsight course: SQL Server: Using SentryOne Plan Explorer - Paul S. Randal","og_description":"Jonathan&#8217;s latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer.\u00a0It\u2019s\u00a0almost 3\u00a0hours long, and from the course description: Query plan analysis is both a science and an art, and the best tool for the job is SentryOne Plan Explorer. In this course, SQL Server: Using SentryOne Plan Explorer, you will learn how to [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/","og_site_name":"Paul S. Randal","article_published_time":"2019-11-19T16:49:48+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/","name":"New Pluralsight course: SQL Server: Using SentryOne Plan Explorer - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2019-11-19T16:49:48+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-pluralsight-course-sql-server-using-sentryone-plan-explorer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"New Pluralsight course: SQL Server: Using SentryOne Plan Explorer"}]},{"@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\/5020","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=5020"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/5020\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=5020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=5020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=5020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}