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.
Badges
Unlock the Power of Analogies to Simplify Complex Topics
As data professionals, we often face the challenge of explaining complex data concepts to audiences who do not share our expertise. Analogies are a powerful tool to bridge that gap, transforming intricate ideas into relatable, digestible tidbits. If you’ve joined me before, you know how much I love using "my silly analogies" to demystify technology.
To help you, I’ll share my key techniques to crafting relatable and impactful analogies. By the end, you’ll have new tools to connect with your audience, turn complexity into clarity, and leaving a lasting impression.
SQL Server 2025 Community Edition
One of the best ways to learn a new product is through examples. Come see this fun fast-paced session as Bob Ward hosts some of the top SQL community experts to show their favorite SQL Server 2025 feature through demonstrations.
Debating Two Viewpoints on Indexing - Development vs Operations
Who is responsible for indexing your application: operations or development?
Depending on the role, organizational structure, and access to the environment in need of indexing, the answer to that question may vary. So what should we do to make sure that our databases have the proper indexing when different roles, each with different priorities, own that responsibility?
If you can relate, and most of us can, come join Deborah and Andy for a technical yet fun debate on indexing, where we will each represent the development and operations viewpoints respectively. You can expect a lively exchange, where we will discuss various aspects of indexing, from creation, maintenance, and performance troubleshooting, from each differing viewpoint.
When you leave, you'll have a better appreciation for the "whys" that drive the two different viewpoints, enabling you to bridge the gap at your organization.
A Practical Introduction to Vector Search in SQL Server 2025
Are you uncertain if SQL Server 2025 Vector Search has useful applications? Concerned that it is just more AI hype?
Then join me in this session, where I’ll break down how Vector Search works, where it fits into the AI landscape, and how you can use it today—on-prem and without changing your core architecture.
We’ll cover:
* The foundations of vector embeddings and similarity search
* How SQL Server implements Vector Search, including indexing and querying
* Code demos and practical use case exploration
You’ll leave armed with the knowledge to look beyond the hype and understand how Vector Search can work for you.
A Practical Introduction to Vector Search in SQL Server 2025
Uncertain if SQL Server 2025's new Vector Search will be useful?
Then join me & we'll explore:
• Vector embeddings & RAG architecture
• Vector Search in SQL 2025 with demos
• Practical use cases in the cloud and on-prem
You’ll leave understanding how to bring AI-powered search to your SQL databases with practical, real-world examples you can use today.
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.
SQLBits 2025 - General Sessions Sessionize Event
Data Céilí 2025 Sessionize Event
SQL Saturday New York City 2025 Sessionize Event
SQL Saturday Atlanta 2025 - AI & BI Sessionize Event
#DataWeekender 7.0 Sessionize Event
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