Free Newsletter & Product Alert Signup
CMC International
PRODUCTS
Company Overview
Services
Products
Site Map
Contact
All Products
AnySite Online
Applied Geographic Solutions
Clearance & Close-Out Bargains
Data Backup
Demographic Reports and Software
EASY Analytic Software
ESRI
FireHost
GeoTel Communications
GIS Books
HP
MapInfo
Microsoft
MPSI / DataMetrix
US MOSAIC
Sage Software
SPSS
Symantec
Tele Atlas
Tower Maps
Web Hosting
Voice & Data Networks
LIVE CHAT
CUSTOMER COMMENTS
Home > Products > Microsoft > Microsoft SQL Server 2005

Microsoft SQL Server 2005


Microsoft SQL Server 2005
Volume, Academic or Government Pricing may be available.
Quick email response & fast order processing
We do not collect sales tax on orders shipped
outside of Texas

Click on the "Quote Request" button by your product
below for Discount and Volume Pricing.

 

ITEM
DISCOUNT PRICE
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Workgroup Edition
Microsoft SQL Server 2005 Express Edition
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Mobile Edition


Product Details

Data Management and Analysis Solution for Your Enterprise

  • Faster ResultsCMC is a HP - Hewlett Packard Authorized Reseller
    A new Management Studio and integration with Visual Studio 2005 and the Microsoft .NET common language runtime helps you build, debug, and operate applications faster and more efficiently.
  • Better Decisions
    A comprehensive business intelligence platform for data integration, analysis, and reporting that helps you turn insight into action and make better decisions, faster.
  • Trusted Platform
    The highest performance, availability and security to run your most demanding applications with native data encryption, secure default settings, and password policy enforcement.

SQL Server 2005 core components

What Is SQL Server 2005?

SQL Server 2005 is a comprehensive database platform providing enterprise-class data management with integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for both relational and structured data, enabling you to build and manage highly available, performant data applications that you and your people can use to take your business to the next level.

The SQL Server 2005 data engine lies at the core of this enterprise data management solution. Additionally, SQL Server 2005 combines the best in analysis, reporting, integration, and notification. This enables your team to build and deploy cost-effective BI solutions with which they can drive data into every corner of your business through scorecards, dashboards, Web services, and mobile devices.

Close integration with Microsoft Visual Studio, the Microsoft Office System, and a suite of new development tools, including the Business Intelligence Development Studio, sets SQL Server 2005 apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server 2005 provides innovative solutions that help you gain more value from your data.

The following diagram illustrates the core components in SQL Server 2005, showing how SQL Server 2005 is a key part of the Windows Server System in integrating with the Microsoft Windows platform—including the Microsoft Office System and Visual Studio—to offer solutions that deliver data to every corner of your organization.

Editions

Business today demands a different kind of data management solution—one that offers excellent performance, scalability, and reliability, but is also easy to use and maintain. Your business now expects more from its key information technology investments. SQL Server 2005 exceeds expectations by delivering enterprise-class data management and business intelligence.

The following list provides summaries and links to information about each edition of SQL Server 2005.

  • SQL Server 2005 Enterprise Edition
    Enterprise Edition includes the complete set of enterprise data management and business intelligence features. SQL Server Enterprise offers the highest levels of scalability and availability of all the SQL Server 2005 editions. Additionally, it is optimized to run on x64- and Itanium-based servers, helping you achieve higher levels of database scalability and availability.
  • SQL Server 2005 Standard Edition
    Standard Edition is an affordable option for small- and medium-sized organizations. It includes the core functionality needed for noncritical e-commerce, data warehousing, and line-of-business solutions. Standard Edition is optimized to run on win32, x64, and Itanium-based servers.
  • SQL Server 2005 Workgroup Edition
    Workgroup Edition is the data management solution for small organizations or workgroups within larger entities. It includes all the core database features needed for data management in an affordable and simple-to-manage package.
  • SQL Server 2005 Express Edition
    Express Edition helps developers build robust and reliable applications by providing a free, easy to use, and robust database when protecting and managing information inside and outside of applications is critical.
  • SQL Server 2005 Developer Edition
    Developer Edition is designed to enable developers to build any type of application on top of SQL Server 2005. It includes all the functionality of Enterprise Edition (win32, x64, IA64) but with a special development and test license agreement that prohibits production deployment.
  • SQL Server 2005 Mobile Edition
    Mobile Edition enables you to rapidly develop applications that extend enterprise data management and business intelligence capabilities to mobile devices.

MapPoint 2006 System Requirements

The recommended system configuration for Microsoft MapPoint version 2006 is a computer running Microsoft Windows XP Professional with a Pentium III processor and 128 megabytes (MB) of RAM. Below are the minimum requirements your computer needs to run MapPoint 2006. Some MapPoint features have additional requirements.

To use Microsoft® MapPoint 2006, you need:

  • PC with Pentium II or higher processor; Pentium III recommended
  • Microsoft® Windows® XP Home, Windows XP Professional, Windows ServerTM 2003, Windows 2000 Professional or later operating system required
  • Microsoft Internet Explorer 5.5 browser software or later, Internet Explorer 6.0 SP1 included (will not displace your primary browser)
  • For Windows XP Home and Windows XP Professional: 64 MB of RAM (128 MB recommended)
  • For Windows Server 2003: 256 MB of RAM
  • For Windows 2000 Professional: 64 MB of RAM (128 MB recommended)
  • Running additional applications simultaneously may require additional memory
  • Available hard-disk space: 1.1 GB for full installation or 500 MB for minimum installation. Some users may require up to an extra 100MB for System Files Update (hard disk usage will vary depending on configuration).
  • 4x speed or faster CD-ROM drive
  • Super VGA (800 x 600) or higher resolution monitor with 256 colors; a monitor with higher resolution and more colors recommended and required for Driving Guidance feature
  • Microsoft Mouse, Microsoft IntelliMouse®, or compatible pointing device

Additional items or services required to use certain features:

  • For Voice Output: Windows XP or higher and compatible soundcard
  • Microsoft Exchange, Internet SMTP/POP3, IMAP4, or MAPI-compliant messaging software required to use Send To as attachment; Microsoft Outlook® 2000 or later required to use Send To as picture
  • 14,400-baud or higher recommended
  • Some Internet functionality may require Internet access and payment of a separate fee to an Internet service provider and local charges may apply
  • GPS functionality requires a GPS device that supports NMEA 2.0 or later
  • A free COM port below 20 required for GPS
  • Pocket Streets:
    • A Pocket PC running Microsoft Windows CE 3.0 or later with ActiveSync 3.7 API and 500KB available program memory required for installation of Pocket Streets. Installing map files requires additional memory, approximately 1MB per city map
    • A Microsoft Windows powered Smartphone 2002 or Microsoft Windows Mobile 2003 Smartphone or later with ActiveSync 3.7 API and 350KB available program memory required for installation of Pocket Streets for Smartphone. Installing map files requires additional memory, approximately 1MB per city map.

As technology continues to drive change, 64-bit processing is reshaping the database industry by providing more performance for data-intensive applications. See how Microsoft meets your performance needs with 64-bit technology.

  • SQL Server on a 64-bit Platform
    SQL Server 64-bit helps you achieve higher levels of database scalability and availability with an enterprise-class database optimized to run on x64- and Itanium-based servers. The 64-bit features are available only on the Standard, Enterprise, and Developer editions of SQL Server 2005.

SQL Server 2005 Features Comparison

Notes: In the following table, the "Comments" column provides comments on the specified feature. Numbers next to check marks indicate footnotes that appear at the bottom of the page. SQL Server 2005 Developer Edition and Evaluation Edition are not listed in the tables. These editions have the same feature set as the Enterprise Edition; the only difference between these editions is the licensing policies.

Scalability and Performance

Feature Express Workgroup Standard Enterprise Comments

Number of CPUs

1

2

4

No Limit

Includes support for multicore processors.

RAM

1 gigabyte (GB)

3 GB

Operating system maximum

Operating system maximum

Memory limited to maximum supported by operating system.

64-bit Support

Windows on Windows (WOW)

WOW

checked

checked

*

Database Size

4 GB

No Limit

No Limit

No Limit

*

Partitioning

*

*

*

checked

Support for large-scale databases

Parallel Index Operations

*

*

*

checked

Parallel processing of indexing operations

Indexed Views

*

*

*

checked

Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition.

High Availability

Feature Express Workgroup Standard Enterprise Comments

Database Mirroring

*

*

checked1

checked

Advanced high availability solution that includes fast failover and automatic client redirection

Failover Clustering

*

*

checked2

checked

*

Backup Log-shipping

*

checked

checked

checked

Data backup and recovery solution

Online System Changes

checked

checked

checked

checked

Includes Hot Add Memory, dedicated administrative connection, and other online operations

Online Indexing

*

*

*

checked

*

Online Restore

*

*

*

checked

*

Fast Recovery

*

*

*

checked

Database available when undo operations begin

1 Single REDO thread and the safety setting is always on.
2 Supports only two nodes.

Manageability

Feature Express Workgroup Standard Enterprise Comments

Auto Tuning

checked

checked

checked

checked

Automatically tunes database for optimal performance.

Profiler

*1

*2

checked

checked

*

SQL Server Management Studio Express

See Comments

checked

checked

checked

Easy-to-use graphical management tool available as a separate download or included with the SQL Server Express w/Advanced Services download

Management Studio

*

checked

checked

checked

Full management platform for SQL Server; includes Business Intelligence (BI) Development Studio.

Database Tuning Advisor

*

*

checked

checked

Automatically suggests enhancements to your database architecture to improve performance.

Serviceability Enhancements

checked

checked

checked

checked

Dynamic management views and reporting enhancements.

Full-text Search

See comments

checked

checked

checked

Available for SQL Server Express in the SQL Server Express w/ Advanced Services download

SQL Agent Job Scheduling Service

*

checked

checked

checked

*

1 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.
2 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.

Security

Feature Express Workgroup Standard Enterprise Comments

Advanced Auditing, Authentication, and Authorization

checked

checked

checked

checked

*

Data Encryption and Key Management

checked

checked

checked

checked

Built-in data encryption for advanced data security.

Integration with Microsoft Baseline Security Analyzer

checked

checked

checked

checked

Scans your system to check for common security vulnerabilities.

Integration with Microsoft Update

checked

checked

checked

checked

*


Programmability

Feature Express Workgroup Standard Enterprise Comments

Stored Procedures, Triggers, and Views

checked

checked

checked

checked

*

T-SQL Enhancements

checked

checked

checked

checked

Includes exception handing, recursive queries, and support for new data types.

Common Language Runtime and .NET Integration

checked

checked

checked

checked

*

User-defined Types

checked

checked

checked

checked

Extend the server with your own custom data types.

Native XML

checked

checked

checked

checked

Includes XML indexing and full-text XML search.

XQuery

checked

checked

checked

checked

*

Notification Services

*

*

checked

checked

Allows the building of advanced subscription and publication applications.

Service Broker

checked1

checked

checked

checked

*

1 Subscriber only.

Integration and Interoperability

Feature Express Workgroup Standard Enterprise Comments

Import/Export

checked

checked

checked

checked

*

Integration Services with Basic Transforms

*

*

checked

checked

Provides graphical extract, transform, and load (ETL) capabilities.

Integration Services Advanced Transforms

*

*

*

checked

Includes data mining, text mining, and data cleansing.

Merge Replication

checked1

checked2

checked

checked

*

Transactional Replication

checked3

checked4

checked

checked

*

Oracle Replication

*

*

*

checked

Transactional replication with an Oracle database as a publisher

Web Services (HTTP Endpoints)

*

*

checked

checked

Support for native Web services, Web Services Description Language (WSDL), and Web authentication

1 Subscriber only.
2 Publish to up to 25 subscribers.
3 Subscriber only.
4 Publish to up to five subscribers.

Business Intelligence

Feature Express Workgroup Standard Enterprise Comments

Report Server

See Comments

checked

checked

checked

Report Server is available for SQL Server Express in the SQL Server Express with Advanced Services download.

Report Builder

*

checked

checked

checked

End-user reporting tool

Reporting Data Sources

1

*

checked

checked

checked

*

Scale Out Report Servers

*

*

*

checked

*

Data Driven Subscriptions

*

*

*

checked

*

Infinite Clickthrough

*

*

*

checked

*

Data Warehousing

*

*

checked

checked

*

Star Query Optimization

checked

checked

checked

checked

*

SQL Analytical Functions

checked

checked

checked

checked

*

BI Development Studio

See Comments

2

checked3

checked

checked

Integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions.

Enterprise Management Tools

*

checked

checked

checked

Integration with SQL Management Studio, SQL Server Profiler, SQL Server Agent, Backup/Restore.

Native Support for Web Services
(Service Oriented Architectures)

checked4

checked5

checked

checked

Allows access to data from any device.

Analysis Services

*

*

checked

checked

Powerful analytics and data mining capabilities.

Unified Dimensional Model (UDM)

*

*

checked

checked

Enterprise business data model enables fast, interactive, ad hoc analysis of large data sets. Builds smarter reports that leverage centralized business logic and key performance indicators (KPIs), as well as the performance of UDM.

Business Analytics

*