Creating Azure DB for MySQL – Single Server
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
33 reads
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
33 reads
When you start the build process for MySQL you will be shown the below screen, the question is what option would you select? It really does depend; I don’t...
2022-01-19
379 reads
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
52 reads
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
96 reads
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
128 reads
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
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
10 reads
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
133 reads
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
95 reads
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)
194 reads
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers