1,721 reputation
724
bio website
location Denver, CO
age 39
visits member for 3 years, 4 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.


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?
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
You know what... I just had an epiphany... do a full restore with keep_cdc on the new box. That will build cdc out, then start you multi file restore over the top of it without keep_cdc to do your point in time recovery. Ok, I'm squared away now.
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 36 characters in body
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
So restoring to a different database, a new database, or a database that will be a mirroring partner is still a no? I read this same article but it left me wondering about the scenarios above in a multi file scenario.
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 15 characters in body
Oct
4
revised Doing a point in time restore with CDC enabled; Possible?
added 131 characters in body
Oct
4
asked Doing a point in time restore with CDC enabled; Possible?