The curse and blessings of dynamic SQL

How you use dynamic SQL, when you should - and when you should not.

Operators

SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization

In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.

Fuzzy Lookup and Fuzzy Grouping in SQL Server Integration Services 2005

This paper describes the Fuzzy Lookup and Fuzzy Grouping transformations that are part of SQL Server 2005 Integration Services (SSIS). These SSIS transformations are useful for improving the data quality of existing data as well as new data that is being loaded into your database.

Internals of DBM Failover / Role Switching

Understanding different types of failovers/Role Switching and How do they internally work in database mirroring.

Employ Metadata to Enhance Search Filters

Discover how to use metadata for pooling information already resident in an application to create a flexible search interface that reduces complexity and increases users' productivity.

Measures

Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans

This article will show you how to use the sys.dm_exec_cached_plans DMV to monitor the performance of stored procedures

Data Generator Source Adapter

The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.

Implementing Table Inheritance in SQL Server

When designing a database, we sometimes come across situations where there are multiple types of entities that we are modeling, but we'd like them to all have certain attributes or relations in common. Using "sub-type" tables is a simple way to implement table inheritance in SQL Server.