More IMPORTANT miscellaneous info
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.
Okay,...
2012-04-19
1,270 reads
Blog Posts
PowerShell: Using Exponents and Logs to Format Byte Sizes
In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to...
2012-04-19
3,931 reads
script system object in resource database
When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...
2012-04-19
1,024 reads
Spend two hours with me at #sqlsat107.
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen...
2012-04-19
640 reads
SQL Server 2012 Performance Test: Gap Detection
Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...
2012-04-19
3,287 reads
Tribal knowledge is no knowledge
I've run across several incidents in the last couple of months regarding something that is typically called "tribal knowledge." This is...
2012-04-19 (first published: 2012-04-12)
1,302 reads
Using sys.dm_exec_requests to find a blocking chain and much more
As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.
I've added the following features:
The query execution...
2012-04-19
3,461 reads
Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE...
2012-04-19
33 reads
Why Isn’t There A Deployment Server Edition For SSIS Projects?
Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any...
2012-04-19
1,509 reads
Custom TDS Endpoints: Listening on multiple ports
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to...
2012-04-18
2,169 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