http://www.microsoft.com/SQL/sql20000.htm (PC Press Internet CD, 03/1996)
Microsoft SQL Server version 6.0 is a scalable, high-performance database management system designed specifically for distributed client-server computing. Its built-in data replication, powerful management tools, and open system architecture provide a superior platform for delivering cost-effective information solutions for organizations of all sizes.
Microsoft SQL Server version 6.0 is the first DBMS designed specifically for the new world of distributed client-server computing. It provides -- in one box at one price -- a complete and integrated system of database management software to meet the challenges facing today's businesses.
Powerful, built-in data replication provides a reliable way to disseminate accurate information and improve its availability throughout your enterprise.
A comprehensive distributed management framework lets you centrally manage all the database servers in your organization. With advanced Windows®-based management tools and powerful server-based job scheduling you have visual control over multiple servers and can automate remote operations for "lights out" command of your distributed environment.
Together, these tools help improve business performance and help reduce your operational costs.
The new multithreaded, parallel database design in Microsoft SQL Server delivers scalable high performance on today's cost- effective, standard hardware. It's multiprocessor-ready out of the box so you can take full advantage of the latest high-performance symmetric multiprocessing (SMP) hardware without additional configuration and management complexity.
Microsoft SQL Server also meets the most demanding requirements for reliability, data integrity, and security so you can depend on your distributed systems to safeguard your vital business data from loss or theft.
Through integration with key desktop technologies, SQL Server provides end users with unparalleled data access. And its open architecture -- based on industry standards -- ensures interoperability with the broadest range of applications, development tools, host gateways, and networks.
Many of these performance and reliability gains are achieved through close integration with the Microsoft Windows NTTM Server platform. And as part of the Microsoft BackOffice family, SQL Server works with other BackOffice server applications to offer powerful client-server solutions to help your business perform better.
The first centralized administration architecture for distributed
servers
Microsoft SQL Server incorporates an extensible, object-oriented
Distributed Management Framework (SQL-DMF) that addresses the
dynamic needs of today's client-server environments with:
Parallel data scanning allows SQL Server 6.0 to perform some queries up to 400 percent faster than before. Parallel data loading and indexing also increase performance. And high-speed parallel backup enables very large database (VLDB) support.
Taking full advantage of the native Windows NT threading and scheduling services simplifies the SQL Server architecture, which further improves performance and scalability. Because user tasks are isolated from one another, reliability also increases. And preemptive task scheduling balances the workload automatically across CPUs, providing smoother operations at a lower cost.
Seamless integration with desktop applications
SQL Server is the first DBMS to support key desktop technologies,
including OLE, Open Database Connectivity (ODBC), and e-mail.
Because it runs within the Windows computing environment, SQL Server works easily with desktop tools. You can automatically run a query, redirect the results via OLE to the Microsoft Excel charting engine, format the graph and data in a Microsoft Word report, and mail it as an attachment to users. A high-performance native ODBC interface with engine-based cursors provides superior support for today's desktop applications and tools.
Open architecture to protect your computing investments
Microsoft SQL Server has open, published interfaces at both the client
and the server to provide unmatched interoperability with hundreds
of existing client-server applications and tools. Microsoft Open Data
Services is a programmable SQL Server gateway to virtually any
external data source. SQL Server works with all popular networks
and protocols -- including UNIX®
environments -- right out of the box. And you can access host
databases -- such as IBM® DB2®, IBM AS/400®,
ORACLE®, and SYBASE® -- through gateways developed
with ODS or those from third-party vendors.
Database specifications Maximum storage capacity 8 TB Maximum cache memory 2 GB Maximum tables per database 2 billion Maximum databases per SQL Server 32,767 Maximum user connections 32,767 Maximum devices 256 Maximum tables per join (internal/external) 32/16 Memory per user connection 48K System datatypes supported Integer int; integer smallint tinyintFloating-point double numeric float real precision
Money money smallmoney
Character data character; varchar(n) character char(n) varying
Binary data binary(n) varbinary(n)
Exact numeric numeric decimal
Date and time datetime smalldatetime
Binary large object (BLOB) image text
Other bit timestamp sysname
Mission-critical support and service
In addition to industry-specific support and development assistance
from a worldwide network of Microsoft Solution Providers, Microsoft
offers fee-based*** mission-critical support -- including server
down and 24-hour-per-day, 7-day-per-week assistance. Authorized
Support Centers are staffed by technicians specially trained and
certified to support Microsoft products in a multi-vendor
environment. As a result, you get the best-backed software and
server products in the industry.
For more information
To access information via the World Wide Web, go to
http://www.microsoft.com and select Microsoft BackOffice.
* NIST and FIPS 127-2 certification expected in 1995.
**Requires ODBC client software from Visigenic Software, San Mateo,
CA.
***Microsoft's support services are subject to Microsoft's
then-
current prices, terms, and conditions, and are subject to change
without notice.
© 1995 Microsoft Corporation. All rights reserved.
This data is for informational purposes only. MICROSOFT MAKES NO
WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY. Company
names and data used in screens are fictitious, unless otherwise noted.
Microsoft, MS-DOS, Visual Basic, Visual C++, Visual FoxPro, Windows,
Windows NT, and the Windows logo are either registered trademarks
or trademarks of Microsoft Corporation in the United States and/or
other countries. Apple, AppleTalk, and Macintosh are registered
trademarks of Apple Computer, Inc. Banyan and VINES are
registered trademarks of Banyan Systems, Inc. Alpha AXP, DEC,
DECnet, and PATHWORKS are trademarks of Digital Equipment
Corporation. Intel is a registered trademark and Pentium is a
trademark of Intel Corporation. AS/400, DB2, IBM, and OS/2 are
registered trademarks of International Business Machines
Corporation. MIPS is a registered trademark of MIPS Computer
Systems, Inc. NetWare and Novell are registered trademarks of
Novell, Inc. ORACLE is a registered trademark of Oracle Corporation.
SYBASE is a registered trademark and DB-Library is a trademark of
Sybase, Inc. UNIX is a registered trademark in the United States and
other countries, licensed exclusively through X/Open Company, Ltd.
Version 6.0
0495 Part No. 098-59022
Previous Page Home