in

Richmond SQL Server Users Group

Richmond VA's community oriented SQL Server User Group

events

Thursday, May 8th, 2008 6:30PM to 8:00PM

May's Presentation: Optimizing Language Integrated Queries with SQL Server Profiler
by Kevin Hazzard

Registration is not required for this event but if you plan to attend, please register so we'll know how many developers and database professionals to expect (feed). Thanks! 

This Months Sponsor

 

Abstract

Language Integrated Query (LINQ) marks the beginning of a massive shift in Microsoft’s data access philosophy. For those of us who grew up in the era when Microsoft touted the benefits of stored procedures as a necessary and sufficient abstraction of business logic, Object/Relational Mapping (O/RM) tools like LINQ to SQL can present a somewhat rude awakening. Because of our upbringing, we’ve learned to spend much of our time optimizing our stored procedures as a throttle for managing database performance in general. But what happens when the stored procedures simply disappear? Are you ready for that?
 
While moving business logic away from the database and into the middle tier is exciting for plenty of reasons, the specter of losing some control over database performance is very unsettling to most DBAs. Likewise, C# and VB developers need to get ready for the changes that LINQ to SQL will bring to them, too. When database performance suffers while using an O/RM tool, software developers will be called on to participate in the triage and tuning of queries in ways for which they may not be fully prepared. No more finger pointing at the database people when the database is slow. So this presentation should be as useful to software developers as it will be for the traditional DBAs and database developers in the audience. Come learn how to use the SQL Profiler to find and fix bottlenecks in your LINQ to SQL queries. The discussion will be fast-paced, informative and highly interactive.

About Kevin

Kevin is currently the Software Architect for SnagAJob.com in Richmond, Virginia. He has served on the Internet Engineering Task Force (IETF) and as an advisor to Virginia’s Joint Commission on Technology and Science (JCOTS). Kevin currently serves as the Chairman of the Information Systems and Technology Advisory Board for J. Sargeant Reynolds Community College. He’s also served the College as an adjunct instructor since the year 2000. As a Senior Engineer in the Intel Architecture Labs, Kevin successfully authored patents and designed ciphers, networking protocols and peer-to-peer components used by millions of users worldwide. Kevin has been designing and writing software for 25 years. He loves the art and the science of his job as much today as he did in the very beginning. Kevin is a father to five, a husband to one and a servant to many others. He speaks a bit of Portuguese, a bit of German and enjoys doing missionary work in South America. For fun, he enjoys motorcycling, hiking, etymology, bird-watching and friendly yet passionate discussions about politics and history.

Comments

No Comments
©2006-2008 Richmond SQL Server Users Group; ©2008 Richmond User Groups Corporation
Powered by Community Server (Non-Commercial Edition), by Telligent Systems