SQL Server Magazine Is 10 Years Old!

Abstract

The new code base gave SQL Server 7.0 the enterprise scalability that previous versions lacked and, combined with the innovative idea of including business intelligence (BI) capabilities in the form of OLAP Services, catapulted SQL Server to the front of the BI industry. OLAP Services became SQL Server Analysis Services (SSAS), and Microsoft added data mining. SQL Server 2005 added support for SQL Server CLR, a native XML data type, and a new VARBINARY(MAX) data type for large object storage.

Although it hardly seems possible, this issue marks the tenth anniversary of SQL Server Magazine. As long-time readers will remember, we launched the magazine in the SQL Server 7.0 timeframe. Back in 1998, SQL Server was a distant third in the enterprise database market and was regarded as a small-scale departmental database- easy to use but not ready for the enterprise. How things have changed.

SQL Server 7.0: Re-Architecture

The release of SQL Server 7.0 marked the ascension of SQL Server into the enterprise. Microsoft brought in a core group of experienced database designers who rewrote the old Sybase code that was the basis of earlier releases. As David Campbell, Microsoft Technical Fellow in the Data and Platform division, said last year, "A bunch of us came to Microsoft from different database experiences. We had guys who worked on IBM DB2, Tandem, Oracle, Sybase, Informix. We landed at Microsoft in 1994, 1995, and 1996, and we started the effort to re-architect SQL Server. The first version was SQL Server 7.0." The new code base gave SQL Server 7.0 the enterprise scalability that previous versions lacked and, combined with the innovative idea of including business intelligence (BI) capabilities in the form of OLAP Services, catapulted SQL Server to the front of the BI industry.

SQL Server 2000: Evolution

Released in September 2000, SQL Server 2000 was an evolutionary release. OLAP Services became SQL Server Analysis Services (SSAS), and Microsoft added data mining. In addition, Microsoft introduced support for multiple instances, federated servers, and distributed partitioned views. The SQL Server team took its first steps on the path toward XML integration with support for XML Views and OPENXML. SQL Server 2000 firmly established SQL Server as an enterprise player.

SQL Server 2005: The BI Revolution

Five years later, Microsoft released SQL Server 2005, which could be called the BI release. All of SQL Server's BI functionality benefited from upgrades. DTS was replaced by the new enterprisecapable SQL Server Integration Services (SSIS). SSAS was revamped with the new Unified Dimensional Model. SQL Server 2005 added support for SQL Server CLR, a native XML data type, and a new VARBINARY(MAX) data type for large object storage. Service Broker and SQL Server Reporting Services (SSRS) subsystems were also added. Without a doubt the most important element, SSRS was embraced by businesses everywhere.

SQL Server 2008: The Database Platform

SQL Server 2008 marked SQL Server's transition from a relational database to an enterprise data platform. Released to manufacturing in August 2008, SQL Server 2008 moved to make database data available throughout the enterprise. For better management, Microsoft added Resource Governor, policy- based management, and database compression. The addition of transparent database encryption improved security. For development, SQL Server 2008 has LINQ, the .NET Entity Framework, spatial data types, and FILESTREAM support. For BI there are all-new cube and dimension designers, as well as Report Builder and Microsoft Office integration. Feature-wise, SQL Server 2008 is a leader in the database market.

Nonstop Passion for SQL Server

Here at SQL Server Magazine we've had the pleasure of covering all these developments over the past ten years. I know I speak for everyone at the magazine when I say that we're fortunate and proud to work with the best SQL Server experts and authors in the industry. Our editors and contributing writers are dedicated to serving the needs of the SQL Server community and providing the best independent technical SQL Server information available. Following SQL Server for the past 10 years has been a terrific ride. We all know that SQL Server is the greatest database around and that the best is yet to come.

InstantDoc ID 101068