Speaker: Kevin Kline , SQL Server MVP and Author

Topic: SQL in a Nutshell, SQL history and implementations

Date: October 19, 2010 11:00 a.m. EDT

In this session, join Kevin Kline as he reviews SQL History and implementations including: the relational model and ANSI SQL, the history of the SQL Standard, and SQL Dialects.

Speaker: Brian Knight , SQL Server MVP and Author

Topic: Out with the old in with the new, Migrating DTS to SSIS

Date: October 21, 2010 11:00 a.m. EDT

In this session, join Brian Knight as he reviews “tips and tricks” for migrating DTS to SQL Server 2008 SSIS. Including “Must have” SSIS knowledge before you migrate.

Speaker: Jorge Segarra , MCTS (SQL Server 2005) and Author

Topic: Pro SQL Server 2008 Policy-Based Management

Date: October 26, 2010 11:00 a.m. EDT

Policy based management is a new feature in SQL Server 2008 that allows you to define and implement policies across your SQL Server infrastructure. In this session, join Jorge Segarra as he reviews SQL Server 2008 Policy-Based management best practices.

Speaker: Grant Fritchey , SQL Server MVP and Author

Topic: Identifying and Fixing Performance Problems using Execution Plans

Date: October 28, 2010 11:00 a.m. EDT

This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate different methods for addressing the issues and show how the fixed query's execution plans differ. Multiple methods for accessing execution plans including graphical, DMV's, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently.