Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers

Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers explains how to use ASP.NET 2.0 and SQL Server 2005 most efficiently together. It covers all crucial performance issues and illustrates optimal techniques with enterprise-quality development.

Performance is always an issue, and optimizing database access is one of the most daunting performance challenges facing web developers. With Brennan Stehling as your guide, you'll explore the many overlaps of web and database technologies, including configuration, programming, performance tuning, and deployment. You’ll learn how to make high-performance database access not just a goal, but a reality.

What you’ll learn

• Discover what impedes ASP.NET 2.0 access to SQL Server 2005 and how to make web applications and databases work blindingly fast together
• Learn to make the subtle choices between DataSets, DataReaders, and DataObjects, to simplify code and maximize performance
• Optimize data-bound controls and create your own
• See when a custom database provider is advisable and how to build one
• Understand how to monitor and measure web/database performance
• Learn to build, deploy, and configure enterprise-level web applications against SQL Server 2005

Anyone involved in .NET web development will find this book invaluable. Whether you’re struggling just to handle traffic or scaling up to meet demand, you’ll find all the tools, tips, and techniques you need for high-performance web access to databases. If you want to build enterprise-level web database applications 100% of the time, this book will tell—and show—you how to do it.

Every ASP.NET developer faces the thorny issue of optimizing database access. Pro SQL Server 2005 High Performance: High-speed ASP.NET 2.0 Data Access is the most comprehensive and detailed guide to using ASP.NET 2.0 and SQL Server 2005 optimally together. It focuses on building enterprise-level Web applications and provides a wealth of code samples that show exactly how to do it.

Written for experienced ASP.NET 2.0 programmers and SQL Server 2005 database administrators and developers, this is the only book that completely describes the crucial performance aspects of Web-based database applications and demonstrates how to design, configure, and code databases and Web applications for optimal performance.

Brennan Stehling is a consultant in Milwaukee who specializes in web, console, and desktop development projects. He's worked with .NET for several years, particularly since the .NET 2.0 Beta 1 release. He blogs regularly on .NET topics at http://brennan.offwhite.net/blog/. He also develops reusable tools in C# and makes them available to developers at SmallSharpTools.com. In his spare time, Brennan plays Gaelic hurling, an Irish sport that has become popular in Milwaukee over the past 10 years.