Pro SQL Server 2005 Assemblies will show you how to exploit the new .NET capabilities of the SQL Server 2005 database. You will learn how to build robust, useful, and intelligent assemblies that are safe to execute and secure to the organization.
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.
Pro SQL Server 2005 High Availability covers the technology, people, processes, and real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.
SQL Server Integration Services is groundbreaking. It exists for both the database administrator and the developer, as well as that new role SSIS has created between the twothe data artisan. Pro SQL Server 2005 Integration Services contains everything you could ever hope to know about this exciting development from Microsoft.
The book is steeped in the day-to-day challenges, discoveries, and successes involved in delivering a successful reporting solution with SQL Server Reporting Services 2005. Consequently, you will encounter step-by-step guides, best practices, and real code examples that cover all common Reporting Services tasks.
Rich with practical examples, Pro SQL Server 2005 Service Broker is the most complete and incisive book on this important technologyan invaluable resource for all serious database and web developers. Focused on best practices, it explains in detail how Service Broker supports and enhances database and web applications.
This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.
Pro SQL Server 2008 Analysis Services will show you how to pull data together and present it for reporting and analysis in a way that makes the data accessible to business users, instead of needing to rely on the IT department every time someone needs a different report.
Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.