This article focuses on tips and tricks to improve your data structure design that can increase SQL-Server query performance: index design, stored procedures and triggers.

Learn the reasons for using the Managed Extensibility Framework, and how convention-driven configuration can streamline the development process.

This article extols the benefits of TDD when applied to database development—and supplies some useful techniques along the way.

We introduce you to “Oslo” and demonstrate how MSchema and MGraph enable you to build metadata-driven apps. We’ll define types and values in “M” and deploy them to the repository.

This article describes how to retrieve information from an SQL table via an HTTP service built on the Microsoft .NET framework. After defining the service model via introspection, you will bind a service operation to a Flex component to use the data in the Flex application.

With a number of clients, I have been provided a sample format for a transactions along with instructions to develop a process to load it into a database as quickly and painlessly as possible. This usually comes with the requirements that the XML data file can have any number of records from 1 to n. This example demonstrates the most efficent and scalable way that I have found to solve this. Not to mention that it can be maintained without rebuilding the solutions each time the data format changes.

This article provides an architectural overview of SQL Azure Database, compares it with SQL Server and describes how you can use SQL Azure to augment your existing on-premises data infrastructure or as your complete database solution.

The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best possible. You can give the Query Optimiser a better idea by using Table, Join and Query hints. These come with a risk: Any choices you force on the Optimizer by using hints can turn out to be entirely wrong as the database changes with the addition of data over time.

This article covers the following topics:
* Installing and configuring a Master Data Services solution
* Designing and deploying a framework to use Master Data Services

A SQL Server stored procedure, sometimes referred to as a stored proc or procedure, allows you to write one or more TSQL statements and store them within your database so that they can be called over and over again without having to write that code a again. This article shows you how to create a stored procedure for the Microsoft SQL Server database.