Twilight Timezone: Date and Time Architecture in your Applications aka Use DateTimeOffset, Your Future Self Thanks You
Thanks to everyone at a joint meeting of the Baton Rouge .NET and SQL Server User Groups who joined my...
2017-09-14
429 reads
Will Assaf
Change RegisterAllProvidersIP setting on an existing Availability Group
Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...
2017-08-17 (first published: 2017-07-30)
20,949 reads
SQLSat Planner's Calendar
We just completed our 9th annual SQLSaturday Baton Rouge. In my post-mortem of the event, I've updated and tweaked the...
2017-08-04
383 reads
Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge
Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern...
2017-07-31
654 reads
SQLSaturday Baton Rouge at LSU on July 29
The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th...
2017-07-19
440 reads
Celebrate Your Independence with Free Tools
Been working on this blog post for a while, thought I'd share today an inventory of tools I use regularly...
2017-07-04
769 reads
SQL Server Permissions and Security Principals on UserGroup.tv
You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a...
2017-06-30
673 reads
Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016
In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment...
2017-06-29 (first published: 2017-06-21)
907 reads
A Big July Planned in Baton Rouge
Three big events planned in Baton Rouge this year that everyone can be a part of:
User Groups Networking Night at...
2017-06-23
589 reads
Great to see you at SQLSaturday Houston 2017
Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers....
2017-06-17
297 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