|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 | DBA 101: Best Practices Every DBA Should KnowSpeaker(s): Brad McGehee
With the continued popularity of SQL Server, more and more people are becoming SQL Server DBAs, whether they planned to or not. Many of these DBAs don’t have formal training, but are doing the best they can under the circumstances. Most of these DBAs want to do a good job, but just don’t know where to start. While Books Online is a great reference tools, it doesn’t tell someone what they need to know about commonly established best practices that experienced DBAs know by heart. The focus on this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing & Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation. Because of time considerations, and the amount of content to be covered, the focus will be on explain what needs to be done, not how to perform each task. By using the best practices suggested in this session, DBAs will be able to go back to their organizations and begin to immediately implement them.
| Oct 9th |
|
 | How to Become a SQL Server Profiler MasterSpeaker(s): Brad McGehee
While many DBAs may understand SQL Server 2005/2008 Profiler basics, not too many know how to tap the full potential of this important utility. In this session, you will learn techniques you can use to troubleshoot many different SQL Server problems, including: How to Identify Long Duration Queries; How to Identify Blocked Processes; How to Identify Deadlocking Issues; How to Identify Sort Warnings; How to Identify Excessive Auto Stats Activity; How to Identify Excessive SP Compilations; How to Identify Excessive Table/Index Scans; and Profiler Best Practices
| Oct 9th |
|
 | How to Write a SQL Server Performance ReviewSpeaker(s): Brent Ozar
One of my specialties is taking an existing application, studying it transparently for a week using tools like Profiler and Perfmon, and then writing up an analysis of what needs to be done to fix scalability or performance problems. Managers love this stuff because it helps IT budget more wisely, helps developers plan their time better, and helps justify DBA salaries. In this session, I’ll show you how to write a performance review.
| Oct 9th |
|
 | SQL Server CLR ExecutablesSpeaker(s): Bill Vaughn
This walks you through the development process of creating each of the CLR executables. We'll talk about what kind of executables make sense and which won't. I'll show examples that have never been shown by anyone else that really push the CLR executable technology to the limits. This is a fairly advanced session, but very popular among both SQL Server developers and DBAs wondering if CLR executables are a path to better performance or just more problems.
| Oct 10th |
|
 | SQL Server Performance Monitoring & Budgeting with PerfmonSpeaker(s): Brent Ozar
I’ll cover the same topics I discuss in my blog article about monitoring SQL Server with Performance Monitor and show how to do some basic budgeting & projections.
| Oct 10th |
|
 | Migration, Management, and Monitoring of SQL Server 2008Speaker(s): Bryan Powell
This topic provides the information that you will need to prepare for and understand the SQL Server 2008 upgrade process; it covers:
Known upgrade issues.
Pre-Upgrade tasks and considerations.
Considerations for failover clusters.
Supported upgrade paths to SQL Server 2008.
Using Upgrade Advisor to Prepare for Upgrades
Backward Compatibility With Previous Editions
Post-upgrade tasks and considerations.
| Oct 10th |
|
|
|
|
|
|
|
|
|
|
|
 |
 |
 |
 |
|