Maximize the performance and productivity of the premier relational database management system with tools and resources from Microsoft.
Plan, install, maintain, and optimize SQL Server™ 2000, a key Microsoft® .NET Enterprise Server, with expertise from those who know the technology best the SQL Server 2000 product team and Microsoft Consulting Services. This essential kit is packed full of technical details, tools, and utilities to help you maximize the productivity of your enterprise systems, create efficient database applications, and tune the performance of your servers and databases. The MICROSOFT SQL SERVER 2000 RESOURCE KIT includes information about core functionality and new features of SQL Server 2000, plus a CD-ROM full of unique tools and samples. It also covers vital topics such as data warehousing, security, failover clustering, scalability, XML, and digital dashboards. This powerhouse reference is the essential resource for every SQL Server user who seeks maximum performance from SQL Server 2000. Topics covered include:
• PLANNING: Find out what's new in SQL Server 2000; find the SQL Server edition that's right for your organization, and discover the latest information about licensing, upgrades, and migration.
• ADMINISTRATION: Learn the latest about database administration tools and features, and backup and recovery techniques.
• AVAILABILITY AND SCALABILITY: Discover the best way to cluster database applications; learn about data center staffing, facilities, and operations; and find out how to scale applications up and out with various tools.
• REPLICATION: Get answers to common questions, and find out how to create merge-replication custom conflict resolvers in Microsoft Visual Basic®.
• DATA WAREHOUSING: Develop effective data warehouses using expert techniques for design, partitions, data extraction, transformation, and loading.
• ANALYSIS SERVICES: Get practical solutions to real-world business problems using OLAP cubes, Multidimensional Expressions (MDX), data mining, and data access technologies.
• DIGITAL DASHBOARDS: Learn how to build Web portals using the latest SQL Server technology and the digital dashboard framework.
• PERFORMANCE TUNING AND SECURITY: Learn how to tune, optimize, and troubleshoot SQL Server and SQL Serverbased applications for top performance, and get the facts about Microsoft SQL Server 2000 security models.
• XML: Learn how to expose SQL Server data to the Web with XML.