Registration powered by Eventbrite
Contact PDANUG (Pee Dee Area .NET User Group) for event and ticket information.
Pee Dee Area .NET User Group April 2009 Meeting

Pee Dee Area .NET User Group April 2009 Meeting

Tuesday, April 14, 2009 from 6:00 PM to 8:00 PM (ET)

Florence, SC


This event has ended!
View current events hosted by PDANUG (Pee Dee Area .NET User Group)


Ticket Information

Type Ends     Quantity
Attendee Ended Free  

Event Details

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

When

Tuesday, April 14, 2009 from 6:00 PM to 8:00 PM (ET)

Add to my calendar Add to my calendar

Where

ACS Technologies - Training Center
180 Dunbarton Dr.
Florence, SC 29501




Other Maps:



This event organizer is using Eventbrite to provide
event ticketing and online event registration.
© 2012 Eventbrite. All Rights Reserved. Terms of Service. Privacy Policy.
Contact PDANUG (Pee Dee Area .NET User Group) for event and ticket information.