Next Meeting

Date Wednesday, September 7, 2016, 6:00 PM - 8:00 PM

Speaker Brandon Leach

Topic: Treating Tables Like Legos: Partitioning Basics

Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter?
 
If you answered yes to any of these questions, partitioning may be for you! With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations.
 
We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how to make decisions on how and when to implement.

About Brandon Leach:
Brandon is a senior DBA and veteran of IT in the healthcare industry. Originally starting his career as a web developer, he quickly fell in love with SQL Server database development and administration. Currently he is a senior DBA for SurveyMonkey. He works closely with the development, infrastructure, and management in and out of IT to make sure the needs of the business and its future goals are met.

Sponsor:

ConnectPoint Search Group and Redgate
RSVP:

If you plan to attend, please RSVP on Meetup.  Please join the Meetup group if you are not yet a member.  Your Meetup RSVP helps us plan food for the meeting.

Welcome

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most sessions will have a presentation; however, throughout the year we schedule a few group sessions designed to provide a forum that allows attendees to discuss real-world SQL Server related questions, issues and concerns which are addressed as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions


Meeting Location:

Patrick Hays Learning Center
2700 Gateway Oaks Drive
Suite 2600
Sacramento, CA 95833

Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600.


View Larger Map

 

Announcements

SQLSaturday Sacramento 2016 (SQLSaturday #540, #sqlsatsac):
SQLSaturday Sacramento 2016 (SQLSaturday #540) was July 23, 2016.
It was another great event this year; we hope to see you in 2017!
http://www.sqlsaturday.com/540/EventHome.aspx

PASS Summit 2016 Registration Discount Code:
Save $150 with the SACSQLUG registration discount code LC15QXQ4 for PASS Summit 2016

SQLSaturday #399: SQLSaturday 399 was held on July 25, 2015
http://www.sqlsaturday.com/399/EventHome.aspx

SQLSaturday #312: SQLSaturday 312 was held on July 12, 2014
http://sac.sqlpass.org/SQLSaturday/SQLSaturday312.aspx

PASS Summit 2013: Watch the Keynotes, select sessions, interviews and more from PASS Summit 2013 at the PASStv site: http://www.sqlpass.org/summit/2013/PASStv.aspx

SACSQLUG Meeting Archive: Our meeting archive pages have been revised:
http://sac.sqlpass.org/MeetingArchive.aspx

24 Hours of PASS: The Summer 2013 24 Hours of PASS session recordings are now available for viewing:
http://www.sqlpass.org/summit/2013/Sessions/SneakPeeks.aspx

SQLSaturday #222: Our second annual Sacramento SQLSaturday was held on July 27, 2013; more info, pictures, blog and tweet links:
http://sac.sqlpass.org/SQLSaturday/SQLSaturday222.aspx

Sorry, there are no upcoming meetings. Please check back for updates.