Exploring Window Functions Execution Plans
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
38 reads
Blog Posts
2024-06-24
15 reads
How to give developers access to Query Store
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)
627 reads
Resetting Git and Abandoning Changes–#SQLNewBlogger
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
92 reads
Transform yourself into an Invaluable Data Leader in just 6 weeks
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
34 reads
A Global Team Meeting
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
25 reads
A New Word: sayfish
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
41 reads
How important is having great soft skills as a Software Engineer for personal growth and career…
How important is having great soft skills as a Software Engineer for personal growth and career successAs an Engineer, I would like to understand what I need to do to...
2024-06-21 (first published: 2024-05-26)
282 reads
What to Know about Power BI Theme Colors
Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with...
2024-06-21
52 reads
Speaking at SQL Saturday South Florida 2024
I’m heading to SQL Saturday South Florida 2024 next week. This is my second time attending the event and if you’re in the Miami area (or want to take...
2024-06-20
17 reads
Blogs
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers