The next Minnesota SQL Server User Group meeting is next Tuesday on February 19. This month the two presentations will be on (1) rules-based backup and index maintenance and (2) database corruption. Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.
The sponsor for this month’s meeting is Emergent Networks.
Location: 3601 West 76th Street, Suite 600 Edina, MN 55437
Date/Time: Tuesday, February 19 from 4 to 6 p.m.
• URL: https://www.livemeeting.com/cc/usergroups/join?id=SRR9DN&role=attend&pw=zd%3F9c.2KJ
• Meeting ID: SRR9DN
• Entry Code: zd?9c.2KJ
- 4:00 – 4:10 : Registration / hospitality / networking
- 4:15 – 5:15 : Presentation: Shoveling Frogs into a Wheelbarrow
- 5:15 – 5:45 : Presentation: An Overview of Database Corruption
- 5:45 – 6:00 : Announcements and prize giveaways
Shoveling Frogs into a Wheelbarrow (by Merrill Aldrich)
If you face managing over a hundred, or perhaps thousands of databases, automation, standards and a “policy-based” mindset are critical. In this session we’ll do a walk-through of a rules-based backup and index maintenance solution suitable for zillions of smaller databases, and talk at a high level about features and techniques for multi-server management including monitoring, performance data collection, jobs automation, PowerShell and PBM. (The core of it will be a walkthrough of the solution athttp://sqlblog.com/blogs/merrill_aldrich/archive/2012/08/01/rules-driven-maintenance.aspx and the update published athttp://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/16/update-to-rules-driven-maintenance.aspx)
Merrill Aldrich is a SQL Server DBA with one of the largest credit unions in the US, located in the Seattle area. He’s currently responsible for corralling a sprawling and very diverse collection of ISV-provided SQL Server databases that together serve the organization’s 800,000 members. In a past life he was trained in Architecture, designed buildings, and taught three-dimensional modeling and building information modeling.
An Overview of Database Corruption (by James Larson, United Health Group)
An Overview of Database Corruption that will include warning signs, causes and scenarios with repair options
James Larson is a Database Consultant\ Team Lead at United Health Group. Has over 15 years of experience with SQL Server. James also has 4 years of experience developing applications with Visual Basic 6.0. James has been working in the Health Care field for over 8 years and currently holds a Microsoft SQL Server 2008, Implementation and Maintenance Certification.