22-25 April 2026 
Debating Two Viewpoints on Indexing - Development vs Operations
2025TL; DR
Who manages indexing: Ops or Dev? Join Deb and Andy for a lively debate exploring indexing from both sides. We'll debate perspectives on creation, maintenance, and troubleshooting, to help you bridge the gap in your organization.
Session Details
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.
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.
3 things you'll get out of this session
1. The role that owns the responsibility of "indexing" a database, will have different priorities, thus influencing "why" they may make different Indexing decisions. We wish to explore that from the viewpoints of Ops vs Dev DBAs.
2. Examine differing priorities of Ops vs Dev DBAs when it comes to Indexing.
3. Learn pros and cons of taking different approaches to various aspects of indexing, including creation, maintenance, and performance troubleshooting.
Speakers
Andy Yun's previous sessions
Can SQL Server 2019 auto-magically fix my bad T-SQL code?
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
Advanced Plan Explorer Usage for Tuning Execution Plans
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
Share Your Story: Developing Your First Presentation
Take an idea and learn how to develop your first session.
SentryOne Tools for Productivity and Performance
This quick vendor session demonstrates the spectrum of SentryOne's best-of-breed products for the Microsoft Data Platform, from Task Factory, to Plan Explorer, to DOC xPress, to the SentryOne monitoring platform, and beyond.
Uncovering Duplicate, Redundant, & Missing Indexes
Ensure your indexes are achieving their fullest potential!
Performance Pitfalls of Code Reuse
Learn how object-oriented T-SQL hurts performance.
Why Your Datatype Choices Matter
Learn how poor data type choices can cripple SQL Server.
