Meeting sponsor: Benchmark Learning
Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
Live Meeting
· URL: https://www.livemeeting.com/cc/usergroups/join?id=6GW83K&role=attend&pw=B%7D%3C5%27Nn5m
· Code: B}<5'Nn5m
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
With our database growing rapidly from MB to TB, maintenance tasks locking users out of data access and a 7x24 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.
Barbara Rokke
Barbara Rokke is currently a Lead DBA for 3M Company. She has a Bachelor of Science Degree in Computer Information Systems. She has worked in the Information Technology Industry for more than twenty-four years with the first five years in the Health-Care Industry and the last nineteen years at 3M in various IT related jobs serving Manufacturing, Quality, Environmental and Safety, Security, etc., . In her current job, she is working with databases that range from several Megabytes to more than a Terabyte.
In addition Barbara is a member of SQL PASS (Professional Association for SQL Server), SQL PASS MN and is an active participant in the SQL PASS Women in Technology Special Interest Group. She is also a member of the 3M Native American Council. In her spare time, she is Mom and Volleyball Coach to two teenage daughters.
What is Minimal Logging?
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.
Kalen Delaney
Kalen Delaney has been working with SQL Server for over 22 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1992 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, include every PASS conference in the US, since the organization's founding in 1999.
Kalen is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several books on SQL Server, the most recent being SQL Server 2008 Internals, from Microsoft Press. Kalen blogs at www.sqlblog.com and her personal website can be found at www.SQLServerInternals.com.
|