Application Roles

Hubs, Spokes and Buses: How to Get to a Better Data Warehouse

Are you frustrated by the inefficiency, rigidity and latency of a first-generation, hub-and-spoke-architecture data warehouse? Here's a six-step guide to evolving to a streamlined, robust Kimball Dimensional Bus Architecture that will reduce time to reporting, lower data latency, and deliver more detailed, analytically useful information.

Utah Code Camp 2008

If you are near Salt Lake City on April 26th, join in the local Code Camp there.

Data Compression in SQL Server 2005 (Believe it !!)

That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.

Screencast: Tracking memory with PerfMon counters

Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.

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.