Choosing Snowflake vs SQL Server for a Data Warehouse
In this article we take a high level view of choosing to use Snowflake in the cloud versus SQL Server on-premises and some things to consider.
2022-03-28
Additional Articles
DevOps 101: Getting buy-in across your organization
Implementing DevOps isn’t just a matter of being great at writing code. The key to successful DevOps implementation is gaining buy in across your organization. Join Grant Fritchey live for his tips on how to achieve this.
2022-03-28
The problem with averages
Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data.
2022-03-25
Why you don’t just buy tools to make DevOps happen
Matt Gordan is next in the hot seat. We discuss how Matt keeps the lights on while overseeing many data related projects and how his team know the more they are plugged into projects, the better support the can offer.
2022-03-25
How to get DevOps buy-in across your organization
In our latest DevOps 101 Series live webinar Grant Fritchey discusses why the key to successful DevOps implementation is gaining buy-in, and how you can achieve this in your organization.
2022-03-23
What is Change Management?
Change manage is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.
2022-03-23
Think you know SQL Monitor? Think again.
You spoke 📣 we listened 👂
We are dedicated to listening to what our customers want and need and implementing feedback accordingly. Learn about how SQL Monitor has evolved, and the key features we've added, since 2018.
2022-03-21
Working with MySQL tables
After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts.
2022-03-21
Bulk Formatting of the SQL Server SQL Files
In this article, Phil Factor explains how to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch.
2022-03-18
The effects of NULL with NOT IN on Oracle transformations
IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN and NOT IN.
2022-03-18
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
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
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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