SQL is Structured Query Language. SQL is basically a database language primarily designed for managing and manipulating data in DBMS or RDBMS.
DBMS is Database Management System and RDBMS is Relational Database Management System. DBMS and RDBMS both are the procedures to store data in the form of columns and rows. The main difference between both is that in Relational Database Management System we can make a relationship between the tables. In RDBMS we also have an additional feature of putting constraints and ensuring security with regard to data manipulation. SQL Server is referred to as a server that implements Structured Query Language.
Following are the types of SQL Servers:
SQL Server 2000
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2
SQL Server 2000: SQL Server 2000 is a relational database management system that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. It was introduced in 2000 and the code name for this is Shiloh. In 2003 SQL Server 2000 64-bit Edition was introduced and its code name is Liberty.
SQL Server 2005: SQL Server 2005 was released in October 2005. It is the advance version of SQL Server 2000. Its code name is Yukon.
Features of SQL 2005 are:
Multiple Active Results Sets This feature allows usage of database connection for multiple purposes. Also known as MARS.
Provide support for managing XML (Extensible Markup Language) data, in addition to relational data.
Database Mirroring This is the technique of copying data from one location to another (storage device) in real time. With the help of data mirroring we can easily recover critical data.
SQL Server 2008: SQL Server 2008 was released in 2008 and the code name for this is Katmai. SQL Server 2008 comes up with new features for data management these features were:
SQL Server 2008 R2: SQL Server 2008 R2 is the latest available version. The code name for this is Kilimanjaro (aka KJ).
Features of SQL Server 2008 R2 are:
Master data management system or Master Data Services
Multi Server Management
As a SQL Server Consultant and Microsoft Certified Trainer. I provide solution for all the queries related to SQL Server.
For more details please visit: