325 reputation
39
bio website
location
age 56
visits member for 3 years, 7 months
seen 12 hours ago

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


Mar
23
answered Getting to know my way around a database with hundreds of tables
Mar
10
answered how best structure localization of content type category name
Mar
3
awarded  Commentator
Mar
3
comment Managing different Return Types when calling a Stored Procedure in Entity Framework
Why not include the extra columns as part of your regular result set and set them to null or zero if they are not filled by procedure?
Feb
23
comment Reproducing a bug in production that happens with a large database
Deadlocks can be caused by poorly written SQL in the application or ORM. Some schema designs don't scale well. More information is required.
Jan
19
comment Large volume report operations, how best to replicate transactional data
Or in oracle a standby database open in read only mode. This gives you reporting as of "point in time"
Dec
15
revised Approaches for manage AD users inside my HR system
added 640 characters in body
Dec
15
revised Approaches for manage AD users inside my HR system
added 277 characters in body
Dec
15
awarded  Editor
Dec
15
revised Approaches for manage AD users inside my HR system
added 723 characters in body
Dec
15
comment Approaches for manage AD users inside my HR system
which database product are you using for your datastore?
Dec
15
answered Approaches for manage AD users inside my HR system
Dec
11
comment Best approach for storing huge data
How many concurrent users at once? Do you have a hardware budget?
Sep
24
awarded  Autobiographer
Jan
10
comment Where does Windows Workflow Foundation fit into the messaging oriented middleware architecture?
I agree, the workflow I have to maintain is hard to maintain, hard to document and hard to extend.
Dec
13
suggested rejected edit on
Jun
21
comment Over normalization in database
I think this is being worked on for the millions of people who do not have an address at all. Their GPS co ordinates are being considered given that they are offer precision to within 30 feet
Mar
7
awarded  Quorum
Feb
26
awarded  Caucus
Feb
26
awarded  Constituent