- Managed Hosting
- Dedicated Server hosting
- Business web hosting
- Application hosting
- Database hosting
- Load Balancing
- Cloud hosting
- VMware Virtualisation
- VI CDN
- Messaging & collaboration
- Microsoft Exchange
- Microsoft Sharepoint
Data Centre Tour View our data centre and network specification
VI Control Panel Take a look at the control panel for VI customers
MS SQL DATABASE HOSTING Microsoft SQL Editions Comparison Chart
SCALABILITY & PERFORMANCE
| Feature | Express | Workgroup | Standard | Enterprise | Comments |
| Number of CPUs | 1 | 2 | 3 | Number of CPUs | 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 | Yes | Yes | |
| Database Size | 4 GB | No Limit | No Limit | No Limit | |
| Partitioning | Yes | Support for large-scale databases | |||
| Parallel Index Operations | Yes | Parallel processing of indexing operations | |||
| Indexed Views | Yes | 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 | Yes | Yes | Advanced high availability solution that includes fast failover and automatic client redirection | ||
|---|---|---|---|---|---|
| Failover Clustering | Yes | Yes | |||
| Backup Log-shipping | Yes | Yes | Yes | Data backup and recovery solution | |
| Online System Changes | Yes | Yes | Yes | Yes | Includes Hot Add Memory, dedicated administrative connection, and other online operations |
| Online Indexing | Yes | ||||
| Online Restore | Yes | ||||
| Fast Recovery | Yes | Database available when undo operations begin |
MANAGEABILITY
| Feature | Express | Workgroup | Standard | Enterprise | Comments |
| Auto Tuning | Yes | Yes | Yes | Yes | Automatically tunes database for optimal performance. |
|---|---|---|---|---|---|
| Profiler | 2 | 2 | Yes | Yes | |
| SQL Server Management Studio Express | See Comments | Yes | Yes | Yes | Easy-to-use graphical management tool available as a separate download or included with the SQL Server Express w/Advanced Services download |
| Management Studio | Yes | Yes | Yes | Full management platform for SQL Server; includes Business Intelligence (BI) Development Studio. | |
| Database Tuning Advisor | Yes | Yes | Automatically suggests enhancements to your database architecture to improve performance. | ||
| Serviceability Enhancements | Yes | Yes | Yes | Yes | Dynamic management views and reporting enhancements. |
| Full-text Search | See Comments | Yes | Yes | Yes | Available for SQL Server Express in the SQL Server Express w/ Advanced Services download |
| SQL Agent Job Scheduling Service | Yes | Yes | Yes |
SECURITY
| Feature | Express | Workgroup | Standard | Enterprise | Comments |
| Advanced Auditing, Authentication, and Authorization | Yes | Yes | Yes | Yes | |
|---|---|---|---|---|---|
| Data Encryption and Key Management | Yes | Yes | Yes | Yes | Built-in data encryption for advanced data security. |
| Integration with Microsoft Baseline Security Analyzer | Yes | Yes | Yes | Yes | Scans your system to check for common security vulnerabilities. |
| Integration with Microsoft Update | Yes | Yes | Yes | Yes |
PROGRAMMABILITY
| Feature | Express | Workgroup | Standard | Enterprise | Comments |
| Stored Procedures, Triggers, and Views | Yes | Yes | Yes | Yes | |
|---|---|---|---|---|---|
| T-SQL Enhancements | Yes | Yes | Yes | Yes | Includes exception handing, recursive queries, and support for new data types. |
| Common Language Runtime and .NET Integration | Yes | Yes | Yes | Yes | |
| User-defined Types | Yes | Yes | Yes | Yes | Extend the server with your own custom data types. |
| Native XML | Yes | Yes | Yes | Yes | Includes XML indexing and full-text XML search. |
| XQuery | Yes | Yes | Yes | Yes | |
| Notification Services | Yes | Yes | Allows the building of advanced subscription and publication applications. | ||
| Service Broker | Yes | Yes | Yes | Yes |
INTEGRATION AND INTEROPERABILITY
| Feature | Express | Workgroup | Standard | Enterprise | Comments |
| Import/Export | Yes | Yes | Yes | Yes | |
|---|---|---|---|---|---|
| Integration Services with Basic Transforms | Yes | Yes | Provides graphical extract, transform, and load (ETL) capabilities. | ||
| Integration Services Advanced Transforms | Yes | Includes data mining, text mining, and data cleansing. | |||
| Merge Replication | Yes | Yes | Yes | Yes | |
| Transactional Replication | Yes | Yes | Yes | Yes | |
| Oracle Replication | Yes | Transactional replication with an Oracle database as a publisher | |||
| Web Services (HTTP Endpoints) | Yes | Yes | Support for native Web services, Web Services Description Language (WSDL), and Web authentication |
BUSINESS INTELLIGENCE
| Feature | Express | Workgroup | Standard | Enterprise | Comments |
| Report Server | See Comments | Yes | Yes | Yes | Report Server is available for SQL Server Express in the SQL Server Express with Advanced Services download. |
|---|---|---|---|---|---|
| Report Builder | Yes | Yes | Yes | End-user reporting tool | |
| Reporting Data Sources | Yes | Yes | Yes | ||
| Scale Out Report Servers | Yes | ||||
| Data Driven Subscriptions | Yes | ||||
| Infinite Clickthrough | Yes | ||||
| Data Warehousing | Yes | Yes | |||
| Star Query Optimization | Yes | Yes | Yes | Yes | |
| SQL Analytical Functions | Yes | Yes | Yes | Yes | |
| BI Development Studio | See Comments 2 |
Yes | Yes | Yes | Integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions. |
| Enterprise Management Tools | Yes | Yes | Yes | Integration with SQL Management Studio, SQL Server Profiler, SQL Server Agent, Backup/Restore. | |
| Native Support for Web Services (Service Oriented Architectures) |
Yes | Yes | Yes | Yes | Allows access to data from any device. |
| Analysis Services | Yes | Yes | Powerful analytics and data mining capabilities. | ||
| Unified Dimensional Model (UDM) | Yes | Yes | 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 | Yes | Yes | Multidimensional Expression (MDX) scripts and MDX debugger, .NET stored procedures, Time Intelligence, KPI Framework. | ||
| Advanced Business Analytics | Yes | Account intelligence, metadata translation, perspective and semi-additive measures. | |||
| Proactive Caching | Yes | Provides automated caching for greater scalability and performance. | |||
| Advanced Data Management | Yes | Partitioned cubes, parallel processing, server synchronization. | |||
| Full Writeback Support | Yes | Dimension and cell writeback | |||
| Data Mining | Yes | Yes | Nine algorithms including decision and regression trees, clustering, logistic and linear regression, neural networks, naive bayes, association, sequence clustering, and time series. Build smarter reports that leverage centralized business logic and KPIs, as well as the performance of UDM. | ||
| Advanced Performance Tuning | Yes | ||||
| Yes | Additional options for tuning data mining models for the highest accuracy, performance, and scalability. | ||||
| SQL Server Integration Services Data Flow Integration | Yes | Perform data mining prediction and training operations directly in your operational data pipelines. | |||
| Text Mining | Yes | Convert unstructured text data to structured data for analysis via reporting, online analytical processing (OLAP), or data mining. |
