CACTUSS North

CACTUSS

Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us:
Email: CACTUSS.SQL (at) (gmail) (dot) (com)
Twitter: @CACTUSS_SQL
LinkedIn: https://www.linkedin.com/groups/149440
Meetup: https://www.meetup.com/Austin-SQL-Server-User-Group/

Upcoming Meeting Dates

  North South
Jan
2018
Tue 1/16/2018
Speaker: Mike Byrd
Topic: Climbing the SQL Server Index B-Tree, from the user's perspective
Mon 1/15/2018
Speaker: Dainius Sutkevicius
Topic: Transition from Profiler to Extended Events
Feb
2018
Tue 2/20/2018
Speaker: Ryan Casey
Topic: Graphical data modeling using enterprise modeling tools
Mon 2/19/2018
Speaker: Open
Topic: Submit your topic
Mar
2018
Tue 3/20/2018
Speaker: Dainius Sutkevicius
Topic: Transition from Profiler to Extended Events
Mon 3/19/2018
Speaker: Open
Topic: Submit your topic
 Apr
2018
Tue 4/17/2018
Speaker: John Sterrett
and Argenis Fernandez

Topic: To be announced
Mon 4/16/2018
Speaker: John Sterrett
and Argenis Fernandez

Topic: To be announced
 May
2018
Tue 5/15/2018
Speaker: Open
Topic: Open
Mon 5/21/2018
Speaker: Open
Topic: Open
 Jun
2018
Tue 6/19/2018
Speaker: Open
Topic: Open
Mon 6/18/2018
Speaker: Open
Topic: Open
 Jul
2018
Tue 7/17/2018
Speaker: Open
Topic: Open
Mon 7/16/2018
Speaker: Open
Topic: Open
 Aug
2018
Tue 8/21/2018
Speaker: Open
Topic: Open
Mon 8/20/2018
Speaker: Open
Topic: Open


Meeting Locations

CACTUSS North

  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 6:00 pm with food and a QA session
  • Presentation: 6:30 pm and goes to 7:30 pm
  • Address
    • Quarry Oaks II
    • Microsoft Office
    • Suite 225
    • 10900 Stonelake Blvd.
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map: http://binged.it/1HOSMWm

CACTUSS South

  • Meeting dates: 3rd Monday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to just after 7:00 pm
  • Address
    • SQLWatchmen Office
    • Suite 209
    • 1524 S IH-35
    • Austin, TX, 78704
      • * Free parking
      • * South bound side
      • * From north of Riverside, use the Woodland exit
      • * From south of Riverside, use the Riverside exit and turn around (it's a long traffic light)
      • * Wooden bridge in the middle of the L shape is the closest entrance
  • Map: http://binged.it/2kMuQQ8
 

Next Meeting

Tuesday,

January

16

Austin NORTH
- Climbing SQL Server Index B-Tree, from user's perspective -
Mike Byrd

10900 Stonelake Blvd. Suite 225 - Microsoft Office
Austin, Texas 78759
Time: 18:00 - 19:30

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

Summary: 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.

Speaker: Mike Byrd, Senior Database Engineer ByrdNest Consulting:
Bio: 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

Special Notes:
-

Available Attachments:

Our monthly meetings are made possible by the generosity of these sponsors:

This month's sponsor:

(Feature coming soon)

Ongoing sponsors:

Microsoft

SQL Watchmen  

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