This allows the good rows to be loaded and the bad rows to be logged for later review. Also, keep in mind that you can log to any of the available destinations in SSIS.

SQL Server 2016, which made its debut in early summer, is already at its first service pack. One highlight of this roll-up release is the addition of row-level security and dynamic data masking, which ...

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, ...

The SQL Server database engine now uses TempDB to keep track of changing data via row-versioning so now has a logical “snapshot” of the data as it was before any lock was issued.