>> Learn how to use the Azure Database Migration Service to
provide simplified migration and modernization to Azure.
On this episode of Data Exposed.
>> [MUSIC]
>> Hello, everyone. I'm your guest host,
Buck Woody sitting in this week for Anna Hoffman.
For today's conversation, we're going to dive
into Azure Database Migration Service,
and learn how it provides
a simplified migration and modernization process to Azure.
Over the next couple of minutes,
you're going to learn how to assess
your On-premises SQL Server instances and your databases,
when migrating to SQL Server on Azure Virtual Machines.
Now I'd like to introduce,
Logan and Carlos, welcome.
Logan and tell us a little bit more about yourself.
>> Hi, Buck. Thank you for having us today.
It's a great thing am back. My name is Logan Carrington.
I remember the Azure Relational Database marketing team,
books and Product Marketing for
SQL Server and Azure Virtual Machines. Am excited to be here.
>> Fantastic. We've also got Carlos, today.
Introduce yourself, Carlos.
>> Hi, Buck. I'm happy to be here back again.
My name is, Carlos Robles.
I am a Senior Product Manager aimed at Data Modernization team.
This team is responsible for building
the different migration tools
our customers use to migrate to Azure.
>> Fantastic. Carlos,
what is Azure Database Migration Service,
and what can customers do with accessing the service?
>> Sure. Azure Database Migration Service is
an Azure service designed to
provide a seamless migration experience to our customers.
The Azure SQL migration extension for Azure Data Studio,
it's powered by the DMS service.
But let me share my screen really quick to explain how it works.
Routines starts in the on-premises environment where
our customers have to install
Azure Data Studio within Azure Data Studio,
they can stall the Azure SQL migration extension
for Azure Data Studio and what these extension is doing.
Extension will help them to get these simplified experience,
to understand the migration readiness
from the existing environment,
then they can get Azure recommendations,
and finally migrate on performing on,
online or offline migration to a different
Azure SQL targets we support.
Those are Azure SQL MI.
SQL Server and Azure SQL BM,
which is a topic today in Azure SQL Database.
That's it. That's how ISI customer scan
installing use the Azure SQL
extension migration for Azure Data Studio.
>> Nice. Logan,
what's with the new skews for
SQL Server on Azure Virtual Machines.
There's been some new ones out right?
>> Yeah. Actually great question,
but the skews or SQL Server and Azure,
which machines have some exciting news,
the latest news is the new larger size that
EBD SP5 in premium SSD v2, N96,
BDS v5, and the 1-12 ID VDS V5,
Vms just went public preview back
not to wear 2022, not too long ago.
Also view SSD V2 is only in limited GA,
some considering that new,
especially since it will not be widely
available to Customer little later this year.
Adding on to that point,
liberal three times increase in Vm to
disk throughput and IOPS and regenerations,
the DB4 series is actually ideal,
for large databases and data analytic applications.
Also, you now have access to remote store performance
with 120,000 IOPS and 4,000 mb/s,
which is in relation to the output which is offered
with and without local temporary storage.
All these exciting latest updates,
an EPSP 5,
and even just V5 series virtual machines are also
optimizing your virtual machine series
with higher mode stored performance,
and once again, to exert this point,
it's clear there's a generally available now.
To add on to that, my colleague Pamela Hood,
which wrote a great blog,
there'll be a link below this video,
on these exciting update with
30 percent better price performance on the new EVD SP5 VM-Series,
if a customer is interested in learning more.
>> Wow, that's awesome.
Logan, this is great news in
reference to what is new with the e b,
d s V5 VM-Series for SQL Server on Azure Virtual Machines.
But what about that premium SSD v2 D storage?
>> Premium SSD V2 D storages,
as I said before, are generally available,
and here customers are able to have a data
intensive workloads improve with low latency,
and high-performance combined with higher IOPS,
and throughput with lower costs and high durability.
Premium SSD V2 D storage is also flexible with higher performance,
which also have a skilled capacity and
IOPS mutual requirements always nano reduces
costs and user maintenance and scaling
process in previous D storage versions,
it also highlights in reference to scanning
force up and down without downtime.
>> Now, that's just great.
Logan, thanks for explaining those latest updates.
Now, building on this point, Carlos,
how does the customer assess
their on-premises SQL Server workloads to migrate,
to the right skew on an Azure vm?
>> Sure. I was explaining before they can
use the Azure SQL migration extension for that.
Let me share my screen really quick again and induces light,
I am explaining how the process works.
Once the SQL migration extension is installed
within the extension and we have the option to
collect performance data from existing environment.
Collecting these data from Lisa Martin means that will be,
I'll use MDM bees to understand that existing workload,
and then it will generate some output files.
These files will contain all these performance data.
For later, this Q recommendation engine
is going to analyze the output in
provide our customers with recommendations
to the right-skewed that fits beds for the workload.
Again, we support all the different targets
in SQL Server and Azure SQL BN,
it's one of the most popular one.
>> Fantastic. Listen, thanks,
Logan and Carlos, we got a lot of information today.
Now to learn more about Azure Database Migration Service,
and the skews that are best for
the SQL Server on Azure Virtual Machines,
check out the docs pages,
and those blog posts that we listed below this video.
Well, we'll see you next time on Data Exposed.
>> [MUSIC]