1,771 reputation
726
bio website
location Denver, CO
age 39
visits member for 3 years, 7 months
seen yesterday

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.


Jun
11
comment Are SQL Server's Date values stored as a single int?
now that is nerdilicious +1
Jun
8
awarded  Caucus
Jun
1
revised how to config SSRS 2005 email setting with google apps
added 174 characters in body
Jun
1
answered how to config SSRS 2005 email setting with google apps
May
18
accepted Resource Waits: Mathematical link between Wait Time and Average Waiter Count
May
18
accepted Can you edit the context menu options?
May
18
comment Can you edit the context menu options?
I also agree with your answer... but in this case the rights are part of the job description, we're just brainstorming in a after action mindset here.
May
18
comment Can you edit the context menu options?
+1 for the empathy :)
May
18
comment Can you edit the context menu options?
This is a case where the rights are granted, and must remain due to the fact that its a single tech at a remote center. A do-it-all guy for the operation. We follow your model here at our main office. For example my network login does little, I have another login with .sup on the end that does more. We have a third login that does it all. But in this case - our choices are limited as he regularly needs to do maintenance on the subscriptions (including deleting old adding new). The publication was killed on accident however and that's what I'd like to avoid again.
May
18
asked Can you edit the context menu options?
May
1
accepted Re-subscribing to a merge publication after edits made offline
Apr
30
comment Re-subscribing to a merge publication after edits made offline
+1 for pointing me to the tablediff utility - I was not aware of it. That should prove to be very useful.
Apr
30
revised Re-subscribing to a merge publication after edits made offline
Improved question title
Apr
28
revised Re-subscribing to a merge publication after edits made offline
added 69 characters in body
Apr
28
asked Re-subscribing to a merge publication after edits made offline
Apr
27
awarded  Yearling
Feb
16
accepted Controlling the order in which merge articles are applied by snapshot at initialization?
Feb
16
revised Controlling the order in which merge articles are applied by snapshot at initialization?
added 339 characters in body
Feb
16
asked Controlling the order in which merge articles are applied by snapshot at initialization?
Feb
2
comment Is it Possible to have Multiple Named Instances with No Default Instance?
yes - you can -