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 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.
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.
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.
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.
Pro SQL Azure 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.
Pro Spatial with SQL Server 2012 introduces SQL Servers spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space.
Pro Entity Framework 4.0 is a professional-level guide to Microsoft's Entity Framework, the future of data access in .NET programming. Readers learn to implement easy-to-program and highly-performing database access solutions.