Author Archives: ooberoi

How to check if nested brackets are in the correct logical order

I am starting a series of blog posts on algorithms and data structures with the first one being the easiest! Q. Write a method that checks if the nested brackets are in the correct logical order. The input string is … Continue reading

Posted in Algorithms & Data Structures | Comments Off on How to check if nested brackets are in the correct logical order

What package(s) do I need for EF Core 2.x?

First off, it is important to note that there are a couple of ways to download package(s). 1. You can use NuGet right from inside Visual Studio IDE 2. You can also use CLI (Command Line Interface) Here, I’ll demonstrate … Continue reading

Posted in ORM | Comments Off on What package(s) do I need for EF Core 2.x?

Mongo DB and .NET

This is my last blog post of the year 2017 where I am going to showcase how you can make the .NET application talk to a Mongo DB. Just a quick recap…MongoDB is a document database that stores data in … Continue reading

Posted in NoSQL | Comments Off on Mongo DB and .NET

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