Robert Biddle

Robert Biddle is a Data Architect with over 10 years of experience working with databases. He has a full-scope understanding of data architecture including administration, development, and business intelligence. Robert has MCITP certifications in database administration and database development. He has a Bachelor of Science degree in Computer Science from the University of Delaware. Currently he works in the Central Florida area.

Articles: 2
Comments: 2

TSQL

SQL Server Rowversion Functions min_active_row_version vs. @@DBTS

For data synchronization projects, using rowversion is a very effective method for detecting changes. In order to work with rowversion properly, we would need to either use @@DBTS or the function min_active_rowversion. Understanding the differences betwee

Robert Biddle
December 22, 2014

Integration Services Development

Using rowversion with SSIS to reduce load times

You want to reduce the load time of your SSIS packages, but you found that the source of the problem is that you are doing full comparisons between your source system and your destination. Perhaps you've come to find that your source system has been diffi

Robert Biddle
July 30, 2014