1,746 reputation
725
bio website
location Denver, CO
age 39
visits member for 3 years, 6 months
seen Oct 23 at 3:31

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.


Sep
25
asked Identifying if spid on SQL Server is in rollback after low disk space
Jul
8
answered What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well
Apr
23
wiki created sql-audit excerpt
Apr
23
wiki created sql-audit description
Apr
23
asked SQL Server Audit Specification - filter DML by all but one user
Oct
19
answered Create table from stored procedure result
Oct
4
asked Doing a point in time restore with CDC enabled; Possible?
Mar
8
asked Delete a variable number of records by a chronological order
Mar
7
answered Change Data Capture and the __$update_mask binary
Mar
6
asked TSQL DateTime DataType - fractional seconds vs milliseconds
Mar
5
answered Change Data Capture and the __$update_mask binary
Mar
5
asked Change Data Capture and the __$update_mask binary
Feb
7
asked Quick way to validate two tables against each other
Feb
4
asked Change data capture - how to know who made the change?
Feb
1
wiki created change-data-capture excerpt
Feb
1
wiki created system-tables excerpt
Feb
1
asked Capturing datetime of change in SQL Server CDC
Jan
29
answered Upgrade process from SQL Server 2000 to SQL Server 2012
Jan
28
asked Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
Jan
8
answered The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber.