Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast. Both of us are...
2017-07-10
3 reads
SQLBalls
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the...
2017-03-10 (first published: 2017-03-01)
2,230 reads
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the big four zero.... 40. A little wiser? Maybe. Despite...
2017-03-01
3 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016.
I needed to...
2017-02-28
911 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016. I needed to add a couple packages to my R engine so...
2017-02-28
6 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network,...
2017-02-07 (first published: 2017-02-03)
1,858 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some...
2017-02-03
6 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem....
2016-12-21 (first published: 2016-12-05)
3,320 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem. They had a large amount of skewness/data skew. This...
2016-12-05
6 reads
SQL Azure, Hekaton, and Bob Dorr is Awesome
Hello Dear Reader! I had recently written a blog for the PFE blog, "How Many Tables Can I Have In...
2016-08-29
930 reads
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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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