Dynamic Search Conditions

ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.

Measures

Password Issues

SQL Server 2008 security and compliance features reduce security risks

Looking at this from a confidentiality, integrity and availability perspective – the essence of security and compliance – there are quite a few new selling points.

Five steps to designing event handlers in SSIS

Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event Handler.

Get More Out of SQL Server Reporting Services Charts

This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports. It provides an overview of some Reporting Services features, answers common chart design and feature questions, and includes advanced examples of how to design better charts.

The Architecting Magic Behind Taking Mash Ups Offline

While most of the complexity you encounter in synchronization efforts will be unique to your application and infrastructure, synchronization works best when it's designed to be a core feature in each data store.

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.