Designing SQL Server 2000 Database P2

With this exciting list of features in mind, we begin this book by reviewing thenew and enhanced features of SQL Server 2000 and the migration considerationsfor those of you who are already using previous versions of SQL Server.
Nội dung trích xuất từ tài liệu:
Designing SQL Server 2000 Database P2xxx Introductionand reliability position SQL Server 2000 as the first release to compete in thedemanding markets of terabyte-size solutions and 24 x 7 availability. With this exciting list of features in mind, we begin this book by reviewing thenew and enhanced features of SQL Server 2000 and the migration considerationsfor those of you who are already using previous versions of SQL Server. The bene-fits and simplicity of migrating make this upgrade a practical necessity if yourorganization aims to compete in today’s economy. A review of Microsoft’sDistributed Internet Architecture (DNA) model and the pending evolution toward.NET will help you understand how SQL Server 2000 fits into Microsoft’s vision ofcomplete solutions design. From there, we review the installation options and pro-cedures for SQL Server 2000. New features such as multiple-instance supportallow you to run numerous distinct copies of SQL Server on a single server. Thiscapability is a boon to the growing application service provider market, allowingyou to partition large, expensive servers among multiple customers or applica-tions, each with its own unique configuration. Several versions of SQL Server areavailable to meet both application requirements and budgets. After we get SQL Server 2000 up and running, each chapter examines thecapabilities available in SQL Server. From creating databases to setting up replica-tion to using XML with SQL Server, we work through practical examples so youcan begin using each of these features in your application. Using both graphicalwizards and Transact-SQL statements, you will learn how simple and powerfulworking with SQL Server can be. You will quickly discover that SQL Server 2000 ismore than just a database server; it’s a solution platform. Understanding SQLServer’s capabilities will become critical to designing and delivering your applica-tions in an increasingly demanding market. Whether you are a veteran SQL Server user or you need to get SQL Server upand running for the first time, this book provides you with the insight andinstruction of several authors, each with expertise in his or her area of SQLServer, so that you and your applications can begin enjoying the benefits of SQLServer 2000. www.syngress.com Chapter 1SQL Server 2000Overview andMigration Strategies Solutions in this chapter: s Overview of SQL Server 2000: A .NET Enterprise Server s New and Enhanced Features of SQL Server 2000 s SQL Server 2000 Versions and Requirements s Should You Migrate to SQL Server 2000? s Steps to a Successful SQL Server Migration 12 Chapter 1 • SQL Server 2000 Overview and Migration Strategies Introduction Microsoft Structured Query Language (SQL) Server 2000 is the latest generation of the popular SQL Server product line and the second release since its core reengineering that produced SQL Server 7.0, released in 1999. This latest release of SQL Server adds native Extensible Markup Language (XML) support, enhanced online analytical processing (OLAP), data-mining capabilities, platform support for Windows 2000, integration with Windows 2000 Active Directory, and numerous performance, usability, and programming enhancements. SQL Server 2000 is available in six different editions to meet all levels of application develop- ment and delivery: s SQL Server 2000 Enterprise Edition s SQL Server 2000 Standard Edition s SQL Server 2000 Personal Edition s SQL Server 2000 Developer Edition s SQL Server Desktop Engine (MSDE) s SQL Server 2000 for Windows CE Edition To meet scalability and availability goals, SQL Server 2000 is the first release designed and built to take advantage of Windows 2000 with support for up to 32 processors and 64GB of memory running on Windows 2000 Datacenter Server. Windows 2000 Active Directory integration adds enhanced server and security management features to SQL Server. The latest version of OLAP support, now called Analysis Services, provides numerous wizards for ease of use and the setup of OLAP and new data-mining solutions. One of the more publicized addi- tions to SQL Server is its native support for XML. SQL Server 2000 offers sup- port for storing, using, and updating XML documents—an important requirement because XML becomes the language of choice for many business systems and a fundamental architecture component of Microsoft .NET. SQL Server 2000 is the first released member of the .NET Enterprise Server family and offers numerous advantages to organizations considering migration to this new platform. Enhancements in reliability, scalability, performance, and administration, along with strong compatibility with previous versions, make this release a strong candidate for early adoption into SQL Server 7.0 environments and an immediate migration from organizations running on SQL Server 6.5. Native XML support in SQL Server 2000 will help many organizations begin implementing this technology, which is quickly becoming a standard to both external and internal systems, including e-commerce, Web application services, and line-of-business applications. This chapter discusses the changes in SQL Server 2000 as well as assists you in understanding the direction of Microsoft Windows Distributed interNet Applications (DNA) Architecture Model toward .NET and the role of XML. You will www.syngress.com SQL Server 2000 Overview and Migration Strategies • Chapter 1 3review the available editions of SQL Server 2000 and their features and require-ment ...