Microsoft SQL Server Versions and associated code names
There has been so many version of SQL Server launched till date. For most of the version one or other code name has been assigned. This article is all about the till date available code names of the various versions of Microsoft SQL Server.
With passing time Microsoft SQL Server has evolved through numerous versions in the software industry. So many versions has been launched till date starting the one supporting OS/2 to till date version supporting Microsoft operating systems.
SQL Server 1.0\1.1 were designed to work with OS/2 operating systems. Windows NT supported version started with the introduction of SQL Server 4.21.
SQL Server 2005 came with following new things in the bundle:
- XML datatype
- Common Language Runtime (CLR) integration
- Common Table Expression (CTE)
- Multiple Active Results Sets (MARS)
- Dynamic Management Views (DMV)
- Data Mirroring
Whereas SQL Server 2008 added following to the features:
- BLOB datatype to store pictures, audio, video, and other multimedia data
- FILESTREAM data type
- Support for hierarchical data
- Full Text Search functionality
- IntelliSense
SQL Server 2008 R2 got the following features added to the feature stack of SQL Server funactionality and capability:
- Master Data Services
- PowerPivot for Excel and Sharepoint
- Utility Control Point
- Report Builder
Below is the summary of the various versions of Microsoft SQL Server and the associated code names: