Results of PASS Summit 2010 Content Survey Released
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
535 reads
Blog Posts
SQL Server 2008 R2 reaches RTM
On April 21 Microsoft announced SQL Server 2008 R2 has been released to manufacturing.
The downloads on Technet/MSDN on May 3....
2010-04-22
403 reads
SQLSaturday 31 Chicago: Recap
Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d...
2010-04-22
658 reads
The Knowledge... (quote)
The quote about Knowledge, sure it is Albanian quote:
Learn the Knowledge but you'll never get rewarded by the God(All-llah) until...
2010-04-22
1,366 reads
What is a Good Way to Quickly Disable SQL Agent Job Schedules?
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
456 reads
2010 Scripting Games
Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...
2010-04-21
764 reads
A DMV a Day – Day 21
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,584 reads
Attending Microsoft Most Valuable Professional Open Day from Montreal
Currently, MVPs from across the country are attending an all day event.
We are discussing Azure, Windows Live, Office 2010, Windows...
2010-04-21
673 reads
Big SQL Server Announcement This Morning at 7:30AM PDT
Microsoft’s Ted Kummert and Tom Casey are holding a public conference call this morning at 7:30AM Pacific time, where:
Microsoft...
2010-04-21
730 reads
Free E-Book on SQL Server 2008 R2
Free E-Book on SQL Server 2008 R2
Ross Mistry and Stacia Misner have done a wonderful job on this free e-book
http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx
You...
2010-04-21
3,688 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