This article is part of an Essential Guide, our editor-selected collection of our best articles, videos and other content on this topic. Explore more in this guide:
4. - SQL Server Glossary: Read more in this section
Explore other sections in this guide:
- 1. - Basics and benefits of SQL Server training
- 2. - Trends, perspectives and advice on enhancing SQL Server skills
- 3. - Essentials for DBAs in 2014
Optimizing an already existing database for the cloud provides benefits such as:
- The ability to pay for storage capacity and bandwidth on a per-use model.
- The ability to move the database from one location to another (cloud portability).
- Scalability on demand.
- High availability (HA).
Putting the database in the cloud can be an effective way to support and cloud-enable business applications as part of a wider software-as-a-service (SaaS) deployment by simplifying the processes required to make information available through Web-based connections. Storage consolidation can also be a benefit of moving a company’s databases to the cloud. Databases in multiple departments of a large company, for example, can be combined in the cloud into a single hosted (DBMS).