100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 3 out of 26 pages.
Databases List – Support rapid growth and innovate faster with secure, enterprise-grade, and fully managed database services1.Azure Cosmos DB2.Azure Database for My SQL 3.Azure Database for MariaDB4.SQL Data warehouse ( SQL DW)5.Azure Cache for Redis6.Azure SQL Database ( SQL DB)7.Azure Database for PostgreSQL8.SQL Server on virtual machines9.Azure Database Migration ServiceAzure SQL Database – It shares a common code base with SQL Server. The features of SQL Server supported by Azure SQL Database depend on the type of Azure SQL database that you create. With Azure SQL Database, you can either create a database as part of amanaged instanceor you can create a database that is part of Logical server and optionally placed in an Elastic pool.Microsoft Azure SQL Database(formerly SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database)is a managed cloud database (SaaS) provided as part of Microsoft Azure.A cloud databaseis a databasethat runs on a cloud computingplatform, and access to it is providedas a service. Managed database services take care of scalability, backup, and high availability of the database. Azure SQL Database is a managed database service which is different from AWS RDS which is a container service.Microsoft Azure SQL Database includes built-in intelligence that learns app patterns and adapts to maximize performance, reliability, and data protection.It was originally announced in 2009 and released in 2010.Key capabilities include:Continuous learning of your unique app patterns, adaptive performance tuning, and automatic improvements to reliability and data protectionScaling as needed, with virtually no app downtimeManagement and monitoring of multitenant apps with isolation benefits of one-customer-per-database
Leverage open source toolslike cheetah,sql-cli,VS Codeand Microsoft tools like Visual Studioand SQL Server Management Studio,Azure Management Portal, PowerShell, and RESTAPIsData protectionwith encryption, authentication, limiting user access to the appropriate subset of the data, continuous monitoring and auditing to help detect potential threats and provide a record of critical events in case of a breachPopular use casesRelational data storage for cloud based applications and web sitesBusiness and consumer web and mobile appsManage databases for multi-tenant apps (software-as-a-service)Quickly create dev and test databases to speed up development cyclesScale production business services quickly and at a known costContainerize data in the cloud for isolation and securityOutsource database management in order to focus on value-added servicesDesignAzure SQL Database shares the SQL Server 2016 codebase. It is compatible with SQL Server 2014 and 2016 and most of the features available in SQL Server 2016 are available in Azure SQL DatabaseCompare Azure SQL DB vs SQL DWAzure SQL DatabaseSQL Data warehouse