One service provides a relational database, allowing you to get Layer 1 functionality
- Expandable to thousands of databases
- Scales smoothly for predictable performance
- Provides guaranteed availability through a backup and run-time Service Level Agreement
- It protects data through recovery and geo-replication
- It achieves efficient development and operations similar to programmable DBA functionality
- Automated self-management virtually eliminates the need for manual intervention
Built-in support for large-scale SaaS apps
Built-in Software as a Service (SaaS) apps provide flexible SQL Databases developers can use to support explosive growth and profitable business models. Regarding workloads that have unpredictable database resource consumption, flexible database models enable you to split demand among a group of databases without exceeding the allocated databases’ ability to meet peak demand. On the other hand, you can use a flexible database pool to allow hundreds or thousands of databases to be used while staying within your allocated resources. You can draw support from a group of distributed databases to control a price and performance purchase model to push for cost effectiveness.
Easy to manage large-scale databases
When you expand to thousands of databases, simple administration tasks can become complicated and this explosive growth can become a challenge. With constant business growth, SaaS developers will spend a great deal of time writing complex logic statements in response to changing architecture and other operational issues. Using a flexible database, this becomes effortless. You select a script and submit the task to the Azure SQL Database to complete the implementation of the script across a multitude of databases. Elastic Database Pool can simplify the production and administration of apps across many databases. Because it can inject an app into one or thousands of databases and uses the well-known T-SQL and ADO.NET programming model for ease of use, you can still run a centralized query, for example pull a report from across a number of databases, and return a unified result.
Supports flexible expansion and more predictable performance
With the support of Azure’s powerful features, high throughput apps can be flexibly extended among thousands of databases. New SQL Database service level apps can easily extend or contract on each database, obtaining predictable performance. The flexible extension of the Azure SQL database can simplify the development and administration of apps and their lateral extension over a large number of databases.
Flavorous connected its on-premises and cloud environments using a hybrid architecture that supports massive scale-out, to cope with temporary spikes and develop new business.
Enhance the business continuity of your most critical apps
Built-in auxiliary functions and database levels are provided in the 99.99%* Service Level Agreement (supported by 21Vianet), so you can feel relieved about data availability. By using the continuity built into different service levels, you can get even better app continuity for appropriate protection against catastrophic events. The Premium version of SQL Database provides active regional redundancy that can allow you to build up to 4 readable copies in the Azure zone, providing control of a failover whenever and wherever it occurs. Through automatic restoration, it provides even better control over recovery from a setback. Clients can use a backup copy to control the entire process of data restoration. In the Premium version, SQL Database will be backed up for 35 days, so that you can recover at any time.
*99.99% run-time service level agreement is only available on Basic, Standard, and Premium service levels. SQL Database Web edition and Enterprise edition provide a 99.9% run-time Service Level Agreement.
By deploying disaster recovery solutions and regional redundancy, MYOB can be expanded to thousands of databases based on your needs.
The service can manage itself automatically, almost eliminating the need for human maintenance
SQL Database services include automatic software repair functionality so you don’t need basic architecture defense. At the same time, copies of internal systems can help you provide intrinsic data protection, to ensure continuous database run-time and system stability, allowing developers and architects worry-free use. Malfunctions happen in old computer equipment all the time and a copy of the system can be automatically moved over to the system configuration of a new computer.
Pottermore migrated its applications to an Azure PaaS, which eliminated the hard work of managing and maintaining virtual machines.
It uses the Dv2 series of virtual machine functionality
The Dv2 series virtual machine is an improvement over the D series virtual machine and provides an even stronger CPU that under identical storage and configuration conditions runs 35% faster. The Dv2 series is based on the newest generation 2.4 GHz Intel Xeon E5-2673 v3 (Haswell) processor and uses Intel Turbo Boost technology 2.0, which can exceed a speed of 3.2 GHz. Speaking of the need for an even faster CPU, better local disk performance, or higher enterprise-level storage apps, the combination of the Dv2 series and the D series offers enhanced functionality.
Supports well-known tools and platforms, raising work efficiency
Propelling operational tasks through programmable APIs (for example outward extension or business continuity), while at the same time making it simpler to manage the expansion process from hundreds to thousands of databases. SQL Database provides more administration tools, for example REST API, PowerShell, support for the HTML5 Azure administration portal, and SQL Server administration, while still supporting common platforms and technologies (including .NET, Java, PHP, Ruby on Rails and Node.js). Together with Visual Studio integration, it can carry out seamless online/offline development as well as development of local apps and apps designed for the cloud. By supporting the DAC framework (permitting migration between local and the cloud), currently existing apps can be expanded into the cloud.
Samsung’s globally-focused SmartTV business simplified development, lowering costs by 80%. The Premium edition of SQL Database supported thousands of users simultaneously signing in online and led the market in Smart TV services.
Supports compliance-related tasks
SQL Database is already the major authentication mechanism for auditing the cloud, and this authentication already includes Azure, compliance authentication, HIPAA BAA, ISO/IEC 27001:2005, FedRAMP and European standard authentication.
“The firewalls and security deployed in SQL Database are already very strong. Our cloud services now have the same security as our internal data center services.” BetOnSoft Chief Software Architect Devan Govender.
Pairing up different levels of service supports innovative planning
SQL Database provides many different levels of service and can support different types of database workloads (from light to heavy). Change your service level based on your application design needs or pair up different levels accordingly. Drawing support from Azure’s powerful capabilities, you can pair Azure services with SQL Database to meet the needs of unique and modern apps. This will lower costs and raise resource efficiency, breaking new ground for business opportunities.