About Me

Featured

I am passionate about using Microsoft Technology. Specialising in the Data Platform leveraging the power of Microsoft Azure – SQL server, Azure SQL DB, Azure SQL DW, Elastic Pools, Managed Instances, Azure Databricks, basically anything about data!

So any questions/ feedback – please Get In Touch

Copyright ©  in accordance with the Copyright, Designs and Patents Act 1988. All rights reserved. You are free to use any of the content here for personal use but need permission to use it anywhere or by any means (electronic, mechanical, photocopying, recording or otherwise).

 

Azure DB for MySQL – Single server vs Flexible

When you start the build process for MySQL you will be shown the below screen, the question is what option would you select?

Continue reading

Azure Database for MySQL

SQL Server is not the only database you build and deploy into Azure. Another very popular option is MySQL. Going back many years, this was actually my first database technology that I ever used so its great seeing it within the Azure eco-system, it has always been a popular choice as seen below.

Continue reading

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