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 Oracle SQL unlocks the power of SQL in the Oracle Databaseone of the most potent SQL implementations on the market today. This book is for developers and database administrators who are writing and optimizing SQL queries and data manipulation statements.
With growing reliance on spatial components for making critical and strategic decisions, there is great incentive to maximize the added value of spatial data. Enter ProOracle Spatial. This highly anticipated book examines the potential for organizations to exploit spatial information by way of Oracle Spatial.