Just a reminder that I'll be speaking at the Kansas City .NET SIG on Tuesday, July 26th, 2005. Suprisingly enough I'm going to be talking about SQL Server. The talk is titled What I Wish Developers Knew About SQL Server.
As an independant contractor I see many different development projects and software packages that use SQL Server. This presentation covers the most common mistakes I see in SQL Server development. It will also provide a variety of tips to improve the development process. The session will cover database application development including database design basics, database builds during development and version control. It will cover writing good queries, locking, set-based processing, stored procedure basics, connecting to SQL Server, simple administration and basic security. All topics will focus on the most common mistakes rather than providing a comprehensive overview of each topic.