SQL Server History.pptx

SQL History

1. 1 Brief History to MSSQL 1 SQL Server Services 4 Versions of SQL Server 3 Editions of SQL Server 1

2. 2 Brief History To MSSQL Server 1

3. A Brief History to MSSQL Server MS SQL Server is a relational database engine which works only on windows platforms . 1989 : Microsoft SQL Server version 1.0 ships 1990: Microsoft SQL Server version 1.1; it runs on Windows 3.0 1992: SQL Server 4.2 released 1993: Windows NT 3.1 and SQL Server for Windows NT released (32-bit) 1994: Microsoft/Sybase partnership ends 1995: SQL Server 6.0 1996: SQL Server 6.5 1999: SQL Server 7.0 – major rewrite 2000: SQL Server 2000 2005: SQL Server 2005 2008: SQL Server 2008 2010: SQL Server 2008R2 2012: SQL Server 2012 2014: SQL Server 2014 2016: SQL Server 2016

4. 4 SQL Server Versions 4

5. Version and Service pack Information 5 MS SQL SERVER RTM SP1 SP2 SP3 SP4 SQL SERVER 2016 13.0.1601.5 SQL SERVER 2014 12.0.2000.8     12.0.4100.1   12.0.5000.0     SQL SERVER 2012  11.0.2100.60   11.0.3000.   11.0.5058.0   11.0.6020.0   SQL SERVER 2008R2 10.50.1600.1 10.50.2500 10.50.4000   10.50.6000.34   SQL SERVER 2008 10.00.1600.22 10.00.2531 10.00.4000 10.00.5500   10.0.6000.29 SQL SERVER 2005 9.00.1399.06 9.00.2047 9.00.3042 9.00.4035 9.00.5000 SQL SERVER 2000 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039 SQL SERVER 7.00.623 7.00.699 7.00.842 7.00.961 7.00.1063

6. 6 Editions of SQL Server 3

7. SQL SERVER Services Editions Enterprise Edition Standard Edition Business Intelligence Edition Express Edition Development Edition

8. 8 SQL Server Services 4

9. SQL SERVER Services Instance-Specific Instance-unaware (one service per instance) : SQL Server SQL Server Agent Analysis Services Reporting Services Full-Text Search Notification Services Integration Services SQL Server Browser SQL Server Active Directory Helper SQL Writer

10. 10 SQL Server Admin Tools 5

11. SQL Server Admin Tools SQL Server Management Studio Database management GUI Object browser; templates, reports, etc. Based on Visual Studio 2005 IDE Support for writing and executing queries SQL Business Intelligence Dev. Studio Analysis Services, Reporting Services, SSIS SQL Server Profiler Database Engine Tuning Advisor SQL Server Configuration Manager Manages services and protocols Surface Area Configuration SQL Server Books Online