SQL Server

Re-Publish this Article

<h1>SQL Server</h1><strong> Author: <a href='http://www.articleseen.com/profile_Sqlserver22.aspx'>Sqlserver22</a></strong><br /><p> 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: Self organizing Self tuning Self maintaining 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 </p><strong>About the Author:</strong><br />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: <p><a rel="nofollow" href="http://blog.sqlauthority.com/">SQL SERVER</a> <p><a rel="nofollow" href="http://blog.sqlauthority.com/sql-training-performance-optimization-tuning/">SQL Server Performance</a> <p><a rel="nofollow" href="http://blog.sqlauthority.com/contact-me/">SQLAuthority</a> <p><a rel="nofollow" href="http://blog.sqlauthority.com/sql-health-check/">SQL Server Consultant</a> <p><a hr<p> Article Source: <a href='http://www.articleseen.com/Article_SQL-Server_45510.aspx'> http://www.articleseen.com/Article_SQL Server_45510.aspx</a></p>

Article Source : http://www.articleseen.com/Article_SQL Server_45510.aspx

Keywords : SQL SERVER, sQL Server Performance, SQLAuthority, SQLAuthority, SQL Server Performance,

Category : Arts and Entertainment : Arts and Entertainment