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
Oct
2017
Tue 10/17/2017
Speaker: Cory Brown
Topic: Managing Many SQL Servers with Management Framework
Mon 10/16/2017
Speaker: Mike Byrd
Topic: Climbing the SQL Server Index B-Tree, from the user's perspective
Nov
2017
Tue 11/21/2017
Speaker: Jay Falck
Topic: Linux for SQL Server Professionals (Ubuntu specific)
Mon 11/20/2017
Speaker: Jay Falck
Topic: Linux for SQL Server Professionals (Ubuntu specific)
Dec
2017
Tue 12/19/2017
Speaker: Mike Byrd
Topic: Climbing the SQL Server Index B-Tree, from the user's perspective
Mon 12/18/2017
Speaker: Ryan Casey
Topic: Data Modeling for the Modern Enterprise

 


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

17

NORTH
Understanding Locking with Distributed Systems
John Sterrett

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

Title: Understanding Locking with Distributed Systems
by: John Sterrett

Summary: By default with SQL Server, locking occurs when one or more queries are waiting on another query to finish. Depending on your workload, that might not be the ideal locking method for your application, or a subset of your queries. In this session, you are going to learn the basics of all the isolation modes inside of SQL Server and the pros and cons of each one so you know how to use them effectively. We will review table hints and how they impact application concurrency. Finally, we will cover how to identify and prevent deadlocks in your system.

Speaker: John Sterrett, Principal Consultant Procure SQL LLC:
Bio: John Sterrett is a Microsoft Data Platform MVP, MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and founder of the HADR Virtual Chapter.

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