Where in the world is Quacky?

06.20.2018 @ 11:00 AM CT - 12:00 PM CT

Every new release of SQL Server brings a load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 and 2017 are perfect examples of releases with many new and beneficial features.

Join IDERA and Pinal Dave as he covers the new features in SQL Server 2016 / 2017. Pinal will walk through adaptive query plans, batch mode adaptive join, new cardinality estimate for optimal performance, adaptive query processing, and more. This is an interactive Geek Sync you will not want to miss!

About Pinal: Pinal Dave is a technology enthusiast and independent consultant with over thirteen years of experience in the information technology sector. He has successfully authored 11 SQL Server database books, 18 Pluralsight courses and written over 3200 articles on database technology via his blog http://blog.sqlauthority.com. Rounding out his professional career, Pinal has held key positions as Sr. Consultant for SolidQ and as a Technology Evangelist for Pluralist and Microsoft. Pinal holds a Master of Science from the University of Southern California, and numerous professional certifications, including MCTS, MCDBA and MCAD (.NET).

06.27.2018 @ 11:00 AM CT - 12:00 PM CT

When we design indexes, we often think about speeding up a specific query. But index tuning is important for larger reasons, too: well tuned indexes reduce the memory footprint of your workload, allowing greater concurrency and scalability for your application.

Join IDERA and Microsoft Certified Master Kendra Little for this investigation into how the indexes selected by a query impact memory in multiple caches in SQL Server. You'll learn what 'Query Workspace Memory' is, what it's used for, and what goes wrong if a query doesn't get the memory grant it needs. You'll learn how this differs from the buffer pool memory used by the query, and how to measure the memory 'footprint' of a query with different indexes.

You'll leave the session with a checklist of patterns to identify while you optimize indexes and improve memory usage for your top queries.

About Kendra: Kendra Little teaches database administrators and developers how to speed up their Microsoft SQL Servers consistently. She is a Microsoft Certified Master in SQL Server, a Microsoft Most Valuable Professional (MVP), and one of the few artists in the world to draw both dinosaurs and databases.