1,488 reputation
316
bio website
location Denver, CO
age 37
visits member for 2 years
seen yesterday
stats profile views 179

Developing, modeling, administering, tuning, troubleshooting, extracting, transforming, and loading databases full time since 1996.

First professional assignment with databases began building CAClipper xBase applications back when a database with 2 million plus records was considered huge. Moved to FoxPro and Borland Visual Delphi in the mid 90's and then SQL Server in '98.

Have also worked with Sybase, MySQL, Oracle, Access, Multivalue Informix, Filemaker, 4D and the Microsoft BI stack.


Mar
8
revised Delete a variable number of records by a chronological order
deleted 9 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
deleted 29 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 34 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 66 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 3 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 107 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 258 characters in body
Mar
6
revised Capturing datetime of change in SQL Server CDC
changed data type of approach from datetime to datetime2
Mar
5
revised Change Data Capture and the __$update_mask binary
added 24 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
added 93 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
added 1 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
added 229 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
added 134 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
deleted 237 characters in body
Feb
18
revised Quick way to validate two tables against each other
added 636 characters in body
Feb
18
revised Quick way to validate two tables against each other
edited body
Feb
18
revised Quick way to validate two tables against each other
added 2391 characters in body
Feb
1
revised change-data-capture wiki excerpt
added 320 characters in body
Feb
1
revised system-tables wiki excerpt
added 319 characters in body
Feb
1
revised Capturing datetime of change in SQL Server CDC
added 82 characters in body