Azure Essentials: Database options

Azure Essentials: Database options


– Welcome to Azure Essentials
on your database options. With Azure you’ve got the flexibility to modernize your data platform on your terms either using Azure
hosted database options, or using some of the many
database as a service options. And if you choose, you
can use these alongside your existing on-premises
database sources. This gives you the flexibility
to use the database services that best serve your technology and compliance requirements. In the next few minutes
I’ll take you through the database options available to you. Let’s start by looking at
the relational database options in Azure. You can extend your current data estate to the cloud using Azure data services, like site recovery, storage,
and high availability groups to create efficient,
hybrid implementations for fail over disaster recovery. Azure infrastructure
as a service, or IaaS, provides you with a secure
and familiar platform on which to run your databases
inside virtual machines. Azure VMs support the majority of Windows and Linux supported databases, and you can move your databases and apps without major change to how you
use or maintain the systems. They just exist in the cloud,
saving you the overhead of running them in your own data center. Alternatively, Azure offers
a range of relational database as a service offerings. These include Azure SQL Database, Azure SQL Database Managed Instance, Azure Database for MySQL, and Azure Database for PostgreSQL. Whether you choose to host your database in Azure ISVMs, or you decide to take advantage of Azure database
as a service offerings, planning a lift and shift to Azure is a streamlined process
when you use the new Azure database migration service. The service provides automated workflows to help you plan your
migration, which includes assessment reporting to guide you through any necessary changes prior
to performing your migration. And after completing your
assessment, you can then migrate different database technologies, such as your on premises SQL server to your database service
of choice in Azure. This also includes the ability to migrate your Oracle on premises databases. Now if you’re also
planning to add analytics to your data estate,
technologies like Azure SQL data warehouse will help
you grow and optimize your business processes. Azure SQL data warehouse is the first elastic petabyte scale
cloud data warehouse that takes only seconds to scale. A core advantage is the
ability to scale compute and storage independently, which in turn enables what we call burst compute. This gives you a burst of compute power as needed to support complex
analytical workloads. Azure SQL data warehouse
in fact works seamlessly with Power BI, Azure Machine Learning, HD Insight, and Azure Data Factory, and because its parallel
processing architecture enables distributed
processing, it’s capable of immense compute power. So those are your options
for relational databases. Now Azure non-relational and distributed database options include Azure Cosmos DB, and Azure Data L Store. For a full managed database service, Azure’s Cosmos DB is
a globally distributed operational database that
supports multiple models. Azure Cosmos DB can replicate your data around the world allowing
every user to be near a copy of their data. Because it’s schema agnostic,
it allows you to use key value, graph, and document data together in a single service. Now core to Azure Cosmos DB is the concept of consistency models,
where you can select up to five consistency
models for your application to ensure data consistency
and reliable performance. Whichever models you choose to use, Azure Cosmos DB automatically indexes all the data for you and
then provides you access by your preferred method. Or you may wish to use
it against applications designed for mongoDB
or Azure Table storage. With Azure Cosmos DB you can elastically and independently scale
throughput and storage across any number of
Azure’s geographic regions. This provides detectable throughput, consistency, and high availability. And it’s ideal for scenarios
working with globally distributed mission critical apps as well as retail e-commerce, IOT, mobile, and gaming applications. And finally, there’s
Azure Data Lake Store, which gives you a massively
scalable, secure data store. It’s capable of storing any type of data including data sets comprising
trillions of objects and files, each up to petabyte in size. And it’s designed for use
with big data scenarios with examples ranging from
high resolution video, to genome datasets, and it
supports the HDFS standard. So as you can see, with
Azure you have a broad range of database options
that can help you modernize your entire data estates,
whether you decide to go with 100% cloud database strategy, or you choose to extend
your platform capabilities with a hybrid implementation
that spans both on premises and cloud data sources. The options are there for you. You can take advantage
of additional learning experiences at the links shown,
and of course, keep checking back to Azure Essentials
for additional topics.

Danny Hutson

Leave a Reply

Your email address will not be published. Required fields are marked *