Positioning Framework

 

Microsoft SQL Server 2000 Enterprise Edition – Positioning Framework

Short Description

Microsoft SQL Server 2000 is the complete database and analysis offering for rapidly delivering the next generation of scalable e-commerce, line-of-business and data warehousing solutions.

Tagline

The next generation database of the .NET Enterprise Servers.

Legal Descriptor

Relational database management and analysis system.

Brand Affiliation

SQL Server 2000 is the next generation database of the .NET Enterprise Servers, an integral part of the Microsoft .NET platform.
 
Benefits

Fully Web-Enabled

Highly Scalable and Reliable

Fastest Time-to-Market

·         Rich XML and Internet standard support

  1. Store and retrieve data in XML format easily with built-in stored procedures
  2. Insert, update and delete data for XML developers with XML update grams
  3. Integrate systems with support for key W3C and IETF standards like XPath, HTTP and XML Updategrams

·         Easy access to data via the Web

  1. Easily access SQL Server directly from the web via HTTP
  2. Search textual data stored in the database and in documents faster with built-in, high performance full-text search
  3. Query easily over the web with natural language

·         Powerful, flexible Web-based analysis

  1. Uncover relationships and trends in Web data with new data mining tools
  2. Link and analyze complex data over the web, give partners and remote workers full analysis capabilities 
  3. Easily analyze and understand web site usage and drive traffic through Business Internet Analytics and Commerce Server

·         Secure application hosting platform

  1. Run multiple applications/customers on a single machine securely and reliably

·         Scalability for E-Commerce

  1. Partition workload across servers for scalability on demand while presenting a consistent programming model to developers
  2. Keep multiple systems in synch automatically
  3. Take full advantage of SMP systems

·         Scalability for line-of-business (LOB)

  1. Ensure greater reliability and availability with easier to manage and more flexible failover clusters
  2. Increase performance with SMP support; up to 32 CPUs and memory access to 64 GB of RAM for large data sets and transactional loads
  3. Speed data between servers for overall performance gains

·         Scalability for data warehousing

  1. Realize dramatically faster performance for even the most complex reporting scenarios
  2. Analyze extremely large data sets

·         Maximized uptime and reliability

  1. Perform critical operations online
  2. Backup more quickly based on changed data
  3. Backup with no impact on server performance

 

·         Integrated and extensible analysis services

  1. Build end-to-end analysis solutions with integrated tools to create value from data
  2. Automatically drive business processes based on analysis results
  3. Flexibly roll-up custom result sets from the most complex calculations

·         Simplified management and tuning

  1. Manage SQL Server databases centrally alongside all enterprise resources
  2. Save time and effort with dynamic self-management and tuning
  3. Stay online while easily moving and copying databases across machines or between instances

·         Quick development, debugging and data transformation

  1. Interactively tune and debug queries
  2. Quickly move and transform data from any source
  3. Define and use functions as if they were built in to T/SQL
  4. Switch the tools’ user interface from English to any supported language with a mouse click
  5. Visually design and code database applications from any Visual Studio tool

 

Features

XML stored procedure support: Allow (traditional) database developers to take advantage of XML immediately via using stored-procedures, a technique they are accustomed to (1)

XML update grams: Allows XML developers to insert, update and delete data in SQL Server 2000 with XML (2)

Standards Support: Support for standards (particularly web-based standards) enables smoother information interchange between heterogeneous systems (3)

HTTP access: Includes support for sending SQL queries to database via a URL (4)

Enhanced Full Text Search: Critical for web scenarios; enables search through db text as well as Word, Excel, PDF etc (5)

Microsoft English Query: Natural language query capabilities in desktop clients and on the web (6)

Integrated Data Mining: Used to cull important but not necessarily obvious business information from large data sets; one component of Business Internet Analytics: collecting, storing, managing, and analyzing customer Web click-stream data (7)

Linked OLAP databases: For the first time use OLAP cubes to create new opportunities for analysis; give your data value by offering it for OLAP use over the web (8)

HTTP access to cubes: View and manipulate multi-dimensional data over the web and through firewalls via HTTP listener built into database (8)

Commerce Server and Business Internet Analytics (BIA): Use Business Internet Analytics functionality along with Commerce Server 2000 to analyze clickstreams from recorded web traffic data (9)

Multi-instance support: Isolate and secure applications by installing multiple copies of SQL Server to different directories on a machine (10)

Distributed Partitioned Views: Unlimited scalability for the most demanding e-commerce applications by allowing work to be processed by multiple servers in unison (1)

Log Shipping: Allows physically separate systems to be synchronized via automatic transaction log updating for greater robustness and disaster tolerance (2)

Parallel operations: Parallel index creation and scan on SMP boxes to speed up applications (3)

Enhanced failover: Easily set up and manage failover clusters and failover to or from any node in a cluster; rebuild a cluster node without affecting other nodes (4)

Large memory and SMP support: Support for up to 32 CPUs and 64 GB of RAM on Windows 2000 Data Center to handle high transactional loads common in web applications (5)

Virtual Interface (VI) System Area Network (SAN) support: SQL Server can take advantage of System Area Networks with its built in VI Consumer that allows direct (user mode) communication with SAN disk devices. (6)

Materialized Views: Improve performance and scalability by storing and updating calculated results on disk (7)

Relational OLAP dimensions: Expands capabilities of already well-respected OLAP tools (8)

Online index rebuilding (reorg): One step process for online index rebuilding, minimal effect on performance while maximizing uptime (9)

Online parallel DBCC: Ensures data integrity without going offline (allows updates during data checking) (9)

Enhanced differential database backups:  Backs up data based on what has changed since last backup, fastest way to backup (10)

Server-less snapshot backups: “Break off” backups from mirrored systems to restore quickly or create warm standby servers without affecting database performance (requires hardware support) (10)

Integrated Analysis Services: the foundation for OLAP is included and fully integrated with SQL Server; enhancements for developers and DBAs (1)

OLAP Actions: Allows analysis results to kick off other processes in SQL Server, Web or business applications automatically (2) 

Custom rollups: Allows OLAP data to be used in sophisticated calculations such as rankings, profit & loss calculations, and complex budgeting models (3)

Active Directory support (on Windows 2000):  Simplifies and centralizes management in large organizations for server/machine naming, OLAP info, replication info and backup history  (4)

Dynamic self-management and tuning: Saves time and effort by automating complex setup and tuning tasks and managing resources like memory, locks, file sizes and more (5)

Copy database wizard: Allows administrators to easily move and copy databases without going offline (6)

SQL Server Enterprise Manager: has new features including enhanced schema design, repository integration, and interactive query analysis and debugging (7)

Enhanced Data Transformation Services: Integrated, easy to use and high performance data extraction, manipulation, transformation and loading (8)

User-defined functions: Lets users define functions in T/SQL that are used like native T/SQL functions (9)

Multi-language capabilities: Switch tool user interfaces between locales (languages) on the fly (10)

Visual Studio Database Tools: Includes graphical tools for schema design, query generation and code generation (11)

 

 

 

 

 

25/50/100 Word Product Descriptions (SQL Server 2000 Enterprise Edition)

25: Microsoft SQL Server 2000 is the complete database and analysis offering for rapidly delivering the next generation of scalable e-commerce, line-of-business and data warehousing solutions. (25 words)

 

50: Microsoft SQL Server 2000 is the complete database and analysis offering for rapidly delivering the next generation of scalable e-commerce, line-of-business and data warehousing solutions.  It dramatically reduces the time required to bring these applications to market while offering the scalability needed for the most demanding environments. (47 words)

 

100: Microsoft SQL Server 2000 is the complete database and analysis offering for rapidly delivering the next generation of scalable e-commerce, line-of-business and data warehousing solutions.  It dramatically reduces the time required to bring these applications to market while offering the scalability needed for the most demanding environments.  SQL Server 2000 includes support for XML and HTTP, performance and availability features to partition load and ensure uptime and advanced management and tuning functionality to automate routine tasks and lower total cost of ownership.  Additionally, SQL Server 2000 takes full advantage of Windows 2000, including support for up to 32 processors and 64 GB of RAM. (104 words)