The next-generation database for the Business Internet, Microsoft SQL Server 2000 is the fastest way to deliver the next generation of scalable Web applications with Windows DNA. It dramatically reduces the time required to bring e-commerce, data warehousing, and line-of-business appications to market, while offering the scalability needed for the most demanding environments. The foundation for Online Analytical Processing (OLAP) and data mining is included and fully integrated with SQL Server.
Main Features
English Query: Allow all users to access data via natural language queries. Graphically author queries with wizards in the included Visual Studio environment. Generate MDX to query cubes.
Linked OLAP cubes: Link OLAP cubes on different servers to supercharge analysis. Share with security or sell source cube data over the Internet.
Security: Help protect data with higher default security on install. Includes support for Secure Sockets Layer (SSL) connections and Kerberos. C2-level certification underway.
Full-Text Search: Enable Full-Text Search across the Web and intranets for formatted documents (e.g. Word, Excel, and HTML). Track changes automatically.
Data Transformation Services (DTS): Import and export primary and foreign keys between supported database products. Program the multi-phase data pump and save DTS packages as Visual Basic code.
Integrated Analysis Services: Build OLAP, data warehousing and data mining solutions to derive value from data.
Dimensions: Pick the most appropriate dimension type with new parent-child, ragged, changing, write-enabled and dependent dimensions.
Security in Analysis Services: Lock down sensitive data by defining security for dimensions and cells. Restrict roles to specific combinations of cells.
Parallel DBCC: Verify database data quickly and efficiently with multi-processor support.
Failover clustering: Install failover-ready databases directly from Setup. Use active-passive failover with standby hardware or active-active failover in hardware constrained environments. Databases can failover to any surviving node with 4-node failover.
Highly Scalable and Reliable.
System Requirements
·Hard Disk 180 MB hard disk space for full installation; 50 MB for Analysis Services; 12 MB for English Query.
·Media CD-ROM drive.
·Procesor 166 MHz or faster Pentium, Pentium PRO, Pentium III, or the minimum processor required for your operating system.
·Platform Microsoft Windows NT Server 4.0 (Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Advanced Server, or Windows 2000 Data Center Server).
