PASSMN February 23, 2010 Monthly Meeting
Posted by denglishbi on February 10, 2010
The next Minnesota SQL Server User Group meeting is coming up in a couple of weeks on Tuesday, February 23 from 4 to 7 at the local Microsoft office in Bloomington. This month we will be looking at partitioning and minimal logging.
In order to RSVP for the event you will need to login to the national PASS site and click on the RSVP link. This month our sponsor for the event is Benchmark Learning.
PASSMN February 2010 Meeting – Partitioning & Minimal Logging
- Meeting sponsor: Benchmark Learning
- Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
- Please RSVP here for the event to assist in making sure there is enough snacks and beverages ordered
- Live Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=6GW83K&role=attend&pw=B%7D%3C5%27Nn5m Code: B}<5’Nn5m (to get the audio you will need to download and install the full Live Meeting client)
3:30-4:00 : Networking
4:00-4:15 : Announcements
4:15-4:25 : Sponsor introduction
4:25-5:25 : Partitioning (Barb)
5:25-5:30 : Break
5:30-6:30 : What is Minimal Logging? (Kalen)
6:30 : Swag Drawing
Case Study: A Partitioning Strategy for a VLDB (presented by Barbara Rokke, 3M) – With our database growing rapidly from MB to TB, maintenance tasks locking users out of data access and a 7×24 data access requirement by the clients, the DBA team needed to come up with a better way of managing the large database. Partitioning was discussed however the DBA team didn’t have time to develop a manual partition strategy. With the release of SQL Server 2005, partitioning became a viable option. After discussions with Microsoft experts and reading every bit of information available on the web (only 2 websites offering valuable information at the time), the DBA team took the leap into the Partitioning world. Partitioning was installed and a two year window processing script was developed to maintain a rolling window of data.
This presentation will provide a review of the thought process and the implementation of the partitioning strategy the DBA team developed. Also a walk-through of the two year window processing to show self-maintenance partitioning will be reviewed.
What is Minimal Logging? (presented by Kalen Delaney) – There is a common misconception that Simple Recovery Model means no logging, and this is a very dangerous myth to propagate. SQL Server does log database changes in Simple Recovery, but some (not all) operations are minimally logged. In this session, I’ll discuss what exactly minimal logging means and what the benefits and dangers of Simple Recovery model are.