Deep Learning and Craftsmanship Matter
GenAI technology is going to change coding, but there is still a lot of work available for humans.
2026-01-26
59 reads
software development
2026-01-21
83 reads
Eight Minutes
When I was at the Small Data 2025 conference, one of the speakers was talking about their work with AI technologies. This person uses it a lot in their day job, often to complete tasks that they would have struggled to work on in the past, mostly because of time constraints, but also a lack […]
2026-01-16
116 reads
Refactoring SQL Code
Refactoring code is a common task in many software development teams. Steve asks if this is something common for database developers as well.
2025-12-12
221 reads
Done is Better than Good
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
2025-11-26
95 reads
PRs Are Like Trouble Tickets
Adopting a modern development approach brings with it the need to manage PRs, which Steve thinks can be like trouble tickets.
2025-10-01
117 reads
Requiring Technical Debt Payments
Steve found someone using an interesting approach to get developers to address some technical debt.
2025-09-08
150 reads
The Technical Debt Anchor
Technical debt is something all of us deal with in our systems, and today Steve has a few thoughts on the impact of debt on database sysstems.
2025-06-25
164 reads
Patching the Patch
If you have had to fix the thing you just fixed with a fix, you might enjoy today's editorial.
2025-06-16
104 reads
Reflecting on the Mythical Man Month
Steve looks back at the Mythical Man Month, a book every software engineer and manager should read.
2025-06-06
105 reads
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
PASS Data Community Summit 2025 Recap
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
Forums
Microsoft no longer being supported?
The word is finally out that Microsoft is no longer supporting SSRS. I just...
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers
