Author Archives: Obi Oberoi

About Obi Oberoi

I am Technology Aficionado who has a passion for learning, speaking, blogging and hanging out with geeks and like minded people!

What is the difference between Delete and Truncate

To order essay on an author of the essay not only that but safely. Our exchange provides a number of obligations, which guarantee customers that they will receive a high quality and decent work: each essay is checked by the … Continue reading

Posted in SQL Server | Comments Off on What is the difference between Delete and Truncate

What are Nested Transactions in SQL Server?

As the name suggests, nested transaction is one that is nested within a transaction. Let’s illustrate this with an example. Let’s create a table: CREATE TABLE PERSON ( ID INT IDENTITY(1,1), FirstName VARCHAR(25), LastName VARCHAR(25), Gender CHAR(1) ) SELECT * … Continue reading

Posted in SQL Server | Comments Off on What are Nested Transactions in SQL Server?

How to partition the result set in SQL Server

To query the first row or the last row in a table is easy-piecey.  You simply select the Top 1 row and order the query by ascending or descending. But, how about selecting the second, third or tenth row from … Continue reading

Posted in SQL Server | Comments Off on How to partition the result set in SQL Server

What is IDENTITY value and how does it work?

An IDENTITY is a system function that returns the last-inserted identity value. Let’s try it out in SQL Server Management Studio. Let’s create a table called Person with it’s IDENTITY starting position set to 1 with an increment value of … Continue reading

Posted in ORM | Comments Off on What is IDENTITY value and how does it work?

What is Mongo DB and why should you use it!

The word Mongo is derived from the world humongous. So in essence, it implies that its sole purpose is to store mammoth amounts of data or what is otherwise coined as ‘big data’. MongoDB is a document oriented database unlike … Continue reading

Posted in NoSQL | Comments Off on What is Mongo DB and why should you use it!

Are stored procedures pre-compiled?

Contrary to the popular belief that a stored procedure is pre-compiled when created is not true. In fact, stored procedure is compiled on the first run or the time when the stored procedure is first executed. more to come…

Posted in ORM | Comments Off on Are stored procedures pre-compiled?

What is Managed and Unmanaged Code?

Managed Code: The .NET framework provides several core run-time services to the programs that run within it. For example; Exception Handling and Security. In order for these services to work, the code must provide a minimum level of information to … Continue reading

Posted in .NET | Leave a comment

Repository Pattern

The Repository Pattern is used to separate the logic that retrieves the data and maps it to the entity model from the business logic that acts on the model. The repository acts as a mediator between the data source layer … Continue reading

Posted in .NET | Comments Off on Repository Pattern

How to handle Many-to-Many Relationship in EF Core

There are a few steps that are instrumental in handling a Many-to-Many relationship in EF Core. It must be noted that EF Core 1.1 does not support Many-to-Many relationship right off the bat. However, with a junction table in hand, … Continue reading

Posted in ORM | Comments Off on How to handle Many-to-Many Relationship in EF Core

What are Design Patterns in modern software development

BitStarz is such casinos with Western flair. They first conquered the Western market, and then decided to return to roots. Casino has positioned itself as one of the first bitcoins (still in 2014) and now regularly enters the news with … Continue reading

Posted in ORM | Comments Off on What are Design Patterns in modern software development