Last week I blogged about use of Views in SQL Server. We also saw different types of view and best…
SQL Server
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…
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…
Creating Database in SQL Server 2008
Database can be explained as a just single file, which is used to store data properly and which gives us…