1,488 reputation
316
bio website
location Denver, CO
age 37
visits member for 2 years
seen yesterday
stats profile views 179

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
18
comment QBE Query By Example. How does it handle OR conditions?
Take a look at section 6.6.1 of the following guide pages.cs.wisc.edu/~dbbook/openAccess/thirdEdition/qbe.pdf (page 8 of the pdf document)
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 79 characters in body
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 92 characters in body
Oct
17
comment Does SQL manage foreign key constraints in terms of Insertion?
I've only ever worked with Inno - so that is something I was not aware of. Thanks for the info. A quick google pointed out Falcon does as well. Great input.
Oct
17
revised Identifying connection and publisher vs subscriber in merge replication scheme
added 2 characters in body
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 8 characters in body
Oct
17
asked Identifying connection and publisher vs subscriber in merge replication scheme
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 36 characters in body
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 3 characters in body
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 28 characters in body
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 108 characters in body
Oct
17
revised Does SQL manage foreign key constraints in terms of Insertion?
added 246 characters in body
Oct
17
answered Does SQL manage foreign key constraints in terms of Insertion?
Oct
11
comment The best way to rename the tables after development completed
+1 for validating the change it and fix what broke approach that I get crap for from my own team (dev enviro only of course)
Oct
11
comment Multiple Merge Replications on same SQL Server Database Conflicts
Push or pull subscriptions? Also, do they share tables as well as the database?
Oct
10
revised Multi-tenant database using SQL Server 2008?
added link to article in question
Oct
10
revised Multi-tenant database using SQL Server 2008?
added 78 characters in body
Oct
10
revised Multi-tenant database using SQL Server 2008?
added 1 characters in body
Oct
10
revised Multi-tenant database using SQL Server 2008?
added 1 characters in body
Oct
10
suggested suggested edit on Multi-tenant database using SQL Server 2008?