July OPASS Meeting

OPASS will be holding it’s July meeting this evening from 6pm – 8:30pm at 225 S. Westmonte Drive, Altamonte Springs, FL. 

Sponsor:

Red Gate Software offers a wide range of eBooks for SQL Server developers and DBAs. Broaden your skills and download our latest releases here.

Live Meeting:  https://www.livemeeting.com/cc/usergroups/join?id=W8S3JJ&role=attend

Speaker: David Pless, Senior PFE with Microsoft

For the past three years, David has been a Senior Premier Field Engineer with Microsoft. As a PFE David performs health checks, conducts chalk talks and full training workshops, David also works on reactive and proactive engagements on SQL Server 2005 and SQL Server 2008. David mainly supports the Southeast focusing on Florida, but can be anywhere in the world.

David's core areas are SQL Server Performance Tuning and Optimization, Database Mirroring SQL Server 2005 / 2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and other topics such as consolidation, Table Partitioning, Resource Governor, Performance Data Warehouse, SQL Server Auditing, and more.

Prior to Microsoft David was a freelance consultant and also worked for Intellinet as an MCS Partner Consultant starting the SQL Server practice at the Atlanta based consulting firm. Prior to Intellinet David was a DBA for CheckFree Corporation in Norcross, Georgia for over 6 years. David has worked with SQL Server since version 6.5 and has been an active member of the SQL Server community for years.

Topic:  Performance Tuning and Optimization Part 2 (Part 1 was in March, Recording, Here)

This discussion will continue to cover how to troubleshoot performance issues on SQL Server 2005 and SQL Server 2008. In this discussion I cover performance impact analysis using DMVs, SET options in SQL Server, and Profiler and perfmon analysis. In this discussion I will cover SQLNexus, PAL (Performance Analysis of Logs), RML Utilities, SQLDiag, and other tools. Finally I discuss reading query plans graphically and what you can learn from reading the XML plans.

I will also cover Performance Data Warehouse in SQL Server 2008, new features in SQL Server 2008 regarding missing indexes, viewing query plans, and Extended Events if time permits.

RSVP to webmaster@opass.org so we can make sure we have enough food and drink for everyone.

I have already received a box of swag from RedGate including single user licenses for SQL Prompt Pro and SQL Compare Pro.  All the swag is for in-person attendees only.  Sorry, we don’t have a good way to involve remote attendees in our drawings.