Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

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

Agenda:

  • 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

Presentations:

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: