Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us: Email: CACTUSS.SQL (at) (gmail) (dot) (com)

Upcoming Meeting Dates

Aug 2019 Tue 8/20/2019
Speaker: Mike Byrd
Topic: A Self-Tuning Fill Factor Technique for SQL Server
Sep 2019 Tue 9/17/2019
Speaker: Jay Falck
Topic: Setting up a test lab with Hyper-V
Oct 2019 Tue 10//21/2019
Speaker: Open
Topic: Submit Your Topic
Nov 2019 Tue 11/19/2019
Speaker: Open
Topic: Submit Your Topic


Meeting Location


  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to 7:15 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:

Next Meeting




NORTH<br />Our experience with nonclustered columnstore indexes<br />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:

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

This month's sponsor:

(Feature coming soon)

Ongoing sponsors:


SQL Watchmen  

Back to Top