Your Devs' Questions Answered With sys.dm_server_services
It starts with "I'm a developer...
"... with no RDP access, how can I tell if the SQL Server Agent service...
2015-08-20
819 reads
SQL Tact
See you at SQL Saturday Baton Rouge 2015!
SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day...
2015-07-19
592 reads
SQL Server Permissions and Security Principals at Houston SQL Saturday 2015
Thanks to everyone who attended my presentation on SQL Server Permissions and Security Principals this morning at Houston SQL Saturday...
2015-06-13
469 reads
Error Upon First Processing Your SSAS Database With A Service Account
This blog post is to document the easy fix to a problem that has become a rite of passage for...
2015-06-11
2,462 reads
Behavior of ORDER BY + UNION Can Be Confusing
This is an interesting example and it exposes a quirk with the concept of a UNION, which is, that the...
2015-06-10 (first published: 2015-06-08)
3,226 reads
See You Next Weekend at SQL Saturday Houston!
Looking forward to speaking next weekend at SQL Saturday Houston 2015 on June 13!
If you haven't already registered for this...
2015-06-05
511 reads
Fresh New Horror: PK on a Float Data Type
Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after...
2015-05-18 (first published: 2015-05-11)
670 reads
SSRS Utility Reports: Subscription Inventory, Failed Subscriptions
When delivering a SQL Server Reporting Services (SSRS) solution with lots of subscriptions, it's helpful to also include some utility...
2015-05-05
1,305 reads
Live Microsoft Event - Power BI Dashboard in a Day - Baton Rouge
Join BRSSUG Founder and Microsoft TSP Patrick Leblanc to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI. In...
2015-04-09
700 reads
Announcing: SQL Saturday Baton Rouge 2015
SQL Saturday Baton Rouge 2015 is coming up on August 2 at LSU, register today!
Email or instant message your friends, post...
2015-03-22
755 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