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
Mar
2017
Tue 3/21/2017
Speaker: Yell McGuyer
Topic: Our experience with nonclustered columnstore indexes
Mon 3/20/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Apr
2017
Tue 4/18/2017
Speaker: David Williams
Topic: SQL Server on Linux
Mon 4/17/2017
Speaker: David Williams
Topic: SQL Server on Linux
May
2017
Tue 5/16/2017
Speaker: Chris Hyde
Topic: SQL Server R Services in SQL 2016
Mon 5/15/2017
Speaker: Chris Hyde
Topic: SQL Server R Services in SQL 2016
Jun
2017
Tue 6/20/2017
Speaker: Jay Falck
Topic: BCP and Format Files
Mon 6/19/2017
Speaker: Jay Falck
Topic: BCP and Format Files
Jul
2017
Tue 7/18/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Mon 7/17/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
    • 10900 Stonelake Blvd., Suite 225
    • 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,

March

21

NORTH
Our experience with nonclustered columnstore indexes
Yell McGuyer

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

Title: Our experience with nonclustered columnstore indexes
by: Yell McGuyer

Summary: We upgraded to SQL 2016 in part to take advantage of the updateable nonclustered columnstore indexes for our web based Credit Risk product for D&B. I will show you the before and after for our product as well as some general exercises using columnstore in a BI over OLTP environment.

Speaker: Yell McGuyer, Data Architect Dun and Bradstreet:
Bio: I am a data architect, mentor and a development manager. Obsessed with architecture, optimization and internals, along with the desire to teach and mentor others. I began my tech life as a powerbuilder developer in 1996, when my company decided to evaluate database technologies. I volunteered to help, and have been in love with data ever since. I have some incredible data experiences working at Myspace, Truecar, and now Dun and Bradstreet.

Special Notes:

 

Available Attachments: