{"id":866,"date":"2017-09-28T06:00:30","date_gmt":"2017-09-28T13:00:30","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=866"},"modified":"2017-09-27T14:13:04","modified_gmt":"2017-09-27T21:13:04","slug":"query-store-pre-con-at-pass-summit-more-details","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/","title":{"rendered":"Query Store Pre-Con at PASS Summit: More Details"},"content":{"rendered":"

In the time since my last post<\/a> about my Query Store pre-con<\/a> at the PASS Summit (it\u2019s just about a month away!) I\u2019ve gotten several more questions about the session.\u00a0 I\u2019ve consolidated them and provided answers here, and if anyone still wants to know more, please email me!<\/p>\n

What version of SQL Server will you be running?<\/strong><\/p>\n

With the announcement on Monday from Ignite about SQL Server 2017<\/a>, I can now say for certain that is the release I will be using.\u00a0 I will call out differences between SQL Server 2016 and SQL Server 2017 as needed.\u00a0 I don\u2019t expect everyone who\u2019s attending to be running 2016 or 2017, but I do expect that you\u2019re in the planning stages for an upgrade, are going to start planning soon, or you\u2019re looking for some solid reasons to share with your company about why you should upgrade.\u00a0 I would argue that Query Store is a very good reason to upgrade, but that is definitely not the only one (check out the new features list for SQL Server 2016<\/a> and SQL Server 2017<\/a> – including enhancements to Query Store<\/a>).<\/p>\n

Will you have labs during your session?<\/strong><\/p>\n

No, but I will make all scripts available for attendees, and if you want to follow along during the day, you can get the scripts that morning.\u00a0 I tweak demos right up until a session \u2013 it\u2019s what I expect to be doing the Sunday before.\u00a0 I\u2019ll have all the scripts on a share that attendees can access the morning of the 30th.\u00a0 I *love<\/strong>* the idea of labs during a pre-con, and I know that some other presenters do them.\u00a0 Huge props, as it\u2019s not easy to do.\u00a0 In order to cover everything I want to cover, I don\u2019t have enough time for in-depth labs that everyone can walk through from start to finish in the time allotted.\u00a0 But again, feel bring to a laptop with SQL Server 2017 installed, along with the latest SSMS, and you can follow right along.<\/p>\n

Are you giving anything away?<\/strong><\/p>\n

Besides knowledge?\u00a0 😊\u00a0 Yes, I will have codes for 30 days of free access to Pluralsight<\/a>, which gives you access to over 50 courses from the SQLskills team<\/a>, including my 3-hour course on Query Store.\u00a0 If there\u2019s something you miss during the pre-con, you can watch the Pluralsight course to pick it up, or further enhance what you learned.\u00a0 I\u2019m also working on a new course about the enhancements to Query Store in SQL Server 2017 and Automatic Tuning, which I\u2019m also covering in my full day session.<\/p>\n

Additional thoughts\u2026<\/strong><\/p>\n

I\u2019m also hosting a panel session<\/a> at Summit and the organizer has emailed me to discuss how we handle questions during the session.\u00a0 In the case where there are a large number of attendees, sometimes people hesitate to ask questions, and sometimes it can slow down the flow of the session.\u00a0 While I am not setting records in terms of attendance, there are a lot of people that have signed up (which is fantastic) and I do want to make sure that everyone has a chance to ask their questions.\u00a0 I\u2019ve thought about using Twitter, and I know that Slack has been suggested as an option.\u00a0 I\u2019m still thinking about it.\u00a0 If you\u2019re signed up and have a preference, feel free to let me know in the comments!<\/p>\n

That\u2019s it for the moment, but please keep those questions coming.\u00a0 Again, I want to make sure this is the right session for you to attend \u2013 there are a lot of great choices this year!\u00a0 Either way, I look forward to seeing at Summit next month!<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

In the time since my last post about my Query Store pre-con at the PASS Summit (it\u2019s just about a month away!) I\u2019ve gotten several more questions about the session.\u00a0 I\u2019ve consolidated them and provided answers here, and if anyone still wants to know more, please email me! What version of SQL Server will you […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,46],"tags":[],"yoast_head":"\nQuery Store Pre-Con at PASS Summit: More Details - Erin Stellato<\/title>\n<meta name=\"description\" content=\"Interested in Query Store but not sure if my pre-con is right for you? Then read on!\" \/>\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\/query-store-pre-con-at-pass-summit-more-details\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query Store Pre-Con at PASS Summit: More Details - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Interested in Query Store but not sure if my pre-con is right for you? Then read on!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-28T13:00:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-09-27T21:13:04+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=\"3 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\/query-store-pre-con-at-pass-summit-more-details\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/\",\"name\":\"Query Store Pre-Con at PASS Summit: More Details - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2017-09-28T13:00:30+00:00\",\"dateModified\":\"2017-09-27T21:13:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"Interested in Query Store but not sure if my pre-con is right for you? Then read on!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Query Store Pre-Con at PASS Summit: More Details\"}]},{\"@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":"Query Store Pre-Con at PASS Summit: More Details - Erin Stellato","description":"Interested in Query Store but not sure if my pre-con is right for you? Then read on!","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\/query-store-pre-con-at-pass-summit-more-details\/","og_locale":"en_US","og_type":"article","og_title":"Query Store Pre-Con at PASS Summit: More Details - Erin Stellato","og_description":"Interested in Query Store but not sure if my pre-con is right for you? Then read on!","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/","og_site_name":"Erin Stellato","article_published_time":"2017-09-28T13:00:30+00:00","article_modified_time":"2017-09-27T21:13:04+00:00","author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/","name":"Query Store Pre-Con at PASS Summit: More Details - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2017-09-28T13:00:30+00:00","dateModified":"2017-09-27T21:13:04+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"Interested in Query Store but not sure if my pre-con is right for you? Then read on!","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/query-store-pre-con-at-pass-summit-more-details\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"Query Store Pre-Con at PASS Summit: More Details"}]},{"@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\/866"}],"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=866"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/866\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}