Azure SQL Database

Azure SQL Database

Azure SQL Database is a relational database service (DBaaS) based on the latest stable version of the Microsoft SQL Server Database Engine. SQL Database is a high-performance, reliable and secure database that you can use to create data-driven applications and websites in your chosen programming language, without having to manage infrastructure.

Learn how to use SQL databases through our Quickstarts program, tutorials, and samples. SQL databases are services that are managed for general relational databases in Microsoft Azure that support structures such as relational, JSON, spatial, and XML data. The SQL database provides performance that can be expanded dynamically under two different purchase models: a vCore-based purchase model and a DTU-based purchase model.

The SQL database also provides options such as column storage indexes for extreme analytics, reports, and OLTP analysis in memory to handle maximum transactions. Microsoft processes all debugging and updates the SQL code database smoothly and eliminates all basic infrastructure management. Azure SQL Database provides the following deployment options for Azure SQL databases: as a single database with its own resource group that is managed through a logical server.

Azure SQL Database Managed Instance

As a combined database in a flexible collection with a collection of shared resources that are managed on a logical server. As part of a series of databases known as managed instances that contain system databases and users and a series of shared resources. The SQL database provides predictable performance with various types of resources, service levels, and account sizes that provide dynamic tolerance without downtime, smart default optimization, global scalability and availability, and advanced security options with almost zero management.

This capability allows you to focus on applications that are growing rapidly and speeding up your time on the market, rather than allocating valuable time and resources to manage your hardware and virtual infrastructure. SQL database services currently operate in 38 data centers around the world, with more data centers online regularly, allowing you to run databases in data centers near you.

With SQL databases, each database is isolated from each other and portable, each with its own level of service in the DTU-based purchase model, vCore-based purchase model, and guaranteed account size. The SQL database provides different account sizes for different needs, allowing databases to be collected to increase resource use and save money. With instances of SQL managed databases, each instance of another instance is isolated with secure resources.

Azure SQL Database Backup

For more information, see SQL managed databases. Using the Hyperscale service layer (preview) on the vCore purchase model, you can measure up to 100 terabytes with the ability to back up and restore quickly. Adjust performance and size without stopping. The SQL database provides a DTU-based purchase model or a vCore-based purchase model.

The DTU-based procurement model offers a combination of computing and memory resources, and OIs at three service levels to support light and heavy database workloads: Basic, Standard, and Premium. The account size in each level provides a different mix of resources, where you can add additional storage resources. The vCore-based purchase model allows you to choose the number of vCores, amount or memory, and the amount and speed of storage.

For many companies and applications, the ability to create individual databases and achieve higher performance or decrease demand is sufficient, especially if the pattern of use is relatively predictable. But if you have an unexpected usage pattern, it might be difficult to manage your business costs and models. Flexible swimming pools are designed to overcome this problem. The concept is simple. You can allocate performance resources to a collection instead of individual databases and encourage group performance resources instead of doing a single database

You can make your first application in a single, small, and cheap database every month at the general-purpose service level and then change the service level manually or programmed at any time to the Critical Business service layer to meet your needs. You can adjust performance without interruption to your application or customer. Scalability of dynamic databases allows you to respond transparently to rapidly changing resource requirements and allows you to pay only for the resources you need when you need them in Azure SQL Database.