{"id":1042,"date":"2019-08-09T06:00:45","date_gmt":"2019-08-09T13:00:45","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=1042"},"modified":"2019-08-07T19:21:16","modified_gmt":"2019-08-08T02:21:16","slug":"sqlskills-at-the-pass-summit","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/","title":{"rendered":"SQLskills at the PASS Summit"},"content":{"rendered":"<p>The PASS Summit is coming up this fall in Seattle, and it will be here before you know it.\u00a0 Though I want to mention that I am thoroughly enjoying summer and really not ready for pumpkin anything!\u00a0 I\u2019m returning to Summit this year, as are Jonathan and Glenn.\u00a0 We are all looking forward to the conference and with the schedule announced this week, I wanted to include some more details about\u00a0 the full day pre-conference sessions that Jonathan and I are each presenting.\u00a0 Lucky Jonathan, we are presenting together as part of the <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/LearningPathways.aspx#SQLPerformanceDevelopers\">Developer Learning Pathway<\/a> along with fellow Clevelander <a href=\"https:\/\/bertwagner.com\/\">Bert Wagner<\/a> (one of my favorite peeps, ask him about coffee!).<\/p>\n<p>I\u2019ve included links to all of our sessions below, and since Jonathan and I are teaching on consecutive days, you can attend both our workshops &#x1f60a;<\/p>\n<p>My pre-conference session will dive deep into how to leverage Query Store to detect and correct performance issues, both with existing SQL Server 2016 and newer environments, and Jonathan\u2019s session will teach you how to properly use the new features in SQL Server 2017 and SQL Server 2019 to get better performance.\u00a0 If you\u2019re planning an upgrade OR moving to Azure, <em>both of these workshops are applicable<\/em>.\u00a0 We think these sessions complement each other very well, and even though we aren\u2019t presenting together, we will reference content\/concepts discussed in the other session.\u00a0 Do you have to attend both to make sense of it all?\u00a0 Definitely not.\u00a0 But we do have a ton of great information to cover and are already working on new demos to showcase the latest and greatest in SQL Server.<\/p>\n<p>If you have questions, please email us!\u00a0 You can email me or Jonathan directly to ask about our pre-conference sessions if you don\u2019t have a clear picture after reading the abstract.\u00a0 We know that there are a lot of great workshops at Summit, and we definitely want to make sure you learn what will help you most.\u00a0 Glenn, Jonathan and I look forward to seeing you in November!<\/p>\n<p>Erin&#8217;s workshop on Monday, November 4, 2019: <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/SessionDetails.aspx?sid=92854\">Performance Tuning with Query Store in SQL Server<\/a><\/p>\n<p>Jonathan&#8217;s workshop on Tuesday, November 5, 2019: <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/SessionDetails.aspx?sid=92852\">Bigger Hardware or Better Code and Design?<\/a><\/p>\n<p>Erin&#8217;s general session on Wednesday, November 6, 2019 at 3:15PM: <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/SessionDetails.aspx?sid=94074\">Understanding Execution Plans<\/a><\/p>\n<p>Glenn&#8217;s half-day session on Wednesday, November 6, 2019 at 3:15PM: <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/SessionDetails.aspx?sid=92675\">Dr. DMV&#8217;s Troubleshooting Toolkit<\/a><\/p>\n<p>Jonathan&#8217;s general session on Thursday, November 7, 2019 at 10:45 AM: <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/SessionDetails.aspx?sid=94003\">Eliminating Anti-Patterns and RBAR for Faster Performance<\/a><\/p>\n<p>Glenn&#8217;s general session on Friday, November 8, 2019 at 9:30AM: <a href=\"https:\/\/www.pass.org\/summit\/2019\/Learn\/SessionDetails.aspx?sid=92693\">Hardware 301: Choosing Database Hardware for SQL Server 2019<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The PASS Summit is coming up this fall in Seattle, and it will be here before you know it.\u00a0 Though I want to mention that I am thoroughly enjoying summer and really not ready for pumpkin anything!\u00a0 I\u2019m returning to Summit this year, as are Jonathan and Glenn.\u00a0 We are all looking forward to the [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLskills at the PASS Summit - Erin Stellato<\/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\/erin\/sqlskills-at-the-pass-summit\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLskills at the PASS Summit - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"The PASS Summit is coming up this fall in Seattle, and it will be here before you know it.\u00a0 Though I want to mention that I am thoroughly enjoying summer and really not ready for pumpkin anything!\u00a0 I\u2019m returning to Summit this year, as are Jonathan and Glenn.\u00a0 We are all looking forward to the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-09T13:00:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-08T02:21:16+00:00\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\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\/erin\/sqlskills-at-the-pass-summit\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/\",\"name\":\"SQLskills at the PASS Summit - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2019-08-09T13:00:45+00:00\",\"dateModified\":\"2019-08-08T02:21:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLskills at the PASS Summit\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLskills at the PASS Summit - Erin Stellato","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\/erin\/sqlskills-at-the-pass-summit\/","og_locale":"en_US","og_type":"article","og_title":"SQLskills at the PASS Summit - Erin Stellato","og_description":"The PASS Summit is coming up this fall in Seattle, and it will be here before you know it.\u00a0 Though I want to mention that I am thoroughly enjoying summer and really not ready for pumpkin anything!\u00a0 I\u2019m returning to Summit this year, as are Jonathan and Glenn.\u00a0 We are all looking forward to the [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/","og_site_name":"Erin Stellato","article_published_time":"2019-08-09T13:00:45+00:00","article_modified_time":"2019-08-08T02:21:16+00:00","author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/","name":"SQLskills at the PASS Summit - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2019-08-09T13:00:45+00:00","dateModified":"2019-08-08T02:21:16+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/sqlskills-at-the-pass-summit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"SQLskills at the PASS Summit"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/1042"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=1042"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/1042\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=1042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=1042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=1042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}