SQL%20Server:%20Past,%20Present,%20and%20Future

1
SQL ServerPast, Present, and Future

• Dave Fackler
• President, Atlanta.MDF
• Director, Intellinet Corporation

2
Agenda

• The past SQL Server 1.0, 4.2, 6.0, 6.5
• The present SQL Server 7.0, 2000
• The future The Yukon Wave

3
The Past
4
The Past SQL Server 1.0

• Deal forged between Sybase and Microsoft on March
  27, 1987
• SQL Server 1.0 released for OS/2 only
• SQL Server 1.1 added Windows 3.0 support for the
  client tools only
• Sybase maintained code-base while Microsoft
  provided sales and support

5
The Past SQL Server 4.2

• Released in 1992
• Support added for Windows NT
• Minor GUI tools
• Most administration, DBA work done via
  command-line interface (isql)
• Microsoft took over code-base, slowly rewriting
  kernel functions to fix bugs

6
The Past SQL Server 6.0

• Released in June 1995
• Focused on replication and usability
• Enterprise Manager introduced
• Scrollable cursors
• DBA challenges
• Modifying table designs
• Referential integrity

7
The Past SQL Server 6.5

• Released in April 1996
• Row-level locking during INSERT
• ANSI syntax additions
• SQL Trace added
• Backup of individual tables
• Web Assistant Wizard
• Still lots of challenges

8
The Present
9
The Present SQL Server 7.0

• Development began in 1995
• Beta 2 released in December 1997
• Beta 3 released in June 1998
• Full launch in November 1998
• Complete rewrite of database engine, query
  optimizer, management tools

10
The Present SQL Server 7.0

• Server improvements and new features
• Improved administration tools
• Architecture enhancements
• Server/development enhancements
• Data Transformation Services
• OLAP Services

11
The Present SQL Server 2000

• Development began in 1999
• Released in August 2000
• Often referred to as SQL Server 7.5 or 8.0
• Surpassed most industry expectations
• Benchmarks
• Scalability/reliability
• Feature use (DTS, Analysis Services)

12
The Present SQL Server 2000

• Relational database enhancements
• XML integration
• Administration tools enhancements
• Replication improvements
• DTS improvements
• Analysis Services improvements
• Meta Data Services and English Query

13
The Future(Tell us about Yukon!)
14
The Future Yukon

• Storage server for all Microsoft Servers
• Is WSS dead?
• Support for file-system functions
• Support for .NET
• Common Language Runtime
• XML support
• Shared-nothing clustering