Big Data Downsides
Too much data, especially for some data analysis isn't good for diversity of any product domain.
2023-04-12
159 reads
Editorials
2023-04-10
320 reads
Keeping Things Running
Today and tomorrow, as I write this, the Green Country Hamfest will be running up in Claremore, OK. Tomorrow morning, I'll be there to check out the tables and maybe pick up some new radio gear. I'll also be volunteering to help run the doors. Largely it involves just checking to be sure people paid […]
2023-04-08
79 reads
What motivates you to do your best?
In today's guest editorial: the motivation to do our best must come from within.
2023-04-07 (first published: 2017-02-17)
203 reads
Information Schema Strangeness
An extra column in an information_schema view had Steve digging into standards.
2023-04-05
174 reads
Living With Broken Software
Steve has to use software that is broken, but it's OK. It actually works well enough.
2023-04-03
117 reads
Has SQL Server Performance Improved?
This week Steve found a question of whether SQL Server 2019 uses more CPU than 2016.
2023-04-01
717 reads
Building a Better Profile
Steve thinks building a brand is important in today's competitive world of job seekers.
2023-03-31
124 reads
Being Responsible for Data
There is an interesting court case on who is responsible for the data being posted on the Internet. Steve has a few thoughts today.
2023-03-29
272 reads
2023-03-27
314 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
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...
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