{"id":4395,"date":"2014-09-10T19:52:01","date_gmt":"2014-09-11T02:52:01","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4395"},"modified":"2017-04-13T11:41:09","modified_gmt":"2017-04-13T18:41:09","slug":"new-sqlskills-pluralsight-courses-2","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/","title":{"rendered":"New SQLskills Pluralsight courses"},"content":{"rendered":"<p>We&#8217;ve just released two new courses on Pluralsight:<\/p>\n<p>The first new\u00a0course is the conclusion of Joe Sack&#8217;s query-tuning course:\u00a0<a href=\"http:\/\/www.pluralsight.com\/courses\/sql-server-common-query-tuning-problems-solutions-part2\" target=\"_blank\"><strong>SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 2<\/strong><\/a>.<\/p>\n<p>The second new course is Kimberly&#8217;s long-awaited <strong><a href=\"http:\/\/www.pluralsight.com\/courses\/sqlserver-optimizing-stored-procedure-performance\" target=\"_blank\">SQL Server: Optimizing Stored Procedure Performance<\/a><\/strong>. It&#8217;s more than seven hours long and the abstract is:<\/p>\n<p style=\"padding-left: 30px;\">When using stored procedures, their performance is dependent on creating the optimal plan for the execution environment and making sure that it remains cached. This comprehensive course will show you all of that and more, and is applicable to SQL Server developers and anyone responsible for ensuring performance of stored procedures, from SQL Server 2005 onward.<\/p>\n<p>The module list is:<\/p>\n<ul>\n<li>Introduction<\/li>\n<li>Why Use Stored Procedures?<\/li>\n<li>Creation, Compilation, and Invalidation Section 1<\/li>\n<li>Creation, Compilation, and Invalidation Section 2<\/li>\n<li>Optimization and Recompilation Section 1<\/li>\n<li>Optimization and Recompilation Section 2<\/li>\n<li>Optimization and Recompilation Section 3<\/li>\n<li>Optimization and Recompilation Section 4<\/li>\n<li>Other Concerns and Considerations<\/li>\n<\/ul>\n<p>Check them out!<\/p>\n<p>Also, some people have questioned the Basic\/Intermediate\/Advanced ratings and how they relate to our in-person classes. <strong>Any courses rated Intermediate on Pluralsight are the same level as our in-person content.<\/strong><\/p>\n<p>We&#8217;ve got a lot more courses in production and planned for the remainder of 2015 around DMVs, more stored procedure performance, Service Broker, Change Data Capture, fragmentation, and more. Watch this space (and the <a href=\"https:\/\/www.sqlskills.com\/join-the-sqlskills-insider-community\/\" target=\"_blank\">Insider Newsletter<\/a>) for details.<\/p>\n<p>Thanks!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We&#8217;ve just released two new courses on Pluralsight: The first new\u00a0course is the conclusion of Joe Sack&#8217;s query-tuning course:\u00a0SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 2. The second new course is Kimberly&#8217;s long-awaited SQL Server: Optimizing Stored Procedure Performance. It&#8217;s more than seven hours long and the abstract is: When using stored [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,66,69,97],"tags":[],"class_list":["post-4395","post","type-post","status-publish","format-standard","hentry","category-classes","category-performance-tuning","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 SQLskills Pluralsight courses - 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-sqlskills-pluralsight-courses-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New SQLskills Pluralsight courses - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"We&#8217;ve just released two new courses on Pluralsight: The first new\u00a0course is the conclusion of Joe Sack&#8217;s query-tuning course:\u00a0SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 2. The second new course is Kimberly&#8217;s long-awaited SQL Server: Optimizing Stored Procedure Performance. It&#8217;s more than seven hours long and the abstract is: When using stored [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-11T02:52:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T18:41:09+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-sqlskills-pluralsight-courses-2\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/\",\"name\":\"New SQLskills Pluralsight courses - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2014-09-11T02:52:01+00:00\",\"dateModified\":\"2017-04-13T18:41:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New SQLskills Pluralsight courses\"}]},{\"@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 SQLskills Pluralsight courses - 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-sqlskills-pluralsight-courses-2\/","og_locale":"en_US","og_type":"article","og_title":"New SQLskills Pluralsight courses - Paul S. Randal","og_description":"We&#8217;ve just released two new courses on Pluralsight: The first new\u00a0course is the conclusion of Joe Sack&#8217;s query-tuning course:\u00a0SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 2. The second new course is Kimberly&#8217;s long-awaited SQL Server: Optimizing Stored Procedure Performance. It&#8217;s more than seven hours long and the abstract is: When using stored [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/","og_site_name":"Paul S. Randal","article_published_time":"2014-09-11T02:52:01+00:00","article_modified_time":"2017-04-13T18:41:09+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-sqlskills-pluralsight-courses-2\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/","name":"New SQLskills Pluralsight courses - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2014-09-11T02:52:01+00:00","dateModified":"2017-04-13T18:41:09+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-sqlskills-pluralsight-courses-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"New SQLskills Pluralsight courses"}]},{"@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\/4395","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=4395"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4395\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}