Enumerating Index Fragmentation with Powershell and SMO
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,734 reads
Blog Posts
Jacksonville IT Pro Camp 2012 Presentation
Presentation and scripts from my Integrating SQL Server PBM with SCOM session at Jacksonville IT Pro Camp 2012.
2012-06-19
1,172 reads
PASS Summit 2012
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....
2012-06-19
787 reads
Speaking at PASS Summit 2012
Today I’m thrilled and humbled to announce that I will be speaking 3 times at PASS Summit in November 6-9! ...
2012-06-19
1,000 reads
SQL Server 2012 RTM Cumulative Update 2
Last night, Microsoft released SQL Server 2012 RTM Cumulative Update 2, which is Build 11.0.2325.0. It has 37 fixes in...
2012-06-19
1,782 reads
Status Column in SSISDB Catalog Database
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped...
2012-06-19
1,213 reads
The First Interview: What companies do that make me want to run far, far away
I’ve recently been asked for some clarification about this statement (from my last blog post): “This is EXACTLY the kind...
2012-06-19
774 reads
T-SQL Tuesday 31: SSIS 2012 Logging
Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a...
2012-06-19 (first published: 2012-06-12)
3,792 reads
Two New Cumulative Updates for SQL Server 2008 R2
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. The first one is SQL Server 2008 R2...
2012-06-19
1,129 reads
X-XMLA: iv. Deploying Databases with XMLA
The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services...
2012-06-19
906 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