February PASSMN Meeting

Posted by & filed under , , , , .

If you’ve got the time, stop in to socialize and learn a bit about SQL Server.  Kalen Delaney will be in town teaching a class over at Benchmark Learning and has offered to join the meeting to talk about Simple Recovery Model.   Also, Barbara Rokke has offered to share  some of her experiences with partitioning in SQL Server.

Here are the meeting details:

Location:

8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Date:

February 23, 2010

Time:

4:00 -7:00

Please click here for more meeting details and to RSVP.

Case Study: A Partitioning Strategy for a VLDB

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?

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.