Next Meeting

Thursday,

March

10

PASSDC Monthly Meeting

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

This month, we'll be hosting a SQL Saturday Richmond Preview featuring Tom Staab, who will be speaking in Richmond on March 19th. Food and a raffle are provided, 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:

Introduction to Partitioning

Tom Staab, Solutions Architect Amazon Web Services

We all know that a smaller table is generally faster to retrieve data from than a larger one. What if you could split your very large table into a set of smaller tables but still query and manage them as if they were 1 table? Would that improve your query performance? In this session, we'll examine table partitioning and how it works under the covers to do just that. I'll demonstrate how to configure and manage partitioning (including the magic of SWITCH and sliding windows) and give some examples showing the performance benefits. Finally, we'll take a look at partitioned views and compare/contrast those with partitioned tables.

About Tom:
Tom is a Partner Solutions Architect at Amazon Web Services. He has worked with SQL Server for over 20 years as an architect, developer, administrator, mentor, and speaker specializing in the data engine and Integration Services. He enjoys interacting with the SQL Server community at events such as AWS re:INVENT and PASS Summit as well as online via Twitter (@tomsql) and as a moderator and contributor at ask.sqlservercentral.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