Configure Internal and Private Networking for Hyper-V Virtual Machines
In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine....
2016-12-25
2,801 reads
Blog Posts
User Contains Invalid Characters – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-24
1,918 reads
User Contains Invalid Characters – Back to Basics
While creating database users, it is possible to encounter an invalid character error message. This article will help clarify the error message.
Related Posts:
Changing Default Logs Directory - Back...
2016-12-24
232 reads
Column and table constraints
Column and Table Constraints
Constraints can be column constraints or table constraints.A column constraint is specified as part of a column...
2016-12-23
379 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and...
2016-12-23
274 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important too. The system tables also have indexes...
2016-12-23
1,372 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
3 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
5 reads
Merry Christmas
Yesterday was the last working day before Christmas at GRE Towers. We’ve got today off. So this is just a...
2016-12-23
433 reads
Presentations for SQL Server Beginners
Tired from all those blog postsFor my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a...
2016-12-23 (first published: 2016-12-05)
3,282 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