1,670 reputation
623
bio website
location Denver, CO
age 38
visits member for 2 years, 11 months
seen Mar 26 at 22:30

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.


Oct
19
revised Create table from stored procedure result
added 395 characters in body
Oct
19
revised Does SQL manage foreign key constraints in terms of Insertion?
added 8 characters in body
Oct
14
revised Doing a point in time restore with CDC enabled; Possible?
added 7 characters in body
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 36 characters in body
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 15 characters in body
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 131 characters in body
Sep
11
revised Does SQL manage foreign key constraints in terms of Insertion?
added 4 characters in body
Jul
31
revised Location of Maintenance Plan's Back Up Database Tasks information (SQL Server 2005)
added 9 characters in body
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