Support the animated giff comment - they get do very old very quickly.

A good tip well presented - many thanks

It will challenge the religious dogma from all the jobsworths out there, but I would love to find just one REAL example of a security breach via xp_commandshell.

Yes a...

BI = Data warehouse

The giveaway is at the end of the article. In the real world data always has conformity issues. If it is not cleaned and matched against reference...

A detailed but clear explanation - many thanks.

Obviously there must be associated performance hit. Does anyone yet have any real-world experience of how CDC might impact...

A good solution meets the requirements (does the job), is reliable and can be maintained. Adequate performance is a part of doing the job, but if a cursor is simpler and it works...

At last sanity!. XML is just another technical solution in search of a problem.

Many years ago a user said "We have a problem sending our orders to  xyz co. ltd - ...