Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO.  Currently senior database engineer consultant for several Austin companies.  Also SQLServerCentral.com contributor for several articles.  

Presenter at 17 SQL Sat sessions in 2016, 10 in 2017, 8 in 2018 ( including Cambridge) and Chicago, Jacksonville, Dallas, Pensacola, Austin, Orlando, and Baton Rouge in 2019; as well as several local SQL Server user's groups in Ft. Worth, Austin, and San Antonio; and 2 PASS Virtual DBA presentations in 2019. 

Loves performance tuning and teaching T-SQL and performance tuning  
Mike Byrd has submitted 3 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

A beginner's guide to indexing from a user perspective. What to consider when defining an index and what not to consider. Many demos including clustered, non-clustered, covering indexes, and primary keys.
This session will give you the background knowledge on how SQL Server stores and uses various indexes. The attendee will gain valuable insight into index composition and increased index performance. 75% demos.
Everyone thinks they know all about Foreign Keys, but this session yields the rest of the story. FKs are needed for data integrity, but they can have a significant impact on performance. Come learn the pros and cons!

Sessions

Mike_Byrd111004.jpg