SQL Server 2005 Express Edition - Part 18 - Merge Web Synchronization Setup

Part 18 of this series explores several scenarios in which the Merge Web Synchronization can be applied and describes their implementation details.

Using the CASE expression instead of dynamic SQL

I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?

CS Techcast 16: Revving Up SQL Server 2008

CStechcast.com brings another podcast episode to the starting line with guest Kalen Delaney. This SQL Server expert and authoritative author of the Inside SQL Server series gives us her take on SQL Server 2008. Find the latest from Kalen Delaney at insidesqlserver.com and SQLCommunity.com.

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