[Video] SQL Server Deadlocks
SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...
2017-09-08 (first published: 2017-08-24)
1,985 reads
Arun Sirpal
DBCC CHECKDB Azure SQL Database
Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...
2017-09-04
740 reads
Azure SQL Database – Scaling up
Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...
2017-09-01 (first published: 2017-08-23)
1,303 reads
SSMS and MFA support for Azure SQL DB
Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...
2017-08-30
2,203 reads
Azure Cloud “Fear” Busting #4 – Losing Control?
So the decision to move to the cloud has been made but there is a fear from people that once...
2017-08-25 (first published: 2017-08-14)
924 reads
Azure Automation and SQL Index Maintenance
Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...
2017-08-21
939 reads
SQL Server – So you like to shrink do you?
If you do – shame on you and shame on me because I do.
Moving on, I found strange behaviour within SQL...
2017-08-16
372 reads
Interviews and Oranges
What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/
The topic being: Interviewing Patterns and Anti-Patterns....
2017-08-08
313 reads
Azure Cloud “Fear” Busting #2 – Seeking for Better Performance
We all want high performing applications and when you are in the cloud that is no different, if anything it...
2017-08-07 (first published: 2017-07-20)
1,367 reads
Azure Cloud “Fear” Busting #3 – There is no going back?
Once you go cloud, there is no going back. This is false and from a database perspective you can migrate...
2017-08-07
432 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