SQL Server’s first attempt at Data Compression actually looks pretty good. As I noted in my beta preview (see “Microsoft’s ‘Katmai’ is filled to the brim”), SQL Server 2008 provides ...

Many of the data flow tasks include the option to redirect errors down a different path. These bad rows can then be logged and reviewed later to see what the issue was. Let's look at an example.

The tool's Always Encrypted functionality was also improved, as described in another post published by Microsoft yesterday titled "Always Encrypted Assessment in SQL Server Management Studio 21." ...