Microsoft Corporation created the RDBMS (relational database management system) known as Microsoft SQL Server. For the OS/2 operating system, SQL Server's initial version was launched in 1989. Microsoft launched SQL Server for the Windows operating system in 1993.
Versions of SQL listed by year of release:
The initial release of SQL Server, version 1.0, was made available in 1989 for the OS/2 operating system.
This version, SQL Server 4.2, was made available for the Windows NT operating system in 1992.
The 1995 release of SQL Server 6.0 by Microsoft includes stored procedures, triggers, and views that make it easier for programmers to accomplish their work.
After restructuring, Microsoft released SQL Server 7.0, which included OLAP and data warehousing ideas.
XML support and indexed views, among other new capabilities, were added with the introduction of SQL Server 2000 (available in 2000).
After substantial security, scalability, and availability enhancements, Microsoft released SQL Server 2005 (Released in 2005). Additionally, improved XML and the.NET framework have been incorporated.
New Concepts introduced in SQL Server 2005 version:
1. Integration Services (SSIS): A platform for creating data integration and workflow applications is called Integration Services (SSIS).
2. Common Language Runtime (CLR) Integration: The ability to create stored procedures, triggers, and functions in .NET languages with Common Language Runtime (CLR) Integration.
3. Service Broker: A messaging architecture for creating scalable and dependable database applications is called a service broker.
4. Database Mirroring: A high-availability feature for ongoing data availability is database mirroring.
This version of SQL Server 2008 provides geographic data, data compression, and policy-based management (released in 2008).
New Concepts introduced in SQL Server 2008 version:
1. Policy-Based Management: Policy-based management is a system for managing and enforcing policies on SQL Server instances.
2. Transparent Data Encryption: The capacity to encrypt database files while they are at rest, enhancing security, is known as transparent data encryption.
3. Resource Governor: Enables resource allocation and workload management to various programs or users.
4. FILESTREAM: Allows massive binary data to be stored and managed on the file system, outside of a database.
This version of SQL Server 2008 R2 (Released In 2010) supports Master Data Services, the PowerPivot add-in, and other BI features.
Columnstore indexes and AlwaysOn Availability Groups are included in the 2012 edition of SQL Server (Released In 2012) by Microsoft.
New Concepts introduced in SQL Server 2012 version:
1. AlwaysOn Availability Groups: Enables numerous backup replicas for high availability and disaster recovery.
2. Columnstore Indexes: A columnar storage structure that enhances the efficiency of queries on huge datasets.
3. SQL Server Data Tools (SSDT): Database development environment integrated with SQL Server Data Tools (SSDT).
4. SQL Server Analysis Services (SSAS) Tabular Model: Analysis Services for SQL Server (SSAS) The tabular model uses an in-memory analytics engine to handle data more quickly.
