Free Webcast: Planning a SQL Server to Azure Migration in 2021

Microsoft Azure
9 Comments

You manage database servers for your company, and they’re thinking about migrating everything to Microsoft Azure. You’ve searched the web for information and advice, but everything you’re finding is outdated.

You just want a list of things to review on your servers, an overview of what won’t work in the cloud, and how to pick alternatives or workarounds.

In this one-hour session on Thursday, March 18, we’ll cover pure technical details, zero marketing, and get you up to speed quickly with none of the fluff.

Register now for the free webcast. If you can’t be there live, no worries – links to the recordings will be sent to the registrants. And if you’ve got questions you’d like to see me touch on during the webcast, you can get a jump on the Q&A by asking ’em below in the comments.

Previous Post
New SQL ConstantCare® Feature: One Serious Query to Tune
Next Post
#TSQL2sday 136 Invitation: Blog About Your Favorite Data Type (Or Least Favorite)

9 Comments. Leave new

  • Would love to attend. Thanks for doing this.
    Sanjiv

    Reply
  • QA: 1) It’s always a little unclear on best practice to move the data and minimize downtime (none if possible) on the move to somewhere else.
    2) Example of Cost would be helpful. How do I size the Cloud vs. my local SQL. I have lots of Cores local, but don’t want to overpay for Cloud rental. Thanks !

    Reply
    • If you are doing full azure VMs, more cores in the cloud. Not only do Azure VMs now do a 2:1 oversubscription of their hosts (1 hyperthread per virtual CPU), you also don’t get hardly any disk I/O per core and in Azure disk i/o is tied to the number of cores in your workload. I have 4 SSIS servers each with 8 cores at over 3000 dollars per month each, that sit at about 30% cpu utilization during their jobs just to reach the same level of disk performance my laptop has.

      If you have an existing sprawl you can consolidate of course and it makes it easier to just be able to build and destroy vms as you please and economize that way but if you are already well consolidated, you will probably need more resources than you do on prem.

      Reply
  • Perfect timing – thanx Brent! Could you touch on the approaches to performance analysis in Azure SQL?

    Reply
  • Step 1: prepare for massive losses in performance.
    Step 2: substantially increase your budget for developers and hire more devs.
    step 3: come up with good ways to talk to the CEO about regular outages in Azure.

    Reply
    • that was referring to azure sql db of course. though outages in azure AD also take down virtual machines as well

      Reply
  • camila.henrique
    March 5, 2021 4:27 pm

    Great timing! I’m the only database person at work, and there’s one client who’s talking about moving their data to the cloud, for security reasons. I have no experience with Azure and will need to study.
    Q1: What should I focus on studying to begin with?
    Q2: How do you know if the cloud is a good option for you?
    Q3: Is there a “hybrid” model of on premise plus cloud? Does that happen in real life?
    Q4: In general, what are some pros and cons of Azure?

    Thank you so much for doing this! See you there (:

    Reply
  • aleksey.vitsko
    March 19, 2021 12:06 pm

    Hi Brent, I’ve missed the second half of the live session yesterday.
    Recording of the webcast and slides, are they available for download ?

    Reply

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.