San Antonio SQL Server User Group

 

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 (22 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 plus 10 in 2017. Presented TSQL Precon at Dallas SQLSaturday 2015. Instructed several TSQL classes to private businesses including Advanced TSQL class to Solarwinds Corp, Austin, TX last year. Currently performing DBA/Developer work for several clients. Specialties: SQL Server performance tuning; TSQL/DBA mentoring

PASSChapterLogo.jpg

sql_micro_sm.gif

SQL Watchmen

 

 

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