A Quick Look at Redgate Data Modeler
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore how it works. This is a short look at this tool and how it might...
2025-12-05 (first published: 2025-11-24)
56 reads
Blog Posts
PASS Data Summit 2025 Recap
Last week, I attended the annual PASS Data Summit in Seattle. This was the fourth year of the event since Red Gate took over stewardship of PASS after that...
2025-12-05 (first published: 2025-11-24)
22 reads
The Benefits of Teaching
Even preparing for a class or seminar with set materials takes a lot of time and effort, more so when you build your own content. So why teach?
2025-12-05
13 reads
The Book of Redgate: What Our Staff Says
This image is from 2010, and it goes along with my last post of what our Customers Say about us. However, this is what our employees said about the...
2025-12-05
22 reads
Microsoft AI Red Teaming Course
here is the compiled video of the Red Teaming course Microsoft put together.
2025-12-04
17 reads
PASS Keynote Shots
Rodney Kidd took some great shots of the keynote and published an album here: https://www.flickr.com/photos/127113040@N04/albums/72177720330695911 A few of my favorites: Here’s one of the 8 ball and keynote (and...
2025-12-04
9 reads
Inspecting TSQL Abstract Syntax Trees
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree. I've built a web tool that helps visualize this tree as a learning exercise.
Foreword
I've leveraged...
2025-12-03 (first published: 2025-11-09)
112 reads
Tech Conferences and Expanding Your View
Tech conferences aren't just for networking and learning how to address a problem you're having technically. They are also for expanding your view of what's possible.
2025-12-03 (first published: 2025-11-20)
11 reads
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I have been asked more and more about alternatives for running SQL Server. One of the...
2025-12-02
26 reads
Data Conferences – Worth Every Dollar
Some of the best career enhancers you can buy. Why I Go to Conferences I go for two big reasons: Learning from the best. The folks teaching at...
2025-12-01 (first published: 2025-11-12)
277 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