AMNET myCloudTM Platform

Hosted SQL

Enterprise Database Hosting Designed for Your Business

About Hosted SQL

Your database is a crucial element of your company's business. That's why businesses rely upon Amnet's database hosting services to keep their company going.  Amnet provides hosting services for a wide-range of enterprise databases including SQL 2008 and Microsoft SQL 2012. Our 24/7/365 Operations Staff supports business-critical databases in some of the world's most demanding environments. Combined with Amnet's superior Disaster Recovery solutions, our customers can rest assured that their data is protected.

High performance, fully managed Microsoft SQL 2008/2012 database hosting dynamically expandable to your needs

Multi-tenant or dedicated offerings to meet your applications performance and compliance requirements

High speed SAN with disk caching ensures your database always runs at peak performance

Customized backup, and replication options to meet your application and business continuity requirements

Easily integrated with your other Amnet myCloud services for high performance private cloud SWL database speed

Comparison

Side by side comparison to know which option is right for you

MICROSOFT SQL SERVER
Just about every business has an application that requires a database.   Microsoft SQL Server software is a leader in data base technology. In order to unlock all of the power in SQL it is critical to build the correctly powerful servers, storage and overall speed to meet each applications requirements. This is typically one of the most expensive components for a business to implement. High performance hardware and expert design/engineering along with high speed integration to your applications and web site are critical components for your main site never mind duplicating all of this at a backup site.  

Unlike the many public cloud offerings in the market, Amnets cloud Hosted SQL service is 100% integrated to all your other hosted applications and since they are all running in the same data center it communicates at lightning fast 10GB speed. The cost effectiveness of SQL in the cloud combined with high performance benefits of a single private cloud with optional full backup to a second data center make myCloud Hosted SQL platform a perfect fit for any size cloud database deployment.

Features                                                                                                                              
Standard (SQL-S)             Business Intelligence
(SQL-B)
Enterprise
(SQL-E)

Maximum Number of Cores

16 cores
16 Cores - DB OS Max- AS& RS (b)
OS Max (a)
Basic OLTP * * *
Programming (T-SQL, Data Types, File Table) * * *
Manageability (SQL Server Management Studio, Policy-based Management) * * *
Basic High Availability (c) * * *
Basic Corporate BI (Reporting, Analytics, Multi-Dimensional Semantic Model, Data Mining) * * *
Basic Data Integration (Built-In Data Connectors, Designer Transforms) * * *
Self-Service Business Intelligence (Alerting, Power View, Power Pivot for SharePoint Server) (d) * *
Advanced Corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting, VertiPaq(TM) IN Memory Engine, Advanced Data Mining) * *
Enterprise Data Management (Data Quality Services, Master Data Services) * *
Advanced Data Integration (Fuzzy Grouping and Looking, Change Data Capture) *
Advanced Security (SQL Server Audit, Transparent Data Encryption) *
Data Warehousing (Column Store, Index Compression, Partitioning) *
Advanced High Availability (Multiple, Active Secondary, Multi-Site, Geo-Clustering) (c) *

Benefits of Amnet's Hosted SQL

Microsoft® SQL Server® 2012 the cloud-ready information platform for quick and reliable data storage, retrieval and analysis. SQL 2012 expands on SQL 2008 with enhancements to business intelligence, availability, disaster recovery, speed, security, role management and more. SQL Server 2012 provides Mission Critical Confidence with greater up-time, unprecedented speed and enhanced security features for mission critical workloads; Breakthrough Insights with managed self-service data exploration and stunning interactive data visualizations capabilities.

  • SQL Server AlwaysOn is a new, unified HA solution for greater up-time, faster fail over, and better use of hardware resources
  • xVelocity helps enable a generational leap in performance across data warehousing and business intelligence
  • Production-like application testing enables high scale-out testing for mission critical apps, configuration changes, and upgrades
  • Includes PowerView, a highly interactive data exploration and visualization tool for users of all levels that enables insights at the speed of thought
  • Improve data quality by using organizational knowledge and third-party reference data providers to profile, cleanse, and match data
  • Increase manageability related to auditing with audit resilience, filtering, user-defined audit, and enablement across all editions

 

SQl 2008 Service Overview1



Hosting SQL Server in the Cloud


Recognizing the cost savings, recovery, and performance benefits offered by cloud computing, organizations have begun transitioning many mission critical applications. One typical exception is database applications. Databases generally donft scale well, and run into performance issues if adequate computing resources are not allocated. Distributing or virtualizing database workloads provide a somewhat unique challenge for organizations looking to consolidate their IT resources, or utilize cloud providers for backup and recovery options.

Knowing these issues, Microsoft designed SQL Server 2012 to move seamlessly from a single server to a private or public cloud. Applications can be created once and deployed in any SQL Server environment. One piece of the infrastructure that allows this is the concept of contained databases. Often databases rely on external links or applications. User verification, updated tables, and report generation are just a few examples. SQL Server 2012 provides tools to reduce the dependency of the databases on external sources, making it much easier to move from one SQL environment to another. Using the AlwaysOn feature, users can host databases or groups in various physical or virtual locations. The licensing structure also supports this mobility. As the SQL Server moves from one environment to another the license moves with it, eliminating the need to purchase additional licenses when changing where or how it is hosted.

The flexibility these features offer enable organizations to scale when business needs require it, making it ideal for hybrid IT solutions.

 

Managing SQL Server

SQL Server 2012 has made strides in optimizing productivity and ease of use for end users. But developing and administering SQL Server still requires a trained professional.  Below are some examples of what a SQL server data base  administrator would be responsible for:

  • Data modeling and database design
  • Metadata management and repository usage
  • Database schema creation and management
  • Capacity planning
  • Programming and development
  • SQL code reviews and walk.throughs
  • Performance management and tuning
  • Data movement
  • Backup and recovery
  • Ensuring data integrity
  • Data security
  • Storage management techniques

SQL professionals know how to optimize performance for a particular use and computing environment. How a database is structured, stored, and accessed can all vary depending on organizational and business needs. A knowledgeable administrator can help ensure you meet your disaster recover, HA or compliance requirements. If you are migrating to 2012 to take advantage of the hybrid IT features, but lack a trained professional, Amnet's professional services team can help.

Summary

SQL Server 2012 includes enhancements that enable businesses to manage and understand their data better than ever before. Improved BI tools that empower the end user integrate with well‐known interfaces such as a standard web browser, Excel, or SharePoint.

In addition to offering improved functionality for users, the intentionally cloud‐friendly development and deployment options mean that mission critical databases can be moved or extended into a cloud environment and maintain expected performance levels. This means organizations can benefit from the cost savings and scalability of utilizing the cloud for some or all of their database and IT requirements.

back to top