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
144 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
144 reads
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2025-05-26 (first published: 2019-07-06)
350 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
17 reads
2025-05-23
426 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
32 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
25 reads
Steve finds a lot of people don't use version control and don't want to learn how to use it.
2025-05-21
177 reads
2025-05-21
397 reads
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus a happy hour. I’ll be there with Kendra Little and Erik Darling talking about DevOps...
2025-05-20
17 reads
Redgate Monitor works with more than SQL Server. Some big changes were announced recently, and I’ll cover the highlights here. This post looks at Redgate Monitor and the additional...
2025-05-19
26 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers