Tuesday, April 14th, 2009
K. Brian Kelley
Topic: Getting the Most Out of Your SQL Server Queries
Tuesday, April 14th, 2009, is the next meeting of the Pee Dee Area .NET User Group.
In this presentation we'll look at standard tips and techniques to write efficient queries for SQL Server. The use of stored procedures, the basics of indexing and the impact that has on your queries, how to avoid cursors and RBAR code (a Jeff Moden-ism), as well as typical no-nos to avoid will be covered. We'll touch briefly on how to measure query performance through the use of execution plans and SQL Server traces using tools like Profiler and Microsoft Excel to provide for a quantitative assessment of which queries to look at tuning.

K. Brian Kelley
Brian is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as a database administrator / architect for AgFirst Farm Credit Bank where he can concentrate on his passion: SQL Server. He previously was a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical community, Brian is president of the Midlands PASS Chapter, an official chapter of PASS. Brian is also a junior high youth minister at Spears Creek Baptist Church in Elgin, SC.

Here is the tentative schedule:
6:00 PM - 6:20 PM Socializing / Free Dinner
6:20 PM - 6:30 PM Introduction, Sponsor Time, and News.
6:30 PM - 8:00 PM Presentations