CLICK HERE TO
START LIVE CHAT
 
 TOLL FREE SUPPORT
800.317.8552
 
 UNITY CUSTOMER
PORTAL LOGIN

Dedicated Servers with Microsoft SQL Server 2008 
Microsoft SQL Server 2008 Overview
Server Intellect is proud to be one of the first hosting providers and Microsoft Gold Hosting partners to offer Microsoft SQL Server 2008 on all Windows dedicated servers.

Microsoft SQL Server 2008 is a major upgrade to SQL Server from Microsoft. It offers a host of new features that have been added to Microsoft SQL Server. Here are a few of the highlighted features of SQL Server 2008.
  • Resource Governor
    This allows administrators to specify the resources assigned to users or groups
  • Encryption at rest
    With this feature whole database can be encrypted with a master key
  • Auditing
    SQL Server 2008 offers enhanced automatic auditing features
  • Filtered Indexes
    SQL Server 2008 allows you to create an index and specify what rows not to index
  • Compression
    SQL server 2008 offers row and page level compression
  • Performance Data Collector
    The new performance data collector improves data collection to allow you to more easily see who is using valuable server resources
  • Intellisense
    The SQL management studio include Intellisense support for constructing database queries
And much, much more…

Microsoft SQL Server 2008 Versions
Microsoft SQL Server 2008 is available in a variety of editions. Below we have provided a comparison of the various editions and the features supported in them.

Pricing Per Processor
Express
Edition 		Web
Edition 		Workgroup
Edition 		Standard
Edition 		Enterprise
Edition
$0 Included $25 per Month $75 per Month $225 per Month $1,000 per Month

SQL Server 2008 Features
Resource Limits Express Web Workgroup Standard Enterprise
CPU Limit 1 2 4 4 OS Max
RAM Limit 1 GB OS Max OS Max1 OS Max OS Max
Database Size Limit 4 GB Unlimited Unlimited Unlimited Unlimited

Scalability Express Web Workgroup Standard Enterprise
Partitioning
Data Compression
Resource Governor
Partition table parallelism

High Availability Express Web Workgroup Standard Enterprise
Multi-instance support 16 16 16 16 50
Online system changes
Backup Log Shipping
Database Mirroring
Witness
Only
Witness
Only
Witness
Only
Safety Full
Only
Full
 
Failover Clustering
2 Nodes
OS Max2
Dynamic AWE
Failover Without Client Configuration
Automatic Corruption Recovery From Mirror
Database Snapshots
Fast Recovery
Online Indexing
Online Restore
Mirrored Backups
Hot Add Memory
Online Configuration of P2P Nodes
Hot Add CPU
Backup Compression

Security Express Web Workgroup Standard Enterprise
C2 compliant tracing
SQL Auditing Foundation
Fine Grained Auditing
Transparent Database Encryption
ISV Encryption (Off-box Key Management)

Replication Express Web Workgroup Standard Enterprise
Merge Replication
Subscriber
Only
Subscriber
Only
Subscriber
Only
Transactional Replication
Subscriber
Only
Subscriber
Only
Subscriber
Only
Snapshot Replication
Subscriber
Only
Subscriber
Only
Subscriber
Only
SQL Server Change Tracking
Heterogeneous Subscribers
Oracle Publishing
P2P Transactional Replication

Manageability Express Web Workgroup Standard Enterprise
User Instances
Dedicated Admin Connection
(Under
Trace Flag)
Policy-Based Configuration
Policy-Based Management
Performance Data Collection and Warehouse
Standard Performance Reports
Plan Guides
Plan Freezing for Plan Guides
Policy-based Best Practices
Multi-Server Policy-Based Management
Distributed Partition Views
Parallel Index Operations
Automatic Query-to-Indexed-View Matching
Parallel Database Backup Checksum Check
Database Mail
Database Migration Tools

Management Tools Express Web Workgroup Standard Enterprise
SQL Management Objects (SMO)
SQL Configuration Manager
SQL CMD (Command Prompt Tool)
SQL Server Management Studio   3   4
SQL Profiler
SQL Server Agent
Database Tuning Advisor
Microsoft Operations Manager Pack

Development Tools Express Web Workgroup Standard Enterprise
Microsoft Visual Studio Integration
SQL Query and Edit and Design Tools
Intellisense (Transact-SQL and MDX)
Version control support
Business Intelligence Development Studio
MDX Edit, Debug, and Design Tools

Programmability Express Web Workgroup Standard Enterprise
Common Language Runtime (CLR) Integration
Native XML Support
XML indexing
MERGE and UPSERT Capabilities
FILESTREAM Support
Date and Time Data Types
Internationalization Support
Full-Text Search
Specification of Language in Query
Service Broker (Messaging)
Client Only
Client Only
XML/A Support
Web Services (HTTP/SOAP Endpoints)

<
Spatial and Location Services Express Web Workgroup Standard Enterprise
Spatial Indexes
Geodetic Data Type
Advanced Spatial Libraries