1,771 reputation
726
bio website
location Denver, CO
age 39
visits member for 3 years, 8 months
seen Dec 17 at 16:40

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.


Apr
23
revised sql-audit wiki description
added 394 characters in body
Apr
23
revised sql-audit wiki excerpt
added 117 characters in body
Apr
23
revised SQL Server Audit Specification - filter DML by all but one user
edited title
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