In essence, SQL Server view can be considered as a “Virtual Table”. When we create a view, user “feel” no…
SQL Server
SQL Server Installation Rules and “System Reboot Required” Error
When we do installation or removing SQL Server, it always executes installation rules. And what really weird is, installer even…
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…
SQL Server and The Models …
Atomicity Consistency Isolation and Durability these are key features of any Database Management System weather its SQL Server, Oracle, MySQL…
Accessing file in filestream using ASP.NET
Like I posted last time, we can use cool feature of SQL Server called “File Stream” which practically allows…
Storing Files in SQL Server using Filestream
As you might have already know that we can use DBMSes to store any sort of data weather its simple…