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.


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
Mar
5
answered Change Data Capture and the __$update_mask binary
Mar
5
asked Change Data Capture and the __$update_mask binary
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
11
comment Quick way to validate two tables against each other
Nice, thanks... good way to find differences after aggregate indicates differences exist. Thanks.
Feb
8
comment Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
In summary... yes, I was misunderstanding the relationship between "parameter sniffing" and the plan cache. Knowing this better now brings it all together. Thanks guys.
Feb
8
comment Quick way to validate two tables against each other
Gave you a plus 1, but the aggregate provided by bacon bits was the icing on top. Thanks.
Feb
8
comment Quick way to validate two tables against each other
We can do a quick check against information_schema to make sure the schemas match. This does exactly what I was imagining... thanks.
Feb
8
accepted Quick way to validate two tables against each other
Feb
8
comment Quick way to validate two tables against each other
It is an option, it's what is being used for the ETL process, but the mustaches upstairs want a second opinion on if it worked or not so using SSIS to prove that SSIS got it right is not as convincing as dropping fancy words like CheckSum or MD5 Hash.
Feb
8
comment Quick way to validate two tables against each other
This has potential. I'll do some testing and get back.
Feb
8
comment Quick way to validate two tables against each other
The union all across a linked server approach had me worried. I like the aggregate and binary_checksum approach... going to start some testing with that now.
Feb
7
asked Quick way to validate two tables against each other
Feb
4
comment Change data capture - how to know who made the change?
Good to know, I thought closed meant closed to voting as well. I pointed out in my comment that Oracle offers this in their CDC implementation. It sorta seems logical. docs.oracle.com/cd/A91202_01/901_doc/server.901/a90237/…