In a multi user environment there are 2 models for updating data in a database. They are,
optimistic concurrency
pessimistic concurrency
Types of joins in SQL
See Stackoverflow article
Table naming conventions
http://stackoverflow.com/questions/338156/table-naming-dilemma-singular-vs-plural-names
Following are scenarios for Availability
Log Shipping
Automatically send transaction...
Software Architect at Surge Global/ Certified Scrum Master
Experienced in Product Design, Software Engineering, Team management and Practicing Agile methodologies.
