SQL Server VPS
Microsoft SQL Server 2008 R2 on VPS
For Windows Virtual Server deployments we offer the Microsoft database management system, known as SQL Server 2008®
R2.
SQL Server 2008 R2 helps you manage any data, any place, any time. You can store anything from structured, semi-structured, and unstructured documents directly within the database.
myhosting.com Hyper-V Cloud Server Advantage!
With all myhosting.com Windows VPS products, your VPS is backed by our Cloud Advantage, which provides improved uptime and performance over other providers
by incorporating a NetApp SAN storage backend.
Why Microsoft SQL Server 2008 R2
All SQL Server 2008 R2 built in services empower:
- Search
- Synchronization
- Reports
- Analysis
It also provides the highest levels of security, reliability and scalability for your business-critical applications.
Microsoft SQL Server 2008 R2 Edition Comparison
myhosting.com offers these powerful editions of Microsoft SQL Server as addons to your VPS server environment.
| Detailed Feature Comparison |
Edition |
Standard |
Workgroup |
Web |
Express |
| Enterprise Security |
| C2 Complaint Tracing |
 |
|
|
|
| Replication |
| SQL Server Change Tracking |
|
|
|
|
| Merge Replication |
|
Subscriber only ** |
Subscriber only |
Subscriber only |
| Transactional Replication |
|
Subscriber only ** |
Subscriber only |
Subscriber only |
| Snapshot Replication |
|
Subscriber only ** |
Subscriber only |
Subscriber only |
| Heterogeneous Subscribers |
|
|
|
|
| Enterprise Manageability |
| SQL Server Change Tracking |
|
|
|
|
| Merge Replication |
|
|
|
|
| Transactional Replication |
|
|
|
|
| Snapshot Replication |
|
|
|
* |
| Database Mail |
|
|
|
|
| Performance Data Collection |
|
|
|
|
| SQL Server Agent |
|
|
|
|
| Database Tuning Advisor |
|
|
|
|
| Plan Guides |
|
|
|
|
| SQL Profiler |
|
|
|
|
| Standard Performance Reports |
|
|
|
|
| Data Warehousing |
| Create Cubes Without a Database |
|
|
|
|
| Auto-generate Staging and Datawarehouse Schema |
|
|
|
|
| Attribute Relationship Designer |
|
|
|
|
| Efficient Aggregation Designers |
|
|
|
|
| Integration Services |
| SQL Server Import and Export Wizard |
|
|
|
|
| Log Providers and Logging |
|
|
|
|
| XML Source |
|
|
|
|
| SSIS Run-time |
|
|
|
|
| Basic Data Profiling Tools |
|
|
|
|
| SSIS Package Designer & Service |
|
|
|
|
| Scalability & Performance |
| Maximum Database Size* |
524PB*** |
524PB*** |
524PB*** |
10GB*** |
| x32 Hardware Support |
|
|
|
|
| x64 Hardware Support |
|
|
|
|
| Reporting Services |
| Reporting Services Memory Limits |
OS Max*** |
4GB*** |
4GB*** |
4GB*** |
| Report Designer |
|
|
|
|
| Report Manager |
|
|
(report manager) |
*
(report manager) |
| Role-based Security |
|
(fixed roles) |
(fixed roles) |
(fixed roles) |
| Basic Data Profiling Tools |
|
|
|
|
| Export to Excel, Word, PDF and Images |
|
|
|
* |
| Report Server Application Embedding |
|
|
|
* |
| Enhanced Gauges and Charting |
|
|
|
|
| Custom Authentication |
|
|
|
|
| Ad-hoc Reporting (Report Builder) |
|
|
|
|
| SharePoint Integration |
|
|
|
|
| Email and File Share Delivery |
|
|
|
|
| Report History, Scheduling, Subscriptions and Caching |
|
|
|
|
| Data Source, Delivery and Rendering Extensibility |
|
|
|
|
| Analysis Services |
| Analysis Services Backup |
|
|
|
|
| Dimension, Attribute Relationship, Aggregate & Cube Design |
|
|
|
|
| Personalization Extensions |
|
|
|
|
| Data Mining |
| Excel 2007 and Visio 2007 Add-in Support |
|
|
|
|
| Comprehensive Set of DM Algorithms |
|
|
|
|
| Integrated Data Mining Tools (Wizards, Editors, Model Viewers, Query Builder) |
|
|
|
|
| Programmability |
| MERGE and Upsert Capabilities |
|
|
|
|
| New Date and Time Data Types |
|
|
|
|
| Internationalization Support |
|
|
|
|
| Full Text Search |
|
|
|
* |
| Common Language Runtime (CLR) Integration |
|
|
|
|
| Native XML Support |
|
|
|
|
| XML Indexing |
|
|
|
|
| FILESTREAM Support |
|
|
|
|
| Entity Framework Support |
|
|
|
|
| Spatial Support |
|
|
|
|
| Development Tools |
| Microsoft Visual Studio Integration |
|
|
|
|
| Intellisense (Transact-SQL-and MDX) |
|
|
|
|
| MDX Edit, Debug and Design Tools |
|
|
|
|
| Spatial and Location Services |
| Spatial Indexes |
|
|
|
|
| Geodetic Data Type |
|
|
|
|
| Advanced Spatial Libraries |
|
|
|
|
| Standards-based Spatial Support |
|
|
|
|
|
1 (866) 289-5091
