{"id":4686,"date":"2017-02-06T14:38:58","date_gmt":"2017-02-06T22:38:58","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4686"},"modified":"2017-02-06T14:40:05","modified_gmt":"2017-02-06T22:40:05","slug":"presenting-at-sqlsaturday-dublin-in-june","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/","title":{"rendered":"Presenting at SQLSaturday Dublin in June"},"content":{"rendered":"<p style=\"text-align: justify;\">\u00a0<img decoding=\"async\" class=\"alignleft\" src=\"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png\" alt=\"SQLSaturday #620 - Dublin 2017\" \/><\/p>\n<p style=\"text-align: justify;\">Although we won&#8217;t be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday Dublin in June &#8211; our first SQLSaturday ever!<\/p>\n<p>&nbsp;<\/p>\n<p>My workshop details:<\/p>\n<ul>\n<li><strong>Performance Troubleshooting Using Waits and Latches<\/strong><\/li>\n<li style=\"text-align: justify;\"><em>One of the first things you should check when investigating performance issues are wait and latch statistics, as these can often point you in the right direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem &#8211; what is often called &#8216;knee-jerk performance tuning&#8217;.<\/em><br \/>\n<em>In this full-day workshop, you&#8217;ll learn how to investigate and interpret wait and latch statistics &#8211; practical techniques you can take home and start using immediately. You&#8217;ll also learn what a myriad of wait and latch types actually mean and how you can investigate lightly-documented types to gain insight into what causes them. Don&#8217;t waste time when it comes to performance troubleshooting; wait statistics are the fastest route to understanding your problems and this workshop will help you get there faster.<\/em><\/li>\n<li style=\"text-align: justify;\">Thursday, June 15th<\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/www.eventbrite.ie\/e\/performance-troubleshooting-using-waits-and-latches-tickets-31182463588\" target=\"_blank\">Eventbrite registration link<\/a><\/li>\n<\/ul>\n<p>Kimberly&#8217;s workshop details:<\/p>\n<ul>\n<li><strong>Queries Gone Wrong: Statistics, Cardinality, Solutions<\/strong><\/li>\n<li style=\"text-align: justify;\"><em>Have you ever wondered why SQL Server did what it did when processing your query? Have you wondered if it could have done better? Query estimates\/statistics are often at the key to understanding; this session will explain the what, why, and how about estimates!<\/em><br \/>\n<em>Most of the time SQL Server returns data quickly \u2013 except when it doesn\u2019t. Ultimately, what you see in the plan, just doesn\u2019t seem to make sense. Why? Where did it come up with this plan? From one side, Transact-SQL is a declarative language that details what data you need but without information about how SQL Server should get it. Join order, predicate analysis \u2013 this is what SQL Server has to decide based on your query\u2019s input? But, what should be processed first? Which table should we use to \u201cdrive\u201d the join? Usually, it\u2019s the table with the smallest number of rows that match your query\u2019s predicates. But, how do they know which has the smallest set before they process the data? Statistics!<\/em><br \/>\n<em>There are numerous reasons why query performance can suffer and in this full-day workshop, Kimberly will cover a number of critical areas and for each &#8211; show you the behaviors, execution plans, troubleshooting techniques, and most importantly, possible solutions. This full-day workshop is about solving your query performance problems. Each problem has a different way of approaching it and you\u2019ll walk away with a plethora of strategies to troubleshoot and tackle even gnarly query problems. Stop with the &#8220;sledgehammer&#8221; approaches (updating statistics, rebuilding indexes, recompiling plans, clearing cache, restarting SQL Server) and solve the problem. In this full-day workshop, you&#8217;ll learn much more finessed ways to solve query plan quality problems.<\/em><br \/>\n<em>Topics covered include understanding \/ maintaining statistics, handing VLTs \/ skewed data, distribution problems, troubleshooting common and advanced scenarios, and how to best utilize the cardinality estimation models (and trace flags) available in SQL Server versions 2008-2016.<\/em><\/li>\n<li style=\"text-align: justify;\">Friday, June 16th<\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/www.eventbrite.ie\/e\/queries-gone-wrong-statistics-cardinality-solutions-tickets-31180543846\" target=\"_blank\">Eventbrite registration link<\/a><\/li>\n<\/ul>\n<p>My Saturday session details:<\/p>\n<ul>\n<li><strong>Advanced Data Recovery Techniques<\/strong><\/li>\n<li><em>Disasters happen \u2013 plain and simple. When disaster strikes a database you&#8217;re responsible for, and backups and repair fail, how can you salvage data, and possibly your company and your job? This is where advanced data recovery techniques come in. Using undocumented tools and deep knowledge of database structures, you can manually patch up the database enough to extract critical data. This demo-heavy session will show you never-seen-before methods I&#8217;ve used extensively in the last year to salvage data for real-life clients after catastrophic corruption. You won&#8217;t believe what it&#8217;s possible to do!<\/em><\/li>\n<\/ul>\n<p>Kimberly&#8217;s Saturday session details:<\/p>\n<ul>\n<li><strong>Plan Cache Pollution: Dealing with Ad Hoc Madness<\/strong><\/li>\n<li><em>How you execute your data requests can have a profound effect on performance and plan reuse. Did you ever wonder where that estimate (in the showplan) comes from? Is it correct or, is it way off? Why? You\u2019ve probably heard that many of your problems are related to statistics. Potentially, you\u2019ve even rebuilt statistics only to find that it fixes the problem. However, what you might be seeing is a false positive. And, it doesn\u2019t always work. Come to this session to find out how you should be executing your statements for the best performance, caching, and reuse! We&#8217;ll look at ad hoc statements, dynamically constructed statements, and sp_executesql (e.g. forced statement caching) and I\u2019ll debunk the mysteries around estimates so that you can solve performance problems the RIGHT way! If you want to demystify SQL Server&#8217;s decisions used for statement execution, query plans, and plan caching \u2013 this is the place to be!<\/em><\/li>\n<\/ul>\n<p>The link to the main SQLSaturday Dublin web page is <a href=\"http:\/\/www.sqlsaturday.com\/620\/Sessions\/Details.aspx?sid=61278\" target=\"_blank\">here<\/a>.<\/p>\n<p>There are a ton of excellent speakers attending from around the world, so it&#8217;s going to be a really great weekend &#8211; we hope to see you there!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Although we won&#8217;t be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday Dublin in June &#8211; our first SQLSaturday ever! &nbsp; My workshop details: Performance Troubleshooting Using Waits and Latches One of the first things you should check when investigating performance issues [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,107,97],"tags":[],"class_list":["post-4686","post","type-post","status-publish","format-standard","hentry","category-conferences","category-sqlsaturday","category-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Presenting at SQLSaturday Dublin in June - 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\/presenting-at-sqlsaturday-dublin-in-june\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Presenting at SQLSaturday Dublin in June - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"\u00a0 Although we won&#8217;t be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday Dublin in June &#8211; our first SQLSaturday ever! &nbsp; My workshop details: Performance Troubleshooting Using Waits and Latches One of the first things you should check when investigating performance issues [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-06T22:38:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-06T22:40:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/\",\"name\":\"Presenting at SQLSaturday Dublin in June - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png\",\"datePublished\":\"2017-02-06T22:38:58+00:00\",\"dateModified\":\"2017-02-06T22:40:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#primaryimage\",\"url\":\"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png\",\"contentUrl\":\"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Presenting at SQLSaturday Dublin in June\"}]},{\"@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":"Presenting at SQLSaturday Dublin in June - 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\/presenting-at-sqlsaturday-dublin-in-june\/","og_locale":"en_US","og_type":"article","og_title":"Presenting at SQLSaturday Dublin in June - Paul S. Randal","og_description":"\u00a0 Although we won&#8217;t be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday Dublin in June &#8211; our first SQLSaturday ever! &nbsp; My workshop details: Performance Troubleshooting Using Waits and Latches One of the first things you should check when investigating performance issues [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/","og_site_name":"Paul S. Randal","article_published_time":"2017-02-06T22:38:58+00:00","article_modified_time":"2017-02-06T22:40:05+00:00","og_image":[{"url":"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png","type":"","width":"","height":""}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/","name":"Presenting at SQLSaturday Dublin in June - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#primaryimage"},"thumbnailUrl":"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png","datePublished":"2017-02-06T22:38:58+00:00","dateModified":"2017-02-06T22:40:05+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#primaryimage","url":"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png","contentUrl":"http:\/\/www.sqlsaturday.com\/images\/sqlsat620_web.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/presenting-at-sqlsaturday-dublin-in-june\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Presenting at SQLSaturday Dublin in June"}]},{"@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\/4686","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=4686"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4686\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}