|SQL - Structured Query Language|
History of SQL Server
MS SQL Server is a Relational Database Management System that originated from Sybase SQL Server. Microsoft, Sybase and Ashton-Tate companies are formed a Joint Venture Team and marketed Sybase?s SQL Server from version 1.0 to 3.0 that running on UNIX and VMS Operating System.
When, Microsoft published Window NT operating system, Sybase and Microsoft companies are parted and applied their own design pattern and marketing plan. Microsoft received exclusive rights of SQL Server from Sybase and concentrated to deploy SQL Server with Window NT Operating System and then published MS SQL Server version 4.21 in 1993.
Sybase adapted many features in the original SQL Server and deploy with UNIX and other operating system and then published "Adaptive Server Enterprise" to avoid confusion with MS SQL Server. 1998, Microsoft published MS SQL Server version 7.0 that rewrite from the legacy Sybase SQL Server code.
1999, Data Transmission Service (OLAP) Tool Application deploy with MS SQL Server 7.0 to communicate multiple Database with MS SQL Server 7.0. 2000, Microsoft published MS SQL Server 2000 that adapted with IA-64 (Intel Architecture) to enhance the Enterprise Database Operation and Performance.
2005, Microsoft published MS SQL Server 2005 with ETL , SQL Server Integration Services (SSIS), SQL Server Reporting Server (SSRS), SQL Server Analytical Service (SSAS), OLAP Data Mining and Messaging Technologies.
Microsoft implemented XML feature with MS SQL Server 2005 through XML Data Type. XML format data internally converted into binary data type to manage XML data in the RDBMS that stored data retrieve through XQuery.
Common Language Runtime (CLR) integration was a main feature of MS SQL Server 2005 that allows a database server to be exposed over web services using TDS packets encapsulated with SOAP Protocol requests. When the data is accessed over web services, results are returned in XML File Format.
2008, Microsoft published MS SQL Server 2008 that deployed with ADO.NET Entity Framework, Full-Text Search functionality, Support SQL Server Reporting Services, Notion of Filtered Indexes, SQL Server Management Studio, Windows PowerShell and etc.,
2010, Microsoft published MS SQL Server 2008 R2 that deployed with Master Data Service to manage Master Data Management (MDM) System. Visual Studio Data-tier Function, PowerPivot for Excel, SharePoint and ReportBuider components are adapted with MS SQL Server R2 to manage OLTP and OLAP Database.
More Reference URL
* * * * *