Microsoft SQL Server 2005 Developer’s Guide- P1

Microsoft SQL Server 2005 Developer’s Guide- P1:This book is the successor to the SQL Server 2000 Developer’s Guide, whichwas extremely successful thanks to all of the supportive SQL Server developerswho bought that edition of the book. Our first thanks go to all of the peoplewho encouraged us to write another book about Microsoft’s incredible new relationaldatabase server: SQL Server 2005.
Nội dung trích xuất từ tài liệu:
Microsoft SQL Server 2005 Developer’s Guide- P1 Introduction xix Overall, the new features in SQL Server 2005 give it a very high return on investment.Features like web services provide better connectivity to customers, paving the wayto improved profitability. Likewise, XML integration enables better integration withbusiness partners for improved profitability. Additionally, the inclusion of the .NETFramework, improved management tools, and Report Services empower employees,enabling them to be more productive.A Brief History of Microsoft SQL ServerSQL Server 2005 is the latest version of a database server product that has beenevolving since the late 1980s. Microsoft SQL Server originated as Sybase SQLServer in 1987. In 1988, Microsoft, Sybase, and Aston-Tate ported the product toOS/2. Later, Aston-Tate dropped out of the SQL Server development picture, andMicrosoft and Sybase signed a co-development agreement to port SQL Server toWindows NT. The co-development effort cumulated in the release of SQL Server 4.0for Windows NT. After the 4.0 release, Microsoft and Sybase split on the developmentof SQL Server; Microsoft continued forward with future releases targeted for theWindows NT platform while Sybase moved ahead with releases targeted for the UNIXplatform, which they still market today. SQL Server 6.0 was the first release of SQLServer that was developed entirely by Microsoft. In 1996, Microsoft updated SQLServer with the 6.5 release. After a two-year development cycle, Microsoft releasedthe vastly updated SQL Server 7.0 release in 1998. SQL Server 7.0 embodied manyradical changes in the underlying storage and database engine technology used inSQL Server. SQL Server 2000, the accumulation of another two-year developmenteffort, was released in September of 2000. The move from SQL Server 7.0 to SQLServer 2000 was more of an evolutionary move that didn’t entail the same kindsof massive changes that were made in the move from 6.5 to 7.0. Instead, SQLServer 2000 built incrementally on the new code base that was established in the 7.0release. Starting with SQL Server 2000, Microsoft began releasing updates to thebasic release of SQL Server in the following year starting with XML for SQL ServerWeb Release 1, which added several XML features including the ability to receive aresult set as an XML document. The next year they renamed the web release to themore succinctly titled SQLXML 2.0, which, among other things, added the abilityto update the SQL Server database using XML updategrams. This was quicklyfollowed by the SQLXML 3.0 web release, which included the ability to exposestored procedures as web services. Two years later, Microsoft SQL Server releasehistory cumulates with the release of SQL Server 2005. SQL Server 2005 uses thesame basic architecture that was established with SQL Server 7 and it adds to thisxx M i c r o s o f t S Q L S e r v e r 2 0 0 5 D e v e l o p e r ’s G u i d e all the features introduced with SQL Server 2000 and its web releases in conjunction with the integration of the .NET CLR and an array of powerful new BI functions. The following timeline summarizes the development history of SQL Server: 1987 Sybase releases SQL Server for UNIX. 1988 Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2. 1989 Microsoft, Sybase, and Aston-Tate release SQL Server 1.0 for OS/2. 1990 SQL Server 1.1 is released with support for Windows 3.0 clients. Aston-Tate drops out of SQL Server development. 1991 Microsoft and IBM end joint development of OS/2. 1992 Microsoft SQL Server 4.2 for 16-bit OS/2 1.3 is released. 1992 Microsoft and Sybase port SQL Server to Windows NT. 1993 Windows NT 3.1 is released. 1993 Microsoft and Sybase release version 4.2 of SQL Server for Windows NT. 1994 Microsoft and Sybase co-development of SQL Server officially ends. Microsoft continues to develop the Windows version of SQL Server. Sybase continues to develop the UNIX version of SQL Server. 1995 Microsoft releases version 6.0 of SQL Server. 1996 Microsoft releases version 6.5 of SQL Server. 1998 Microsoft releases version 7.0 of SQL Server. 2000 Microsoft releases SQL Server 2000. 2001 Microsoft releases XML for SQL Server Web Release 1 (download). 2002 Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server). 2002 Microsoft releases SQLXML 3.0. 2005 Microsoft releases SQL Server 2005 on November 7th, 2005. CHAPTER The Development 1 Environment IN THIS CHAPTER SQL Server Management Studio BI Development Studio 1Copyright © 2006 by The McGraw-Hill Companies. Click here for terms of use.2 M i c r o s o f t S Q L S e r v e r 2 0 0 5 D e v e l o p e r ’s G u i d e W hen it comes to server management, a lot has changed for the DBA ...