In previous post I explained basics of ISOLATION levels in general. This post is a sort of demo of isolation…
Database
Isolation levels in SQL Server … part I
Just like any reliable transaction system, SQL Server supports ACID properties. If you have never heard of ACID properties before…
WordPress and Database Connection Error …
This week, I changed my WP Blog password and DB Password for that blog as well. And I did it…
Oracle 11g R2 and Windows 7 … dealing with Enterprise Manager Troubles
So, this weekend I thought to refresh my experience with Oracle. And in that attempt, I decided to install latest…
SQL Server Views … to make sure others “view” what you want them to view !!!
In essence, SQL Server view can be considered as a “Virtual Table”. When we create a view, user “feel” no…
Database Normalization … taming the wild horse
For any application to use database and hence data effectively it is very important that data is organized properly. The…
Introduction to Indexing …. and SQL Server
Indexing in simple term can be explained as a pointer to some specific information. It works nearly same as indexes…