1,736 reputation
725
bio website
location Denver, CO
age 39
visits member for 3 years, 6 months
seen 2 days ago

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
suggested suggested edit on sql-audit tag wiki
Apr
23
suggested suggested edit on sql-audit tag wiki excerpt
Apr
23
asked SQL Server Audit Specification - filter DML by all but one user
Apr
17
awarded  Popular Question
Mar
20
awarded  Notable Question
Feb
12
awarded  Popular Question
Feb
4
awarded  Custodian
Feb
4
reviewed Reject suggested edit on What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Nov
18
comment I Want to Become a Database Administrator - How Can I Start?
Probably right about it getting closed, but plus one until it does for giving such a thorough answer.
Nov
5
awarded  Notable Question
Nov
3
comment Change data capture - how to know who made the change?
Ahhhh, didn't catch that. I get what your saying now.
Nov
1
comment Change data capture - how to know who made the change?
That only gets you the svc account/owner of cdc, you might note that I tried those things and documented the results in my original question way back in Feb.
Oct
19
revised Create table from stored procedure result
added 395 characters in body
Oct
19
answered Create table from stored procedure result
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
awarded  Enlightened
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
We've been running CDC on an async mirror for several months. It's been working great for tbe data warehouse to query the snapshot. It wasn't until we moved the mirror partner to a new datacenter that all this became an issue. Setting up mirror and then CDC, no problem. CDC and then mirroring... not so easy.
Oct
4
awarded  Nice Answer
Oct
4
accepted Doing a point in time restore with CDC enabled; Possible?