Programming Languages Trend 2017, JavaScript is the king now.

Difference between Lazy Loading and Eager Loading

Difference between Lazy Loading and Eager Loading

http://www.dotnet-tricks.com/Tutorial/entityframework/RIWW210913-Difference-between-Lazy-Loading-and-Eager-Loading.html

Table Valued Parameters in SQL Server

Table Value Parameters in SQL Server


www.sqlteam.com/article/sql-server-2008-table-valued-parameters

Multiple Insert, update in C# SQL server

Multiple Insert, update in C# SQL server

https://msdn.microsoft.com/en-us/library/aadf8fk2.aspx

Application pools in IIS

Application pools in IIS

An application pool is a group of one or more URLs that are served by a worker process or a set of worker processes. Application pools set boundaries for the applications they contain, which means that any applications that are running outside a given application pool cannot affect the applications in the application pool.

Application pools offer the following benefits:

• Improved server and application performance. You can assign resource-intensive applications to their own application pools so that the performance of other applications does not decrease.
  
• Improved application availability. If an application in one application pool fails, applications in other application pools are not affected.
  
• Improved security. By isolating applications, you reduce the chance that one application will access the resources of another application.

Database currently using by Market leader

Database currently using by Market leader

Google - Bigtable

LinkedIn.com -
Oracle (Relational Database)MySQL (Relational Database

Stack Overflow - SQL Server.

Flickr uses MySQL.

YouTube uses MySQL but they are moving to Google's BigTable.

Myspace uses SQL Server.

Wikipedia uses MySQL.


Facebook.com

Hive (Data warehouse for Hadoop, supports tables and a variant of SQL called hiveQL). Used for "simple summarization jobs, business intelligence and machine learning and many other applications"

Cassandra (Multi-dimensional, distributed key-value store). Currently used for Facebook's private messaging.

POST vs PUT in Rest

POST vs PUT in Rest 

Example :

"POST /books" with a bunch of book information might create a new book, and respond with the new URL identifying that book: "/books/5".

"PUT /books/5" would have to either create a new book with the id of 5, or replace the existing book with ID 5.

In non-resource style, POST can be used for just about anything that has a side effect. One other difference is that PUT should be idempotent - multiple PUTs of the same data to the same URL should be fine, whereas multiple POSTs might create multiple objects or whatever it is your POST action does.