Mainstream support ended on April 8, 2008, and extended support ended on April 9, 2013. The first release of SQL IA-64 was version 8.00.760, with a build date of February 6, 2003. Client tools, such as SQL Server Management Studio, were still 32-bit x86 programs. Only the SQL Server relational engine and SQL Agent were ported to Itanium at this time. With the release of Service Pack 3, Microsoft also released the first 64-bit version of the SQL Server for the Itanium IA-64 platform (not to be confused with the x86-64 platform). SQL Server 2000 also introduced many T-SQL language enhancements, such as table variables, user-defined functions, indexed views, INSTEAD OF triggers, cascading referential constraints and some basic XML support. several messaging technologies, specifically Service Broker and Notification Services.an OLAP and data mining server ( Analysis Services).SQL Server Reporting Services (SSRS), or "Reporting Server".an extract-transform-load (ETL) tool (initially called Data Transformation Services or DTS, and later called SQL Server Integration Services, or SSIS).Since the release of SQL Server 2000, advances have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005. By SQL Server 2005 the legacy Sybase code had been completely rewritten. SQL Server 2000 included more modifications and extensions to the Sybase code base, adding support for the IA-64 architecture (now out of "mainstream" support ). Mainstream support ended on December 31, 2005, and extended support ended on January 11, 2011. Although there were pre-release versions of SQL 2000 (as well as Windows 2000) compiled for Alpha, these were canceled and were never commercially released. SQL Server 7.0 would be the last version to run on the DEC Alpha platform. SQL Server 7.0 also introduced a multi-dimensional database product called SQL OLAP Services (which became Analysis Services in SQL Server 2000). User Mode Scheduling (UMS) was introduced to handle SQL Server threads better than Windows preemptive multi-threading, also adding support for fibers (lightweight threads, introduced in NT 4.0, which are used to avoid context switching ). Extents thereby grew from 16k bytes to 64k bytes. Data pages were enlarged from 2k bytes to 8k bytes. SQL Server 7.0 was a major rewrite (using C++) of the older Sybase engine, which was coded in C. SQL Server 7.0 SQL Server 7.0 Splash Screen (In 1996 Sybase changed the name of its product to Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server.) Until 1994, Microsoft's SQL Server carried three Sybase copyright notices as an indication of its origin. Microsoft negotiated exclusive rights to all versions of SQL Server written for Microsoft operating systems. SQL Server 6.0 was the first version designed for NT, and did not include any direction from Sybase.Ībout the time Windows NT was released in July 1993, Sybase and Microsoft parted ways and each pursued its own design and marketing schemes. SQL Server 4.2 was shipped in 1992, bundled with OS/2 version 1.3, followed by version 4.21 for Windows NT, released alongside Windows NT 3.1. This was the first version of Microsoft SQL Server, and served as Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, Informix, Ingres and later, Sybase. On June 12, 1988, Microsoft joined Ashton-Tate and Sybase to create a variant of Sybase SQL Server for IBM OS/2 (then developed jointly with Microsoft), which was released the following year. Legend: Old version Older version, still maintained Latest versionĭetailed history Genesis Older version, yet still maintained: January 8, 2030 Older version, yet still maintained: January 14, 2025 Older version, yet still maintained: October 12, 2027 Old version, no longer maintained: October 11, 2022 Older version, yet still maintained: July 14, 2026 Old version, no longer maintained: July 13, 2021 Older version, yet still maintained: July 9, 2024 Old version, no longer maintained: July 12, 2022 Old version, no longer maintained: July 11, 2017 Old version, no longer maintained: July 9, 2019 Old version, no longer maintained: July 8, 2014 Old version, no longer maintained: April 12, 2016 Old version, no longer maintained: April 12, 2011 Old version, no longer maintained: April 9, 2013 Old version, no longer maintained: April 8, 2008 Old version, no longer maintained: January 11, 2011 Old version, no longer maintained: December 31, 2005 The history of Microsoft SQL Server begins with the first Microsoft SQL Server database product – SQL Server v1.0, a 16-bit relational database for the OS/2 operating system, released in 1989.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |