In SQL Server, the Referential Integrity is governed by the fact that there is a defined primary key that will only ever allow unique values. That primary key is used to establish relationships with other tables. This article shows you how to create primary keys in SQL Server. The concept …
This presentations explains how Microsoft SQL Server 2008 R2 data management software can improve the performance of data warehouse systems. Performance and scalability go somewhat hand in hand. The better that your data warehouses perform the more scalable they tend to be. We look at the optimizations that were made …
Erik Ejlskov Jensen is the author of the SQL Server Compact Toolbox add-in. SQL Server Compact Toolbox is a Visual Studio 2010 Pro or higher add-in (for 3.5/4.0) and standalone app (for 4.0), that adds scripting, import, export, migrate, rename, run script, manage replication and more to your SQL Server …
This tutorial shows how to improve your SQL Server database performance. Faster hardware can improve application performance to a certain point, but for truly great performing systems, there is no substitute for properly written queries and well-designed indexes.
This video discusses the types of constraints you can use in SQL Server and how they can be use to maintain data integrity. SQL Server constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. Using constraints is preferred to using DML Triggers, …
The Open Data Protocol (OData) has rapidly gained popularity as an efficient way of exposing data sources via REST services. Platform neutrality of the protocol makes it a great choice when developing both data services and clients, and with Visual Studio 2010 and .NET 4.0 tools and libraries adding OData …
