Mike Byrd
ByrdNest Consulting, Senior Database Engineer
Llano, Texas, United States
Actions
Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (32 years)! Past opportunities include being a freelance technical writer for PC Magazine, a senior software manager for a government-sponsored munitions effectiveness committee, and an insurance company CTO. Currently, I am a senior database engineer consultant for several Austin companies. Presenter at 17 SQL Sat sessions in 2016, 10 in 2017, 8 in 2018 (Cambridge), and Chicago, Jacksonville, Dallas, Pensacola, Austin, and Baton Rouge in 2019, as well as several local SQL Server user's groups in Ft. Worth, Austin, and San Antonio; and 2 Virtual DBA presentations in 2018. Will be a presenter at PASS 2024.
Area of Expertise
Topics
A Self-Tuning Fill Factor Technique for SQL Server
This session explores a early AI technique for assigning fill factor values to almost all indexes in a database. It is based on a brute force technique I used back in exploring performance characteristics for a rocket motor with specified performance parametrics. Applying this technique to a fairly active OLAP database has shown about a 30% improvement in performance (and reduced some of those 2 am calls). All scripts are provided through GitHub.
Climbing The SQL Server Index B-Tree
This session dives down and looks at the important items on data pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command. It will also look at the effect of row data compression on indexes. In all demos, we will try to ascertain how the SQL Server optimizer might use them and also strive to gain some insight from a performance advantage. Its purpose is mainly to try and understand how SQL Server implements indexes, their underlying structure, and where performance benefits might lie from a layman’s viewpoint. The session is 80% demos. This is an intermediate-level presentation.
Really a detailed dive into how SQL Server stores and uses index data.
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