Object Oriented Concepts Every Dummy Must Know

Abstraction Abstraction is Only showing what is necessary and encapsulating (hiding) unnecessary parts.  If you take a car you interact with it using abstractions  you use gas pedal, steering wheel which hides internal details It is keeping a clear separation between abstract properties of a data type and the concrete details of its implementation.  It...

Read More

SOLID Principles

SOLID is acronym used for 5 design principles for object oriented programming. Below we'll look at what they are Single Responsibility principle Every class should have only one responsibility. This responsibility should be totally encapsulated by the class. see wikipedia, this, OODesign, not so SOLID OO Principles. Open/Closed principle Software entities should be open for extension, but...

Read More

Exception handling basics

Exceptions happens when a member cannot successfully do what it's designed to do. Exceptions can be generated by CLR, 3rd party library or by user code using throw keyword. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor...

Read More

...

Read More

Pessemestic vs Optimistic Concurrency Control

Best explained using diagrams Resources http://www-01.ibm.com/support/knowledgecenter/SSPK3V_6.3.0/com.ibm.swg.im.soliddb.sql.doc/doc/pessimistic.vs.optimistic.concurrency.control.html http://stackoverflow.com/questions/129329/optimistic-vs-pessimistic-locking?lq=1 http://www.toadworld.com/platforms/oracle/b/weblog/archive/2014/10/03...

Read More

Database concepts

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...

Read More