On April 14th, 2014, I’ll be presenting a session titled, “SQL Server Optimization for Developers” to the Austin .NET User Group. The free event will opportunities for networking, food and drinks, and (of course) a presentation.
Here’s a brief overview of the topic and the presentation:
Database optimization is a critical component of overall application performance, and sub-optimal configurations can limit reliability, scalability, and the user experience. Unfortunately, many developers see database monitoring and optimization as a black art – something that’s better left to production and operations specialists. This presentation will focus on practical, real-world methods for monitoring and optimizing performance for SQL Server-based applications. Demonstrations will include understanding index types, capturing query data with SQL Profiler, analyzing indexes and using the Database Engine Tuning Advisor. In addition to live demos the content will focus on managing locking, managing schema changes, and application design best practices for developers.
If you’re in the Austin area, I hope to see you there!
Update: You can download the slides from the presentation from my SQL Server Presentations page. And, coming soon: A full recording of the session, courtesy of UserGroup.tv (thanks, Shawn!). Thanks to everyone for attending!
Update 2: The entire recorded presentation has been posted on UserGroup.tv: SQL Server Optimization for Developers, along with my previous videos. Thanks, as always, to Shawn for recording the session.