Encryption

SQL Server Database Requirements

In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.

Column-Store Databases and DW Appliances

With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.

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.