Getting the Azure DTU Calculator to work on a 2008R2 OS w/ a 2008R2 SQL Server Instance
Hello everyone! I recently had to do an analysis of a client’s database workload using the Azure DTU Calculator(DTU Calculator)...
2018-04-24
1,202 reads
Blog Posts
How To Recondition Batteries
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
23 reads
SQL Saturday Dallas half-day precon: “Beginning Programming with Powershell”
On May 18 we will be presenting a half-day of PowerShell learnin', right before SQL Saturday Dallas! Read up and...
2018-04-24
349 reads
The Forgotten Fourth SQL Server Recovery Model
Watch this week's video on YouTube
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for backup and recovery purposes...
2018-04-24
4 reads
The Forgotten Fourth SQL Server Recovery Model
Watch this week's video on YouTube
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for backup and recovery purposes...
2018-04-24
10 reads
Command shell steps in SQL Agent jobs only process a single command.
I was working on a SQL Agent job recently that required a series of command shell commands. And it would...
2018-04-23
919 reads
Configure Min and Max memory in Reporting Services
As any of the available SQL Server services, Reporting Services will use all of the server memory if needed, in...
2018-04-23
15,047 reads
Get SQL server database size, location and volume info using DMVs
SELECT * FROM sys.master_files AS f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v;
2018-04-23
326 reads
How to Perform Database Hack-Attach
This blog demonstrates attaching a database on the SQL Server Instance which already has the same name database up and...
2018-04-23
1,814 reads
I’ve gotten a transaction log full error but when I look it’s not full??
Every now and again I’ll get an error telling me a transaction log is full. This can be for any...
2018-04-23 (first published: 2018-04-16)
2,287 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Forums
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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