Export to

• Google Calendar
• iCalendar file
• hCalendar markup
  <div class="vevent h-event"> <h1 class="summary p-name">OregonSQL/Oregon Data Community - Query Optimization Statistics – The Driving Force Behind Query Performance</h1> <div class='date'><time class="dtstart dt-start" title="2019-10-09T18:00:00" datetime="2019-10-09T18:00:00">Wednesday, October 9, 2019 from 6</time>–<time class="dtend dt-end" title="2019-10-09T21:00:00" datetime="2019-10-09T21:00:00">9pm</time></div> <div class="location vcard p-location h-card"> <a class="url" href='http://calagator.org/venues/202395323'><span class='fn org p-name'>OHSU IT Group, 1515 SW 5th Ave, Suite 900, Portland OR 97201</span></a> <div class="adr p-adr h-adr"> <div class="street-address p-street-address">1515 SW 5th Ave, Suite 900</div> <span class="locality p-locality">Portland</span> , <span class="region p-region">OR</span> <span class="postal-code p-postal-code">97201</span> <div class="country-name p-country-name">USA</div> (<a href='https://maps.google.com/maps?q=1515%20SW%205th%20Ave,%20Suite%20900,%20Portland%20OR%2097201%20USA'>map</a>) </div> </div> <div class="description p-description"> <p>Query Optimization Statistics – The Driving Force Behind Query Performance</p> <p>When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important information at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.</p> <p>Vern is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the OregonSQL user group. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts.</p> <p>Michael Curry Theory Driven Data Science: Cybersecurity Improvement using SQL, R and machine learning</p> <p>Data science seeks to uncover actionable data relationships to solve pressing organizational needs e.g. improved cyber security behavior, and this talk presents three steps for doing just that. The goal is a clear picture on how to leverage those actionable data relationships, e.g. how effective was a cyber security training program? The aim of this presentation is to provide an exemplary theory driven approach to building evidence of being better prepared against a cybersecurity threat.</p> <p>Dr. Michael Curry is a Cyber security behavioral researcher utilizing data science methodologies to develop actionable data relationships to solve pressing organizational needs e.g. improved cyber security behavior. He is part of the OregonSQL Leadership and also an instructor for Oregon State University.</p> </div> <h3>Links</h3> <ul> <li><a class="url u-url" href="http://oregonsql.org">Website</a></li> </ul> </div>