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

17

Mike Byrd: Climbing the SQL Server Index B-Tree (from a user perspective)

  • 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

January Meeting:

Featured Presentation:

Mike Byrd: Climbing the SQL Server Index B-Tree (from a user perspective)

Mike Byrd, Senior Database Engineer ByrdNest Consulting

Climbing the SQL Server Index B-Tree (from a user perspective) Mike Byrd, Senior Database Engineer ByrdNest Consulting 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. Session is 80% demos. This is an intermediate level presentation. About me: Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for Texas Windstorm Insurance Association (9 years), Currently senior database consultant for several companies. Ideal job is sproc and query performance tuning or TSQL instruction 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 • Pizza and soft drinks provided • RSVP is not necessary, please come if you can

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

Supplementary Materials

The following event attachments are available to you:

PASSChapterLogo.jpg

sql_micro_sm.gif

SQL Watchmen

 

 

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