Sql Server – Introduction
SQL Server is a relational database management system produced by Microsoft. It supports a superset of Structured Query Language SQL, the most common database language. It is commonly used by businesses for small to medium sized databases, and in the past 5 years large enterprise databases, and competes with other relational database products for this market segment.
SQL Server is easy to manage and provides a separate OLAP engine. It is the ideal database for web applications written in Asp/Asp.Net as well. SQL Server currently runs only on the Windows operating systems, no plans for porting it to other platforms has been disclosed.
Histrory of SQL Server
Microsoft SQL Server (prior to version 7.0) originated in Sybase SQL Server, and was Microsoft’s entry to the enterprise-level database market, competing againstOracle, IBM and, later,Sybase itself. Microsoft, Sybase and Ashton-Tate originally teamed up to create and market the first version named SQL Server 1.0 for OS/2 which was essentially the same as Sybase SQL Server 3.0 on Unix VMS, etc. Microsoft SQL Server 4.2 was shipped around 1992. Later Microsoft SQL Server 4.21 for Windows NT was released at the same time as Windows NT 3.1. Microsoft SQL Server v6.0 was the first version of SQL Server that was architected for NT and did not include any direction from Sybase.
The current version, Microsoft SQL Server 2005, was released in November of 2005. The launch took place alongside Visual Studio 2005 and Biz Talk Server 2006
Features of SQLServer:
- Data Partitioning
Data partitioning will be enhanced with native table and index partitioning that enables efficient manageability of large tables and indexes.
- Replication Enhancements
For distributed databases, SQL Server 2005 provides comprehensive schema change (DDL) replication, next-generation monitoring capabilities, built in replication from Oracle to SQL Server, merge replication over https, and significant merge replication scalability and performance improvements. Additionally, the new peer-to-peer transactional replication feature improves support for data scale out using replication.
- Security Enhancements
SQL Server 2005 includes security enhancements such as database encryption, secure default settings, password policy enforcement, fine grained permissions control, and an enhanced security model.
- Fast Recovery
new faster recovery option will improve availability of SQL Server databases. Administrators will be able to reconnect to a recovering database after the transaction log has been rolled forward