Watch this video on YouTube
I like using ChatGPT. But I don't like the $20/month price tag for using OpenAI's app, especially given the API costs fractions of a cent.
So...
2024-06-26 (first published: 2024-06-10)
282 reads
This book was recommended by some of my colleagues, so I decided to give it a try. After finishing the book, I was pleased that I did. As the...
2024-06-24 (first published: 2024-06-05)
435 reads
I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account....
2024-06-24
249 reads
There are quite a few different ways that you’re likely to see window functions evidence themselves within your execution plan. Let’s take a look at one example. Window Functions...
2024-06-24
22 reads
2024-06-24
4 reads
Let’s have devs look at their own query performance. Yes, please, sign me up for that! Sometimes, it’s hard for me to know the best course of action, especially...
2024-06-24 (first published: 2024-06-03)
559 reads
I recently had an issue in one of my Git repos, and decided to drop all my local changes and just pull down from the remote. This post looks...
2024-06-24
82 reads
I’ve collaborated with two industry experts to design a transformative course for data leaders: “The Technical and Strategic Data Leader.” This six-week intensive learning journey is crafted to elevate...
2024-06-24
12 reads
The last few years at Redgate we’ve had the entire (or most) of the marketing department come to Cambridge in the UK for a week. A few weeks ago...
2024-06-21
18 reads
sayfish – n. a sincere emotion that seems to wither into mush as soon as you try to put it into words – like reeling in a shimmering beast...
2024-06-21
9 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers