1,670 reputation
623
bio website
location Denver, CO
age 38
visits member for 2 years, 11 months
seen Mar 26 at 22:30

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
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?
Mar
8
comment Delete a variable number of records by a chronological order
Also, I was trying to get around deprecation with the sub select but it's a nil issue now. Thanks again.
Mar
8
accepted Delete a variable number of records by a chronological order
Mar
8
comment Delete a variable number of records by a chronological order
Apparantly I didn't get the memo about using parenthesis. Thank you SQL2005. Awesome.
Mar
8
revised Delete a variable number of records by a chronological order
deleted 9 characters in body