Failover Groups for Managed Instances
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
8 reads
Arun Sirpal
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...
2021-11-10
122 reads
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...
2021-11-03 (first published: 2021-10-19)
162 reads
Azure SQL Managed Instance CPU and RAM
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
23 reads
Restoring to Azure SQL Managed Instance – Part 2
So in the last blog we confirmed that we could move to SQL MI via some analysis, this is now time to actually do a backup and restore via...
2021-10-12
8 reads
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...
2021-10-07
97 reads
Creating Azure SQL Managed Instance
First step login into the Azure portal and find SQL Managed Instance and click create. Yes you can find these tutorials all online but this is my thinking and...
2021-09-14
110 reads
Azure SQL Managed Instances
After many years working with different “flavours” of SQL server in Azure from its true PaaS form to SQL server in AKS (Azure Kubernetes Service) it’s time to look...
2021-08-12
160 reads
Azure Kubernetes Service – Handy Commands
Just some handy commands to use via kubectl. I found these useful for various reasons so hopefully you will too. Overview of our nodes. Pod information, remember from my...
2021-08-11
35 reads
Creating SQL Databases in AKS with PVC – Part 2
Last week I created the below with a dummy database and is something that I will do against SQL server but this time that has a persistent volume claim....
2021-08-09
37 reads
Blogs
Daily Coping 17 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The book that made me love goal-setting
By Jen McCown
Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...
Daily Coping 16 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Error : Sql Query
Hi, I'm struggling to solve this problem. count, for each couple of stations, the...
SQL Query
Hi, I'm struggling to solve this problem....I hope will get a answer here. count,...
Combine or join 3 tables, 1 for each databases
Hello guys, I hope you're all great and healthy I would love to learn...
Ask SSC