1,721 reputation
724
bio website
location Denver, CO
age 39
visits member for 3 years, 4 months
seen Aug 25 at 19:45

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.


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/…
Feb
4
comment Change data capture - how to know who made the change?
If it were'nt closed, I'd have voted for it. Back to those $%#@## triggers I guess.
Feb
4
accepted Change data capture - how to know who made the change?
Feb
4
accepted Capturing datetime of change in SQL Server CDC
Feb
4
asked Change data capture - how to know who made the change?
Feb
1
revised change-data-capture wiki excerpt
added 320 characters in body
Feb
1
awarded  Tag Editor
Feb
1
revised system-tables wiki excerpt
added 319 characters in body