Modernization Hub

Modernization and Improvement
How to modernize SQL Server environments with Azure | Azure Friday at Build 2018

How to modernize SQL Server environments with Azure | Azure Friday at Build 2018


>>Hello, everybody,
this is Lara Rubbelke, I’m here with Azure Friday, a special edition
of Azure Friday, we’re calling it Azure Friday
on the Go here at Builds. And we’re taking a little bit
of Build to you, to help you see what we’re
experiencing on the floor. And today, I’m here
with Kevin Farlee, he is the PM on the Core Processing Engine
Team for SQL server, and he’s going to talk
to us about how you can modernize your SQL server
environments with Azure.>>I’ve been talking
to a lot of customers lately that have
a problem in that, they’ve accumulated
lots and lots of databases and haven’t necessarily
kept them up to date. One particular customer,
has over 30,000 SQL Databases going all
the way back to 2005. And they’ve realized that that is a significant security risk, so they’re in the process
of modernizing them. They want to know how
they can keep from getting back into
that hole again. So, what we’ve been
working with them to design is
a migration from their current on premise instances at whatever versions they are
up to an Azure SQL Database. Once they land in an
Azure SQL Database they never have to worry
about upgrading again.>>Right.>>It’s an ever
green environment.>>Because we take care of
all of the upgrades for you.>>Exactly.>>Absolutely. This week we made
a couple of announcements that would help somebody
like that customer, as well as a lot of
our other customers in that same situation. Talk to me a little bit about the database migration service that we just announced this GA.>>So, database migration
services, this what it says, it will analyze your current
databases and applications and determine what has to happen to move them up to
the current version of SQL, from whatever old version or
even competing platforms. And it will automate everything
that it can be automated and then give you guides for those things that
need the human touch. So, it smooths that it can run in continuous mode which will keep replicating
changes up into Azure. So it’ll move your
database and then keep them in sync in one direction.>>That continuous mode is pretty important for mission
critical applications.>>When you’re making
that transition.>>Absolutely, there are
a lot of customers that can’t take that downtime to backup and restore a multi-terabyte
database into Azure and wait for weeks
for it to come online, so continuous mode that’s going to help in
those situations?>>It’s going to be huge.>>Fantastic. In
addition to that, database migration
service, we have some additional services and updates that we’ve announced. For example, the Database
Managed instance.>>Right.>>Talk to me about Azure SQL
Database Managed Instance.>>So, we’ve had some customers that have trouble moving up into Azure SQL Database because their applications depend on the richness of
a whole SQL instance, and Azure SQL Database gives you just a connection
to a single database. Fully managed, all
that’s taken care of, but if you depend on agent scripts or multiple
database transactions.>>Cross database joints.>>That’s where they’ve
had challenges.>>Lots of cross database joints.>>So, with Azure
Managed Instance, you have all the managed
service advantages, but you have access to the richness of
a full SQL Instance, and this concept is something
to understand really well. Azure SQL Database now
has three flavors, so it can be delivered
in three ways. There’s Single database, it’s just what you’ve
seen all along. Plastic pools are a way
of packaging multiple of those single databases into
a pool of shared resources. And now, we have
Managed Instance, which gives you the richness of a Full Instance, and of course, you can have multiple databases within the Instance, Jobs, all the rest that
you’re used to having, so there is far less friction for your application moving.>>So, the combination of the Database Migration Service
with the Managed Instance.>>That’s really powerful.>>That’s really powerful, that’s like the peanut
butter and chocolate coming together and that’s
all goodness, right? So, by combining these two, we actually make it a lot easier for people to
migrate to Azure and get their application databases as modernized to
the latest version of SQL.>>Absolutely.>>Great. So, where can
we go to learn more? I know that we’ve got
this page here and I know that there’s
also a short link.>>So, aka.ms.migrateto.>>MI.>>migratetoMIusingDMS.>>Fantastic.>>There’s a link.>>And this is going to walk you through everything you need.>>The whole process,
for the prerequisites. What do you need to do? How do you set it up? And we’ll walk you through
the whole process.>>Fantastic. Well, thank
you very much Kevin, it’s really nice to talk to you.>>Thanks.>>So, today we were talking about Data Platform
Modernization with Managed Instance and
Database Migration Service with Kevin Farlee
today on Azure Friday.

Leave a Reply

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