Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)
This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.
The Design Investment
How much of an investment should you make in learning design? Steve Jones talks about why we should learn how to do it right.
IT Compliance and Software Development
What is IT Compliance and is it really necessary for contemporary Agile applications to be constrained by the requirements of compliance? William Brewer argues that if the objective is rapid delivery of applications, then compliance controls must be understood as early as possible in development.
Limitations of MongoDb
This article looks at two critical limitations suffered by MongoDb compared with SQL Server.
SQL Server Random Sorted Result Set
In this tip Dallas Snider illustrates how to write a T-SQL query that will return rows sorted randomly.
Don’t Understand? You’re About to Learn Something
Learning opportunities abound, but they can be stressful, as shown in today's guest editorial.
Fifty Words for Databases
Phil wonders whether it is our poor vocabulary about databases that has lead to the failure of developers and Operations people to understand each other on the topic of deployment.
Conrad Wolfram: Geek of the Week
Conrad Wolfram is the 'younger Wolfram' of Wolfram Research, the company behind Wolfram|Alpha and Mathematica. He wants to transform the way in which we engage with mathematics. In particular, he would like to reform mathematics education to make greater use of information technology, and he is also leading the way with interactive publishing technology.
How to Design, Build and Test a Dynamic Search Stored Procedure
Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.
Upgrade and Refresh, or Not?
Today we have a guest editorial from Andy Warren that looks at the upgrade cycle and how that affects our jobs.
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