Azure DB for MySQL – Storage v1 vs v2
When it comes to MySQL and storage you will normally have to decide on 3 options: basic, general purpose v1 or v2. Basic does support up to 1TB and...
2022-02-07
18 reads
Arun Sirpal
Connecting to Single Server MySQL
We have already created the server now it’s time to connect to it. What you will need – connection string details, correct networking setup and a tool like MySQL...
2022-02-03
20 reads
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
40 reads
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? It really does depend; I don’t...
2022-01-19
388 reads
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...
2022-01-11
57 reads
SQL Managed Instances – Failing Over
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)
266 reads
SQL Managed Instances – Cross Instance?
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
100 reads
SQL Managed Instance – Failover Groups Quick Tips
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
130 reads
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
14 reads
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
139 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers