February @sqlHartford Meetup - Data Partitioning!

John Flannery will be speaking and we will be meeting at the awesome Min Ghung Asian Bistro in Glastonbury.

Our sponsor for this event is Confio Software. They'll be in attendance. Please check out their awesome tools for DBAs at http://confio.com

We will discuss both the “how tos” and “why tos” of data partitioning. We will actually partition sales data in AdventureWorks2008R2. (Bring a copy – play along.) The majority of the presentation will focus on the performance effects of partitioning – and what to look for in query plans. In addition, we will discuss and implement adding a new partition, splitting off a partition, splitting on a partition (common in Data Warehouse scenarios), Aligned Indexes, Partial Database Availability and Statistics management implications.

John is the Data Architect at Evolution 1 in Avon, Connecticut – and Adjunct Professor at Quinnipiac University in Hamden, Connecticut. He has 30 years industry experience; working with SQL server since version 4.2 on OS/2, Oracle since 7.3.4. John holds a Master of Science – Computer Science degree from Rensselaer (1995). Publication List: A Strategy for Implementing SSIS in Clusters; SQL Server Magazine; March 2010, page 15.

Min Ghung is the coolest place this side of NYC and the sushi is great (seriously). We'll have a room there and I'll start us off with a nice round of sushi and sashimi (sake, drinks, and entrees are on you, though). We'll be giving away a kindle fire! PLEASE RSVP as Min Ghung wants to know how many chairs to put in the room.

http://www.thetechlabs.com/wp-content/uploads/2011/10/kindle-fire-app-games.jpg