April Meeting: MVP Jason Massie

Posted by judith
April 19, 2010

April Meeting – Fort Worth SQL Server User Group
Wednesday, April 21st, 2010 6:30PM

Those of you who have had the privilege to hear MVP Jason Massie speak know the surprising new twists and depths he brings to a topic. Check out his blog: http://statisticsio.com/ And come check him out this Wednesday.

Running mixed workloads on SQL Server
In an ideal world, you can separate your OLTP traffic and reporting so the databases can be optimized for their respective workloads. In the real world, this is not always an option. Business requirements may require real time data which means reporting off of the OLTP environment. We will first look at the shortcomings of different reporting solutions. We will then look at features that help a mixed workloads play nicely together. Some of these features include filtered indexes, indexes views, persisted computed columns, data compression, resource governor, partitioning and others. We will also touch on database design concepts that can help mixed workloads and leave you with topics to research further so you master the juggling act that is mixed workloads

Address:
Freese and Nichols Corporate Headquarters
4055 International Plaza
Fort Worth, Texas 76109-4895

We’re in the ground floor training room to the left of the guard desk as you enter the building.
Meeting starts at 7 pm but come early for our meet and greet at 6:30 pm if you can!

Meetings

Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.

Comments

When is the next Ft. Worth SS meeting?

Comment by Ryan Daulton on April 27, 2010 @ 7:46 pm

Thats some great fundamentals there, already know some of that, but you can always learn . I doubt a “kid” could put together such information as dolphin278 suggested. Maybe he’s just attempting to be “controversial? lol

Comment by Short sale in San Diego on May 2, 2010 @ 12:23 pm

Interesting, I wonder what the statistics are on your first point there…

Comment by alerts from chase on May 3, 2010 @ 6:58 pm

Thanks for sharing this helpful info!

Comment by online banking on May 10, 2010 @ 9:41 am

Sorry, the comment form is closed at this time.