Cloud Database Consulting Services

We provide expert SQL Server consulting services for databases in the cloud.   Cloud databases offer many significant advantages compared to traditional databases.  Increased accessibility, automatic fail-over and automated recovery from failures.  Other benefits include minimal investment and maintenance of in-house hardware, and potentially better performance. At the same time, cloud databases have their share of potential drawbacks, including security and privacy issues, as well as the potential loss of or inability to access critical data in the event of a disaster.

A cloud database is a database that typically runs on a cloud computing platform, such as Amazon EC2, Microsoft, or Rackspace. There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider.

There are two primary methods to run a database on the cloud:

  • Infrastructure as a Service (Iaas) – Cloud platforms allow users to purchase virtual machine instances for a limited time. It is possible to run a database on these virtual machines. Users can either upload their own machine image with a database installed on it, or use ready-made machine images that already include an optimized installation of a database.
  • Database as a service – some cloud platforms offer options for using a database as a service, without physically launching a virtual machine instance for the database. In this configuration, application owners do not have to install and maintain the database on their own. Instead, the database service provider takes responsibility for installing and maintaining the database, and application owners pay according to their usage. For example, Amazon Web Services provides three database services as part of its cloud offering, SimpleDB, a NoSQL key-value store, Amazon Relational Database Service, an SQL-based database service with a MySQL interface, and DynamoDB.

Looking for a First-Class SQL Server Consultant?