Backup compression behavior when appending backups to an existing Media Set

 There will be an upcoming Knowledge base article detailing this out as well  When you append a compressed backup to an existing Media, it inherits the compression setting from the Media set.  If you rely on the ‘backup compression’  sp_configure setting and are appending to existing media sets you may end up with a backup…


Merge Replication Conflict Detection v/s Conflict Resolution

One common misconception about how merge replication handles column-level tracking (detection) is that when a conflict is encountered, the winning row will include column values which did not conflict in addition to the "winning columns". For example: Originally Row100= col1=a, col2=b, col3=c, col4=d, col5=e User1 updates Row100: col1=f,    col2=g,    col3=h    — note: col4 and col5…


Last Known Good Backup/DBCC

  Based on Paul Randal’s post telling how to get the last known good DBCC ran against a database, based on my job requirements, I decided to write a T-SQL script which has nothing new but returns last known good DBCC execution time and last backup time for all databases of a SQL Server instance….