What’s next: New beginnings!
I’m both excited and frankly relieved to say that I’ve found a new position. Starting Wed Nov 2nd I’ll be ... Continue reading
2022-10-28
15 reads
Blog Posts
Adding AD group perms to SQL Server
Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg...
2022-10-27
14 reads
Daily Coping 27 Oct 2022
Today’s coping tip is to write down three specific things that have gone well recently. Easy, as a lot of things have gone well. I’m going with some travel...
2022-10-27
7 reads
Long time, no posts
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
23 reads
Snowflake – Search Optimisation Service
Rarely do I say I love a feature across any technologies I have come across, in the snowflake world this is right up there. I tend to find this...
2022-10-27
83 reads
250th Blog Post
Kristyna and I were working through some updates to our site and realize that this was going to be our 250th blog post on Data on Wheels. I thought...
2022-10-26
14 reads
Daily Coping 26 Oct 2022
Today’s coping tip is to recognize that you have a choice in what to prioritize A good one for me, especially as I’m a little stressed and overloaded with...
2022-10-26
10 reads
Monitor Cardinality Feedback in SQL Server 2022
It’s possible for you to see new technology at work if you use Extended Events to monitor cardinality feedback. To put it simply, cardinality, the number of rows being...
2022-10-26 (first published: 2022-10-17)
225 reads
My experience working with notebooks in Azure Data Studio
I’ve seen notebooks used in Azure Data Studio on multiple occasions. I really like the concept of notebooks, having done some work within Azure Databricks notebooks, but not extensively....
2022-10-26 (first published: 2022-10-13)
585 reads
Daily Coping 25 Oct 2022
Today’s coping tip is to share a helpful quote, picture, or video with a friend. I usually enjoy sharing quotes with friends on their birthdays. Those of you who...
2022-10-25
7 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers