Azure SQL Managed Instance – Premium Tier

In case you are not aware Microsoft have now deployed a new change to SQL Managed Instances within the tier types. In certain regions ( shown later) you can select something different to that of gen 5 hardware now called standard – more specifically premium series where you have 2 options as shown below – a much wanted request!

Continue reading

Scaling your Azure SQL Managed Instance

No doubt there will be times where you need to scale up the actual instance in terms of vCores but also you may want to move across tiers (for example General Purpose to Business Critical). If you remember a few blog posts ago I said it was really important to plan for these activities during the build phase, more specifically get the subnet range right. If you done that then you will be fine.

So how do you do this? Easy. Let’s start with the Azure Portal.

Continue reading

Restore to SQL Managed Instance

Now that we have a Managed Instance built, the next question is how do we get data across? I will break this up into separate posts but the lesson for this blog post is ANALYSIS FIRST!

Honestly, there will probably be less work needed to make the data compatible for Managed Instance, this is very true if comparing to the true PaaS offering of Azure SQL DB, but we should always check before migrating.

Continue reading

Intro to AKS – Azure Kubernetes Service

What is Azure Kubernetes Service? Probably makes sense to tell you what Kubernetes is first. As Kubernetes states themselves “also known as K8s, is an open-source system for automating deployment, scaling, and management of containerized applications.” If you want to dig into the depths then head over to Andrew – http://www.dbafromthecold.com

Continue reading