Developers building software-as-a-service (SaaS) applications can leverage SQL Database to provide flexibility to support both explosive growth and profitable business models. For workloads with unpredictable database resource consumption, the elastic database model provides you with the ability to pool resources to be leveraged among a group of databases. Instead of overprovisioning to meet peak demand, you can use an elastic database pool to let hundreds or thousands of databases leverage resources within a budget that you control. You can drive cost efficiencies with a purchase model that allows you to maintain control over price and performance across a group of databases.
Simple management tasks become complicated when you scale to thousands of databases, and that's the challenge of explosive growth. SaaS developers spend countless hours writing complex logic to handle these schema changes and other administrative operations as the business grows. With elastic databases, life becomes easier. You take a script, submit it as a job, and Azure SQL Database does the rest to perform the script across many databases. Elastic database tools simplify building and managing applications that scale across lots of databases, so building applications against a single database or thousands of databases is just as easy using familiar T-SQL and ADO.NET programming models. You can also run centralized query operations like reporting and data extractions spanning many databases, returning a single unified result set.
Backed by the power and presence of Azure, high-throughput applications can take advantage of the latest version which delivers 25% more Premium database power. Additionally, internal tests over 600 million rows of data show up to 100x query performance improvements when applying the In-memory columnstore technology. The SQL Database service tiers enable applications to easily scale-up or down predictable performance on each database.
Gain peace of mind over data availability with built-in replicas and a competitive 99.99%* Microsoft-backed SLA at the database level. Enjoy more application continuity and protection against catastrophic events with built-in continuity options across the service tiers and now with as much as 360x lower disaster recovery objectives. Active geo-replication, allows you to create up to 4 readable secondaries in any Azure region, and control when and where to failover. Gain more control over “oops recovery” with self-service restore which offers customer control over data restoration from available data backups. Up to 35 days of backups available to you for recovery.
* The 99.99% uptime SLA applies to Basic, Standard, and Premium service tiers only. SQL Database Web and Business Editions have an established uptime SLA of 99.9%.
Remove virtually all infrastructure maintenance with SQL Database which provides automatic software patching as part of the service. Meanwhile, built-in system replicas using the quorum writes technique help deliver inherent data protection, database uptime and system stability which means less hassle for developers and architects. System replicas are automatically moved to new machines which are provisioned on-the-fly as old machines fail.
With a near-complete SQL Server programmable surface area, you can more easily migrate on-premises SQL Server applications to Azure to help drive down datacenter costs and improve IT productivity. Full-Text Search, now in preview, allows fast and flexible indexing for keyword-based query of text data stored in tables. Drive DevOps tasks such as scale out or business continuity via programmatic APIs for streamlined management as you scale to hundreds or thousands of databases. SQL Database offers a choice of management tools; REST APIs, PowerShell, the Microsoft Azure portal with HTML5 support, or SQL Server Management Studio and supports a choice of popular platforms and technologies, including .NET, Java, PHP, Ruby on Rails, and Node.js. Enjoy seamless development on or offline and across on-premises and cloud-designed apps with Visual Studio integration.
SQL Database offers a portfolio of security features to help you further meet organizational or industry-mandated compliance policies. Streamline compliance-related tasks and gain knowledge about activities taking place within your database with Auditing which tracks and logs events that occur on your database. You can also implement policies at the database level to help limit access to sensitive data with Row-Level Security (preview), Dynamic Data Masking (preview), and Transparent Data Encryption (preview). Additionally, SQL Database is verified by key cloud auditors as part of the scope of key Azure compliance certifications and approvals such as HIPAA BAA, ISO/IEC 27001:2005, FedRAMP, and E.U. Model Clauses.
"The firewall and security configurations in SQL [Database] are great. Our cloud-based services are now as secure as our data-center-based services."
SQL Database is offered in different service tiers to support light-weight to heavy-weight database workloads, so you can move across or blend the tiers together for innovative application designs. With the power and reach of Azure, you can mix-and-match Azure services with SQL Database to meet your unique modern app design needs, drive cost and resource efficiencies, and unlock new business opportunities. Visit the SQL Database pricing page for more details.