Hosted SQL databases Flashcards
What are some of the Azure SQL Deployments?
SQL Servers on Virtual Machines
Managed Instances
Databases
Elastic Database Pools
What are some of the key features of Azure VMs?
SQL Server and OS server access
Expansive SQL and OS versions
Windows and Linux Containers
File steam, DTC and simple recovery model
What are some of the key features of Azure SQL Deployments?
Single instance or instance pool
SQL surface are
Native virtual network support
Fully managed device
On Premises identities enabled with Azure AD and AD Connect
What are SQL Managed Instances?
It is a PaaS deployment option of Azure SQL.
Gives and instance of SQL server but removes much of the overhead of managing a virtual machine
This option is ideal for customers who want to use instance-scoped features and want to move to the cloud without rearchitecting their applications.
Instance-scoped features are features that are tied to an instance of SQL Server, such as Machine Learning Services as opposed to features that are tied to a database in an instance of SQL Server.
SQL Managed Instance allows you to access instance-scoped features. But you don’t have to worry about, nor do you have access to, the OS or the infrastructure underneath.
What are the key features of Azure SQL Database?
Single database or elastic pool
Hyperscale storage (+100TB)
Serverless compute
Fully managed service
Private Link Support
High availability with AZ isolation
What is an Azure SQL Database?
It is a PaaS deployment option allows you to just get a database and start developing applications.
This deployment option allows you to just get a database and start developing applications.
SQL Database is also the only deployment option that supportd scenarios that require unlimited database storage (hyperscale) and autoscaling for unpredictable workloads (serverless).
SQL Database has the industry’s highest availability SLA. It provides other intelligent capabilities related to monitoring and performance partly because microsoft manages instances.
What is Elastic database pool?
Elastic DB Pools allow you to share resources among multiple instances and databases and optimise your costs.
SQL Database elastic pools allow you to host many databases within a single set of provisioned SQL Database resources. This option is ideal for a SaaS application or provider because you can manage and monitor performance in a simplified way for many databases.
SQL Managed Instance pools allow you to host multiple managed instances and share resources. You can pre-provision compute resources. Doing so can reduce overall deployment time to make migrations easier.
