SQL Server Backup Compression

In Vincent Rainardis Blog you find a good explanation of Backup Compression for SQL Server 2008.

Change Data Capture

Vincent Rainardi explains in his Blog the Change Data Capture (CDC) mechanism of MS SQL Server and includes a short code example.

Using Runtime-Collations To Mimique Different Target Orders

Here is a nice conclusion of oracles language & collation settings/capabilities.

Especially the usage of the

NLSSORT

function in conjunction with an

order by

statement can help you to present result sets in exactly that order that, e.g., a target system with a specific internationalization setting will interpret or need the data:

select * from source order by NLSSORT(sort_column,'NLS_FORMAT=xxx')

Useful format parameters are, e.g., binary or ascii7.

Debugging Attribute Constraints in Dimension Tables

A solution that is especially useful wrt. SSAS postprocessing can be found here.