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
Aug
2017
Tue 8/15/2017
Speaker: Martin Perez
Topic: What Changed? Using T-SQL to Find Changes in Tables
Mon 8/21/2017
Speaker: Martin Perez
Topic: What Changed? Using T-SQL to Find Changes in Tables
Sep
2017
Tue 9/19/2017
Speaker: Jen and Sean McCown
Topic: TBA
Mon 9/18/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Oct
2017
Tue 10/17/2017
Speaker: Cory Brown
Topic: TBA
Mon 10/16/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Nov
2017
Tue 11/21/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Mon 11/20/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Dec
2017
Tue 12/19/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Mon 12/18/2017
Speaker: OPEN
Topic: Submit your own presentation to give

 


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

Monday,

August

21

Austin SOUTH
- What Changed? Using T-SQL to Find Differences Between Tables -
Martin Perez

1524 S IH-35 Frontage Rd Suite 209
Austin, Texas 78704
Time: 17:30 - 19:00

Title: What Changed? Using T-SQL to Find Differences Between Tables
by: Martin Perez

Summary: Do you need to compare the data between tables to find what is missing? Or do you need to watch for when data changes in a table? There are many methods and tools to use. Here, we'll cover a range of t-sql code and database settings, from basic to complex, to find these differences and changes:

  • - Brute force - write it all out
  • - Not Exists
  • - Left Inner Join
  • - Intersect
  • - Except
  • - Merge
  • - Row Version
  • - Change Tracking
  • - Change Data Capture

Speaker: Martin Perez:
Bio: None

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