Andy Yun
Field Solutions Architect
Andy Yun is a Field Solutions Architect at Pure Storage, and has been a SQL Server data professional for almost 25 years. He focuses on performance tuning, with expertise in T-SQL, storage engine internals, and monitoring. Andy strongly believes in passing knowledge onto others, regularly speaking at conferences and user groups, and mentoring industry colleagues. Andy is a former Microsoft MVP, co-founder of the Chicago SQL Association, former co-leader of the Chicago Suburban User Group and Chicago SQL Saturday Organizing Committee.
Exploring Whether Storage is the Root Cause of Your Performance Woes
How many times have you had SQL Server performance issues and believed the source was your storage subsystem? Most of us have seen "I/O requests taking longer than 15 seconds to complete…" Sometimes storage is indeed the issue. But other times, your SAN admin may say "nothing's wrong with the storage." Now what?
Join me where I'll help unravel the many layers of the SQL Server infrastructure stack. We'll explore common bottlenecks, from actual storage issues, to network connectivity in between, and virtualization nuances.
You'll leave with enough knowledge to know where to turn next and start asking the right questions.
How Intelligent Query Processing improves T-SQL performance
Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019. This collection of new features is a game changer that will improve performance across the board. Come to this overview session to learn more about how these capabilities will benefit you.
Don't Fear Parallelism!
Ever heard or been told that we cannot allow queries to go parallel? It took down our entire server! Never again!
This lightning talk will help to demystify parallelism, so you understand why some may have been burned. And you'll come away with more knowledge to understand why and to better adjust parallelism, so you can still take advantage of it effectively.
Why Your Data Type Choices Matter
Did you know that poor data type choices can be a real performance killer? Would you be surprised to learn that data type decisions can have a significant impact on your database design and performance?
Attend this session to learn how database records are stored within SQL Server and why all data types are not created equal. Armed with that knowledge, we will explore several performance scenarios that may be impacting your systems right now! When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Uncovering Duplicate, Redundant, & Missing Indexes
Do you know if your database's indexes are really being used to their fullest potential? And do you know if SQL Server needs other indexes to improve performance?
Attend this session and learn how SQL Server tracks actual index usage, and how you can make use of that information to improve the state of indexes in your database. We will use this data to identify wasteful, unused, & redundant indexes, and explore performance penalties you pay for not addressing these inefficient indexes. Finally, we will dive into the Missing Index DMV and explore the art of evaluating its recommendations to make proper indexing decisions.
T-SQL Tips & Tricks to Make Your Life Easier!
Do you spend your days writing T-SQL? Want to improve your T-SQL performance? If you answered yes, then this session is for you.
This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.
This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!
Missing Indexes: Do's and Don'ts
We've all written queries that have generated Missing Index Recommendations. Perhaps you've just implemented the recommendation and moved on with your day. Or maybe you've been told to not trust these recommendations at all. Should you use them or not? How do you navigate between these conflicting viewpoints?
Join me to learn how to properly interpret these recommendations. We'll explore the pros and cons of SQL Server's Missing Index Recommendations. And while these recommendations are generated for individual queries, you'll learn how to leverage their insights wisely to benefit your entire on-prem and/or Azure SQL workload.
Your queries will thank you!
Advanced Plan Explorer Usage for Tuning Execution Plans
In 2010, SentryOne gave the community a completely free execution plan analysis tool: Plan Explorer, that is widely used today. But many users only utilize basic features and only scratch the surface of its capabilities.
Join me to learn how you can go beyond the basics. This demo-heavy (and marketing free) session will teach you advanced use of Plan Explorer by exploring practical T-SQL anti-patterns.
Everybody Has a Story to Tell: Developing Your First Presentation
Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?
Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips & tricks that I have learned along the way.
You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Lets Dive Into SQL Server I/O To Improve T-SQL Performance
Do you understand how SQL Server handles I/O? If not, you should. Understanding I/O is more important than ever with increasing cloud adoption, due to cloud costing models. But even on-premises, I/O has a direct impact on T-SQL performance.
Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.
When you leave, you'll be able to optimize your T-SQL, reduce I/O and improve performance across the board.