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.


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?
Sep
29
awarded  Popular Question
Sep
11
comment Do you know an easy way to generate one record for each hour of the past 12 hours?
Yeah for number tables - they're all the rage.
Sep
11
revised Does SQL manage foreign key constraints in terms of Insertion?
added 4 characters in body
Aug
23
awarded  Popular Question
Jul
31
revised Location of Maintenance Plan's Back Up Database Tasks information (SQL Server 2005)
added 9 characters in body
Jun
15
awarded  Popular Question
May
15
awarded  Caucus
May
1
awarded  Enlightened
May
1
awarded  Nice Answer
Apr
27
awarded  Yearling
Apr
13
awarded  Nice Question
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
Yeah, sharepoint install makes it a little more fragile for sure.
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
How many databases on your express install? How much work to backup, install fresh, and restore?