All About SQL

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...

2022-01-11

48 reads

SQL Managed Instances – Cross Instance?

by Arun Sirpal

All About SQL

There is a setting / feature in Managed Instance worth talking about, it is called SQL Trust Groups. What is this? At a basic level it’s a way to...

2021-12-15

94 reads

SQL Managed Instance – Failover Groups Quick Tips

by Arun Sirpal

All About SQL

Lets summarise some important learnings about SQL MI and failover groups. when you add a database to a failover group the secondary database has the same edition / compute...

2021-12-09

124 reads

SQL Managed Instances – Failing Over

by Arun Sirpal

All About SQL

This is our current setup shown below. There is not much to failing over with Managed Instances, from experience it is similar to that of Azure SQL Database. Let’s...

2021-12-17 (first published: 2021-12-07)

263 reads

Failover Groups for Managed Instances

by Arun Sirpal

All About SQL

If you have been following me for a while you will know that I really like the Fail over groups within Azure SQL DB and it is no different...

2021-11-22

9 reads

Azure SQL Managed Instance – Premium Tier

by Arun Sirpal

All About SQL

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...

2021-11-10

131 reads

Azure SQL Managed Instance CPU and RAM

by Arun Sirpal

All About SQL

With SQL Managed Instance you will need to consider your configuration requirements in terms of core count for the CPU and memory, which we all know that the MIN/MAX...

2021-11-01

92 reads