{"id":1728,"date":"2019-10-04T14:44:28","date_gmt":"2019-10-04T21:44:28","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1728"},"modified":"2019-10-04T14:44:54","modified_gmt":"2019-10-04T21:44:54","slug":"speaking-at-sqlsaturday-denver-on-october-12-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/","title":{"rendered":"Speaking at SQLSaturday Denver on October 12, 2019"},"content":{"rendered":"<p><font size=\"2\">I\u2019ll be presenting <a href=\"https:\/\/www.sqlsaturday.com\/908\/Sessions\/Details.aspx?sid=96059\" target=\"_blank\" rel=\"noopener noreferrer\">Dr. DMV&#8217;s Troubleshooting Toolkit<\/a> at <a href=\"https:\/\/www.sqlsaturday.com\/908\/EventHome.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">SQLSaturday Denver<\/a> on October 12, 2019. This free event will be held at <a href=\"https:\/\/www.bing.com\/maps?q=University+of+Denver+-+Sturm+Hall%2c+2040+S+Race+St%2c+Denver%2c+Colorado%2c+80210&amp;FORM=HDRSC4\" target=\"_blank\" rel=\"noopener noreferrer\">University of Denver &#8211; Sturm Hall, 2040 S Race St, Denver, Colorado, 80210<\/a>. My session is at 10:15AM.<\/font><\/p>\n<p><font size=\"2\"><font size=\"2\">I always enjoy presenting at SQLSaturday events, and meeting new people, many of which have never been to a SQLSaturday event before.<\/font><\/font><\/p>\n<p><font size=\"2\">Here is the abstract of the session:<\/font><\/p>\n<p><font size=\"2\"><strong>Dr. DMV\u2019s Troubleshooting Toolkit<\/strong><\/font><\/p>\n<p><font size=\"2\">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<p><font size=\"2\">In plain terms, I\u2019ll be going through my SQL Server 2019 Diagnostic Information Queries, explaining what they mean, and how to interpret the results. This is always a lot of fun, and people seem to enjoy it. I hope I see you there!<\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"244\" height=\"244\" title=\"Fix It\" style=\"display: inline; background-image: none;\" alt=\"Fix It\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg\" border=\"0\"><\/a><\/font><\/p>\n<p><p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019ll be presenting Dr. DMV&#8217;s Troubleshooting Toolkit at SQLSaturday Denver on October 12, 2019. This free event will be held at University of Denver &#8211; Sturm Hall, 2040 S Race St, Denver, Colorado, 80210. My session is at 10:15AM. I always enjoy presenting at SQLSaturday events, and meeting new people, many of which have never [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,33,36],"tags":[455,456],"class_list":["post-1728","post","type-post","status-publish","format-standard","hentry","category-speaking","category-sqlsaturday","category-teaching","tag-sqlsaturday-908","tag-sqlsaturday-denver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Speaking at SQLSaturday Denver on October 12, 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\/speaking-at-sqlsaturday-denver-on-october-12-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Speaking at SQLSaturday Denver on October 12, 2019 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"I\u2019ll be presenting Dr. DMV&#8217;s Troubleshooting Toolkit at SQLSaturday Denver on October 12, 2019. This free event will be held at University of Denver &#8211; Sturm Hall, 2040 S Race St, Denver, Colorado, 80210. My session is at 10:15AM. I always enjoy presenting at SQLSaturday events, and meeting new people, many of which have never [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-04T21:44:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-04T21:44:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg\" \/>\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=\"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\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/\",\"name\":\"Speaking at SQLSaturday Denver on October 12, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg\",\"datePublished\":\"2019-10-04T21:44:28+00:00\",\"dateModified\":\"2019-10-04T21:44:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg\",\"width\":244,\"height\":244},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Speaking at SQLSaturday Denver on October 12, 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":"Speaking at SQLSaturday Denver on October 12, 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\/speaking-at-sqlsaturday-denver-on-october-12-2019\/","og_locale":"en_US","og_type":"article","og_title":"Speaking at SQLSaturday Denver on October 12, 2019 - Glenn Berry","og_description":"I\u2019ll be presenting Dr. DMV&#8217;s Troubleshooting Toolkit at SQLSaturday Denver on October 12, 2019. This free event will be held at University of Denver &#8211; Sturm Hall, 2040 S Race St, Denver, Colorado, 80210. My session is at 10:15AM. I always enjoy presenting at SQLSaturday events, and meeting new people, many of which have never [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-10-04T21:44:28+00:00","article_modified_time":"2019-10-04T21:44:54+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/","name":"Speaking at SQLSaturday Denver on October 12, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg","datePublished":"2019-10-04T21:44:28+00:00","dateModified":"2019-10-04T21:44:54+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/10\/fix-it_thumb.jpg","width":244,"height":244},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/speaking-at-sqlsaturday-denver-on-october-12-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Speaking at SQLSaturday Denver on October 12, 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\/1728","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=1728"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1728\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}