{"id":1685,"date":"2019-08-28T08:09:50","date_gmt":"2019-08-28T15:09:50","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1685"},"modified":"2019-08-28T08:24:20","modified_gmt":"2019-08-28T15:24:20","slug":"sqlskills-at-24-hours-of-pass-summit-preview-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/","title":{"rendered":"SQLskills at 24 Hours of PASS: Summit Preview 2019"},"content":{"rendered":"

On September 10, 2019, SQLskills will have three slots in the free 24 Hours of PASS: Summit Preview 2019 event<\/a>. I\u2019ll be leading off with \u201cDr. DMV\u2019s Troubleshooting Toolkit<\/a>\u201d at 12:00 UTC. Erin Stellato<\/a> will present \u201cWhy You Need Query Store<\/a>\u201d at 16:00 UTC, and Jonathan Kehayias<\/a> will present \u201cBigger Hardware or Better Code and Design?<\/a>\u201d at 19:00 UTC. You can use this link to register<\/a> for any or all of the sessions in the entire event.<\/font><\/p>\n

Here are the abstracts for the three sessions:<\/font><\/p>\n

\n

Dr. DMV’s Troubleshooting Toolkit<\/strong><\/font><\/p>\n

Dynamic Management views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates, and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases. This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.<\/font><\/p>\n

Why You Need Query Store<\/strong><\/font><\/p>\n

Have you upgraded to SQL Server 2016 or higher, but still have databases using the old Cardinality Estimator? Do you know that you have queries with inconsistent performance, but you’re just not sure how to find them, or fix them, quickly? Are you tired of flailing around in SQL Server, querying DMV after DMV to figure out the *real* problem with performance? Query Store can help. We\u2019ll cover Query Store end-to-end in this full day workshop built using real-world examples based on customer issues resolved over the last 2+ years. You’ll understand how to configure it, what data it captures, and how to use it to analyze performance, find regressions, and force plans. The demos will teach you how to find common patterns in query performance using T-SQL, and how to understand your workload. This class is applicable for those running SQL Server 2016 or higher (or planning to upgrade), or Azure SQL Database, and will provide practical and applicable information you can use whether you’re a new or veteran DBA, a developer that has to troubleshoot query performance, or an application administrator just trying to keep the system afloat. You’ll learn how to find and leverage important information in Query Store to make solving common performance problems easier the moment you walk back into the office. <\/font><\/p>\n

Bigger Hardware or Better Code and Design?<\/strong><\/font><\/p>\n

Whether you are running SQL Server in the cloud or on-premise, more hardware often becomes the first answer to performance problems. The cost of scaling up in effort is relatively low, especially in the cloud where changing resource sizes is only a drop down option away, but financially this can quickly become a deal breaker. Even the fastest hardware won\u2019t keep up with bad design and coding patterns. This session will take a look at many of the new features of SQL Server and how they can best be leveraged for performance tuning your workload. From In-Memory OLTP to Columnstore Indexes, Query Store, and Extended Events, this session will guide you in finding the source of the problems, and solutions available to make your workload faster and consistently reliable. We\u2019ll even take a look at different alternatives using older features of SQL Server that you may be leaving on the shelf that are a better fit to solving certain kinds of problems.<\/font><\/p>\n<\/blockquote>\n

Erin Stellato recently wrote about the SQLskills presence at PASS Summit 2019<\/a>, where both Erin and Jon have full day pre-conference workshops, and I have a half-day session during the conference. I hope to see you both at 24 Hours of PASS and at the PASS Summit 2019!<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

On September 10, 2019, SQLskills will have three slots in the free 24 Hours of PASS: Summit Preview 2019 event. I\u2019ll be leading off with \u201cDr. DMV\u2019s Troubleshooting Toolkit\u201d at 12:00 UTC. Erin Stellato will present \u201cWhy You Need Query Store\u201d at 16:00 UTC, and Jonathan Kehayias will present \u201cBigger Hardware or Better Code and […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,27],"tags":[182],"class_list":["post-1685","post","type-post","status-publish","format-standard","hentry","category-sql-server-pass","category-speaking","tag-24-hours-of-pass"],"yoast_head":"\nSQLskills at 24 Hours of PASS: Summit Preview 2019 - Glenn Berry<\/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\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLskills at 24 Hours of PASS: Summit Preview 2019 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"On September 10, 2019, SQLskills will have three slots in the free 24 Hours of PASS: Summit Preview 2019 event. I\u2019ll be leading off with \u201cDr. DMV\u2019s Troubleshooting Toolkit\u201d at 12:00 UTC. Erin Stellato will present \u201cWhy You Need Query Store\u201d at 16:00 UTC, and Jonathan Kehayias will present \u201cBigger Hardware or Better Code and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-28T15:09:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-28T15:24:20+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\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\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/\",\"name\":\"SQLskills at 24 Hours of PASS: Summit Preview 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2019-08-28T15:09:50+00:00\",\"dateModified\":\"2019-08-28T15:24:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLskills at 24 Hours of PASS: Summit Preview 2019\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLskills at 24 Hours of PASS: Summit Preview 2019 - Glenn Berry","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\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/","og_locale":"en_US","og_type":"article","og_title":"SQLskills at 24 Hours of PASS: Summit Preview 2019 - Glenn Berry","og_description":"On September 10, 2019, SQLskills will have three slots in the free 24 Hours of PASS: Summit Preview 2019 event. I\u2019ll be leading off with \u201cDr. DMV\u2019s Troubleshooting Toolkit\u201d at 12:00 UTC. Erin Stellato will present \u201cWhy You Need Query Store\u201d at 16:00 UTC, and Jonathan Kehayias will present \u201cBigger Hardware or Better Code and […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-08-28T15:09:50+00:00","article_modified_time":"2019-08-28T15:24:20+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/","name":"SQLskills at 24 Hours of PASS: Summit Preview 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2019-08-28T15:09:50+00:00","dateModified":"2019-08-28T15:24:20+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sqlskills-at-24-hours-of-pass-summit-preview-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"SQLskills at 24 Hours of PASS: Summit Preview 2019"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1685"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1685\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}