One of the biggest challenges with monitoring data is managing the volume over time. Lots of bespoke/home-grown solutions don’t do this well, and some commercial products have a gross...
2025-06-09
34 reads
Redgate has been known for many useful tools that are easy to use. We’ve tried to do that in all our point tools. We talk about simplicity all the...
2025-06-13 (first published: 2025-06-06)
280 reads
I had someone ask me about using triggers to detect changes in their tables. As I explained a few things, I thought this would make a nice series, so...
2025-06-04
60 reads
I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for results. Most of us might take a result from...
2025-06-02
27 reads
I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool, especially comparing it to Gemini or Claude. I haven’t...
2025-05-30
99 reads
falesia– n. the disquieting awareness that someone’s importance to you and your importance to them may not necessarily match – that your best friend might only think of you...
2025-05-30
15 reads
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET...
2025-05-28
143 reads
Here are the slides from my talk today at the Redgate NYC Devour Hour: Architecting Zero Downtime Deployments.pptx The Repo is here: https://github.com/way0utwest/ZeroDowntime An interesting question on feature toggles:...
2025-05-23
31 reads
If you have any doubt about being able to carry a load in one trip, do yourself a huge favor and make two trips – from Excellent Advice for...
2025-05-23
16 reads
I had a suggestion from somone on a place where AI helps them and I decided to try it. The person had an AI summarize their work and if...
2025-05-21
24 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers