SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000– that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server DBAs, developers, and Business Intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. It carefully presents each new feature and precisely illustrates the feature with examples that show you how to use it effectively.

This book offers incisive, expert guidance on all of the major new functionality of SQL Server 2005, covering topics that are essential for all SQL Server professionals, including

• Transact-SQL enhancements
• SQL Server Management Studio
• CLR integration and programming stored procedures in C#
• SQL Server Reporting Services enhancements
• SQL Server Analysis Services enhancements
• The new XML datatype and XQuery support
• Security enhancements and Service Broker
• SQL Server Integration Services for data extraction, transformation, and loading

The authors provide practical, in-depth coverage of the core topics that they specialize in–all supported by realistic examples, so you’ll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.

Expert SQL Server 2005 Development is the most advanced book of its kind on the market to help you actively develop expertise. Instead of rehashing the documentation, this book shows how to use SQL Server 2005 to solve real-world business problems, by emphasizing development best practices and building your skills as a developer.

The book’s goal is to help you recognize similar real-life work problems and analogize effectively to solve them. To that end, many exercises are included to help strengthen these skills. You will learn not only what tools and techniques are available, but also how to carefully choose and confidently apply them to produce high-quality designs and applications.