Letter To My Father
We spread my Fathers ashes over the past weekend. It was one of the hardest things...
2019-09-06 (first published: 2019-08-22)
508 reads
SQLFlipFlopsDBA
Some Time Away
Greetings everybody! It has been a while since I posted anything here. I figured I...
2019-04-26 (first published: 2019-04-15)
763 reads
Veterans At PASS Summit ’18
Hello all!
This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service...
2018-10-10
189 reads
Azure Runbook Configuration
Hello everybody! Greetings from the very warm state of Texas! One of the most popular questions I get when talking...
2018-08-23 (first published: 2018-08-02)
2,047 reads
Webinars, and Azure, and SQL… OH MY!
Hello everybody! Thank you once again for stopping by and reading. April has been pretty busy with presentations, and I...
2018-04-25
109 reads
Getting the Azure DTU Calculator to work on a 2008R2 OS w/ a 2008R2 SQL Server Instance
Hello everyone! I recently had to do an analysis of a client’s database workload using the Azure DTU Calculator(DTU Calculator)...
2018-04-24
1,202 reads
Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 2
Hello everybody! Thanks for stopping by again. In Part 1 of this series, I gave the background of the project, and...
2018-04-02
122 reads
Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 1
Hello everybody!
I have been working with one of my favorite clients lately on migrating their SQL databases to a DBaaS...
2018-02-10
138 reads
Upcoming SQLSaturdays
I have the priveledge of speaking at two SQLSaturday events coming up in the near future. This is the first...
2018-01-02
119 reads
Creating and Using Failover Groups in Azure DBaaS – Part 2
Connecting to Failover Group
So in Part 1 of this series, we created and configured our Failover Group. Well, now that...
2017-12-26
122 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