1 / 14

SQL Server: Past, Present, and Future

SQL Server: Past, Present, and Future. Dave Fackler President, Atlanta.MDF Director, Intellinet Corporation. 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. The Past. The Past: SQL Server 1.0.

verdad
Download Presentation

SQL Server: Past, Present, and Future

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server:Past, 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

More Related