Next Meeting

Thursday,

May

11

PASSDC Monthly Meeting

  • In-Person @ The Motley Fool - 2000 Duke Street Alexandria, Virginia, United States (map)
  • 18:30 - 21:00 Eastern Daylight Time
  • Language: English

Our regular meeting, with food provided and a raffle, followed by Office Hours at Clyde's of Chevy Chase across the street (downstairs bar). Bring your questions and build your network of SQL Server peers.

Featured Presentation:

Statistics & Cardinality – How They Work to Find Data Efficiently

Chris Bell, Founder / Lead SQL Consultant WaterOx Consulting

Are your statistics up to date? Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.

About Chris:
Chris offers a unique view of how we live and work with data both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the CEO and Lead Consultant for his company, WaterOx Consulting, while remaining the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.

Regular Meeting Details

PASSDC meets the second Thursday of each month at the Motley Fool in Alexandria, Virginia.

Meetings begin at 6:30pm, and typically last around two hours.

Location

The Motley Fool
2000 Duke street
Alexandria, VA
22314

Travel

Metro is your friend; the Motley fool is just a short walk from the King street metro (use the tunnel!).

Note: The building is a secured building and the doors will most likely be locked when you arrive.
We will have someone at the front door to let you in. If you arrive early you will need to wait until 6:30 for us to let you into the building. a phone number you can text for entry between 6:30 pm and 7:30 will be posted on the door.

 

RSVP

 

 

PASSChapterLogo.jpg


Major Sponsors



Capital Personal Computer User Group ( C P C U G )


WaterOx Consulting


sql_micro_sm.gif


GEICO


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids