Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1
Learn how to create a Windows 2008\SQL Server 2008 virtual cluster in this three part series.
2011-07-11
14,187 reads
Perry Whittle
Using Disparate File Paths in SQL Server Database Mirroring
Learn how you can setup Database Mirroring using disparate file paths and drive letters.
2011-03-01
6,885 reads
Slipstreaming SP\CU During Setup
This article shows how to slipstream the SP and CU during the SQL Server setup process.
2010-12-27
3,920 reads
Clustered instance will not start after removing builtin admins
After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things.
2010-04-16
1,484 reads
Setting up a SQL cluster under MS VS2005 R2 Part2
Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article.
2009-05-15
3,929 reads
Setting up a SQL cluster under MS VS2005 R2 Part1
This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.
2009-05-13
5,152 reads
2009-01-08
9,721 reads
Blogs
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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