PASS DC

Next Meeting

Thursday,

March

10

PASSDC Monthly Meeting

  • In-Person @ Microsoft MTC Chevy Chase, Maryland, 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, and mentor specializing in data engine and SSIS. 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 Microsoft office in Chevy Chase. Meetings begin at 6:30pm, and typically last around two hours.

Location

Microsoft Technology Center
5404 Wisconsin Ave. Ste. 700
Chevy Chase, MD 20815
 

Travel

Metro is your friend; the Microsoft office is located above the Friendship Heights Station on the Red Line.

 

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