Welcome to SALSSA 

San Antonio League of SQL Server Administrators

Our regular monthly meetings occur on the 3rd Wednesday of each month from 6pm - 8pm. Pizza and drinks are provided at the beginning of the meeting. We meet at New Horizons Computer Learning Center located at

New Horizons Computer Learning Center

2727 NW Loop 410
San Antonio, TX 78230

For any questions please email salssa@sqlpass.org 


Next Meeting

Wednesday,

January

23

Mike Byrd: A Primer on SQL Server Clustered Index Architecture

  • In-Person @ 2727 Northwest Loop 410 #103 San Antonio, Texas, United States (map)
  • 18:00 - 20:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

SALSSA Monthly Chapter Meeting

 

Featured Presentation:

A Primer on SQL Server Clustered Index Architecture

Mike Byrd, Senior Database Engineer ByrdNest Consulting

How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties. Seems like that is all I have done for last many years. But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios. In some scenarios a well-defined clustered index may out perform a covering non-clustered index. Results are very interesting and may surprise you.

About Mike:
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. 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.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids