T-SQL Tuesday #187–Solving Problems
This month we have a great invite from Joe Fleming, a first time host of T-SQL Tuesday. Joe reached out when I requested some hosts and I’m glad he...
2025-06-10
97 reads
The Voice of the DBA
Monday Monitor Tips: Customizing Data Retention
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
28 reads
The Book of Redgate: Ingeniously Simple
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)
274 reads
A Basic Update Trigger: #SQLNewBlogger
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
24 reads
Getting References for GenAI Results
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
22 reads
Copilot Outside of SSMS Seems to Work
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
88 reads
A New Word: Falesia
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
9 reads
Using AI to Test a SQL Query
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
134 reads
DevOps Devour Hour Slides
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
27 reads
Advice I Like: Take Two Trips
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
10 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts