Pro SQL Database for Windows Azure, 2nd Edition introduces you to Microsoft's cloud-based delivery of its enterprise-caliber, SQL Server database management systemshowing you how to program and administer it in a variety of cloud computing scenarios.
This book's goal is to coverfrom a "real-world" point of viewall of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.
This book takes a deep look at the full range of SQL Server 2005 enhancements. Relevant examples show how these new features work and how you can architect applications effectively. The book's core topics include enhancements to database programmability features and languages, such as ADO.NET, XML, .NET assemblies, and T-SQL.
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.