30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Database Maintenance Optimization

Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance, including:

  • Physical File Defragmentation
  • Database and Log File Management
  • tempdb Maintenance
  • msdb Maintenance
  • Index Maintenance
  • Statistics Maintenance
  • Data Corruption Detection
  • Database and Log File Protection
  • Database Maintenance Monitoring

Speaker focus

Brad McGehee

brad.jpg

Professional Experience

 

Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 13 years’ SQL Server experience, and over 6 years’ training experience.

 

 

Community Support

 

Brad is a frequent speaker at SQL PASS, SQL Connections, SQLTeach, Code Camps, TechFests, SQL Server user groups, and other industry seminars, where he shares his 13 years’ cumulative knowledge.

 

Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics.

In 2008, Brad attended 16 conferences/user group events, presented 26 sessions, and had 1,402 people attend them.

A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 12 technical books and over 100 published articles. His most recent books include “How to Become an Exceptional DBA,” and “Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs.” In early 2009, he will be releasing a book on how to use the SQL Server Profiler.


Brad McGehee's blog http://www.sqlservercentral.com/blogs/aloha_dba/default.aspx



Downloads

File Type Ext ContentName
Presentation .pptx Slide Deck
<< 1 >> 

Other sessions from this conference

AddIns for SSMS - build your own
Comparing Azure storage and SQL Data Services
Data Mining and SSIS - makes sense.
Data Warehouse Data Modelling
Data Warehousing features in SQL 2008
Designing Effective Aggregations in Analysis Services 2008
Effective test-driven database development
End to End Report Creation and Management in SQL Server Reporting Services 2008
High Availability in SQL Server 2008
Implementing Clustering using SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Making the SQL developer one of the family with Visual Studio Team System
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
NHibernate – Open Source Object Relational Mapping (ORM)
Performance Optimization with SQL Server 2008
Performance Tuning your TSQL
Securing and Hardening a SQL Server Implementation - Notes from the Field
SQL Server Architecture: The life of a query
SQL Server’s storage engine
SSIS by example
SSIS Nuggets Live
Stop throwing hardware at the problem !
Understanding ADO.NET Data Services
Understanding Graphical Execution Plans
Universal calculated measures in MDX queries
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices
What’s New in SQL Server 2008 T-SQL