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 SQL Azure DB & SQL Server". It was...
2016-08-29
4 reads
SQLBalls
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an...
2016-06-01 (first published: 2016-05-20)
2,192 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an Microsoft Data Platform MVP, MCM, part of the...
2016-05-20
6 reads
SQL Saturday Jacksonville #552 Pre-Con: A Day of DBA Fundamentals- Install- Maintenance plans-and Security
Hello Dear Reader! I'm here in beautiful Jacksonville FL for the SQL Saturday 552 events! Today my friend Dan Taylor...
2016-05-06
618 reads
SQL Saturday Jacksonville #552 Pre-Con: A Day of DBA Fundamentals- Install- Maintenance plans-and Security
Hello Dear Reader! I'm here in beautiful Jacksonville FL for the SQL Saturday 552 events! Today my friend Dan Taylor (@DbaBulldog | Blog) and I are presenting our Pre-con...
2016-05-06
2 reads
Goodbye Pragmatic Works
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was...
2016-02-29
976 reads
Goodbye Pragmatic Works
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was almost a blog I didn't write because I...
2016-02-29
3 reads
T-SQL Tuesday #73: IOPS on Azure VM's Naughty to Nicer
Hello Dear Reader! Last week I posted the invitationto T-SQL Tuesday #73. The premise?
“As you work with SQL Server...
2015-12-08
644 reads
T-SQL Tuesday #73: IOPS on Azure VM's Naughty to Nicer
Hello Dear Reader! Last week I posted the invitationto T-SQL Tuesday #73. The premise? “As you work with SQL Server look around you. Is your environment Naughty or Nice? ...
2015-12-08
4 reads
T-SQL Tuesday #73 Invitation – Naughty or Nice?
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to...
2015-12-07 (first published: 2015-12-01)
1,730 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