11 February 2007 19:23 tonyrogerson

6th March - Kimberly Tripp and Paul Randal; Crucial Database Maintenance Techniques for Databases of All Sizes

Hi all,

I know its short notice, but I've done a few of these events now all with exceptional feedback and given Kimberly and Paul are both in Europe and could make 6th March then I just had to book them (Reading, UK)!

This only got confirmed over the weekend so I've not had chance to get the registration process ready.

Set your dates and if you are interested then book through here: http://sqlserverfaq.com/controls/event/eventbooking.aspx; cost for this full day event with two of the most well known and technical people in the SQL Server world is £199 ex VAT which includes refreshments and a light lunch.

Crucial Database Maintenance Techniques for Databases of All Sizes

Kimberly L. Tripp;
Founder, SQLskills.com

Paul S. Randal;
Principal Lead Program Manager, Microsoft Corp.

Often databases are designed to handle complex business logic and to hold critical data. Once built, they're put into production and often perform well... for a while. When the load increases and the data volume becomes larger and larger, performance degrades and problems ensue. What can be done to ensure smooth operations? How can you minimize data loss in the event of a disaster? What are the most crucial maintenance operations to automate, how do they work and why are they important, what are the best practices for running them and how can you ensure they're working correctly? Maintenance is the key to having a system that's healthy, recoverable and performant. There are lots of areas to cover but here are the most important features: Database files (shrink, grow, virtual log files, log size/management), consistency checks (CHECKDB (which includes these other) v. CHECKTABLE/CHECKALLOC/CHECKCATALOG (why might you want to break down your checks?)), fragmentation (Defrags v. Rebuilds), Statistics (create and update) and Backup/Restore (recovery models, options/granularity, strategies). This workshop is targeting the best practices and goals for Database Administrators who are wearing many hats or full-time System Administrators. The workshop will vary from 200-400 level covering ALL of the key concepts what the feature is, how it works, why it's important and best practices in how and when to run.

Why you should attend this workshop? Learn from industry expert Kimberly L. Tripp as well as a key source on the SQL Server Development Team; Paul S. Randal. Paul is the former Storage Engine Access Methods Team Lead for SQL Server 2005 and the developer who wrote DBCC SHOWCONTIG (2000), DBCC INDEXDEFRAG (2000) and DBCC CHECKDB/repair for SQL Server 2005. Currently, Paul runs the Program Management team that controls the Core Storage Engine but part of his role includes directly interfacing with customers to help understand their needs and challenges. He's relatively new to the speaking circuit but has had rave reviews at TechEd (seven of them in 2006) and ITForum! If you're interested in getting more details from and about Paul, check out his content on the SQL Server Storage Engine Team blog: http://blogs.msdn.com/sqlserverstorageengine/default.aspx.

Agenda

Part I: Database Creation/Space Management Best Practices

Part II: Table Structures, Fragmentation and Statistics

Part III: Designing a Backup Strategy for Effective Disaster Recovery

Part IV: Secrets of Fast Detection and Recovery from Database Corruptions

**********

Paul S. Randal
Principal Lead Program Manager, Microsoft Corp.

Paul started in the industry in 1994 working for DEC on the VMS file system and check/repair tools. In 1999 he moved to Microsoft to work on SQL Server, specifically on DBCC.

For SQL Server 2000, he concentrated on index fragmentation (writing DBCC INDEXDEFRAG, DBCC SHOWCONTIG) and various algorithms in DBCC CHECKDB. During SQL Server 2005 development was the lead developer/manager of one the core dev teams in the Storage Engine, responsible for data access and storage (DBCC, allocation, indexes & heaps, pages/records, text/LOB storage, snapshot isolation, etc). He also spent several years rewriting DBCC CHECKDB/repair.

Since SQL Server 2005 shipped, Paul has managed the Program Management team for the core Storage Engine to become more focused on customer/partner engagement and feature set definition. Paul regularly presents at conferences around the world on high-availability, disaster recovery and Storage Engine internals. His popular blog is at http://blogs.msdn.com/sqlserverstorageengine.

Kimberly L. Tripp
Founder, SQLskills.com

Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. Since 1995, Kimberly has worked as a Speaker, Writer, Trainer and Consultant for her own company SYSolutions, Inc. (www.SQLskills.com). In consulting, Kimberly tackles real world problems focused on performance, tuning, system availability and minimizing data loss. In writing, Kimberly contributes regularly for MSDN and SQL Server Magazine, and co-authored the MSPress title SQL Server 2000 High Availability. In speaking, Kimberly’s comments usually include that she has a gift of being able to discuss complex technical topics with ease and humor. Prior to starting SYSolutions, Kimberly held positions at Microsoft including Subject Matter Expert/Trainer for Microsoft University and Technical Writer for the SQL Server Development Team. You can get more details about Kimberly on SQLskills.com and her blog: www.SQLskills.com/blogs/Kimberly.

Filed under:

Comments

# Three upcoming events in March to learn about HA/DR and DB Maintenance

13 February 2007 05:03 by SQL Server Storage Engine

Things start early this year! I'm doing three events in March where I'll be speaking on HA/DR, internals

# Perfect SQL Database Corruption Scenario. Bad Old Days… « sqlserver911

Pingback from  Perfect SQL Database Corruption Scenario. Bad Old Days… « sqlserver911

# Perfect SQL Database Corruption Scenario. Bad Old Days… « sqlserver911

Pingback from  Perfect SQL Database Corruption Scenario. Bad Old Days… « sqlserver911

# Upcoming Events and Instant Initialization is not…………. | Kimberly L. Tripp

Pingback from  Upcoming Events and Instant Initialization is not…………. | Kimberly L. Tripp