Andy Yun
Field Solutions Architect
Actions
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.
Awards
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.
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.
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.
SQL Saturday Albany 2024 Sessionize Event
Data Céilí 2024 Sessionize Event
SQL Saturday Atlanta 2024 Sessionize Event
Boston Code Camp 36 Sessionize Event
DataTune 2024 Sessionize Event
New Stars of Data Speaker Improvement Library Sessionize Event
SQL Saturday Boston 2023 Sessionize Event
SQL Saturday New York City 2023 Sessionize Event
SQL Saturday Oregon/SW Washington Sessionize Event
New England SQL Server User Group User group Sessionize Event
PASS Data Community Summit 2021 Sessionize Event
Dativerse #1 Sessionize Event
DataMinutes #1 Sessionize Event
#DataWeekender v3.1 Sessionize Event
#DataWeekender #TheSQL Sessionize Event
DataGrillen 2020 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top