Showing posts from May, 2013

Introduction to MS SQL Server

In the task management software which we will be discussion in my upcoming posts, I used MS SQL server for database management. In this post I am going to discuss an introduction of MS SQL server.
MS SQL server is a relational database management system developed by Microsoft. MS SQL server uses SQL as its standard database language.
A relational database management system is a means of storing information in such a way that information can be retrived from it. In simplest terms, a relational database is one that present information in tables with rows and columns. A table is referred to as a relation in the sense that it is a collection of objects of same type (rows). Data in a table can be related according to common keys or concepts, and ability to retrive related data from a table is the basis for the term relational database.
MS SQL server was designed to have many hundreds, or even thousands of users accessing it at any point in time. SQL server also contains some advanced data…