2026-03-30
43 reads
software development
2026-02-25
89 reads
Can You Let Go of Determinism
As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.
2026-02-23
110 reads
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
89 reads
2026-01-21
93 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
164 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
266 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
98 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
120 reads
Requiring Technical Debt Payments
Steve found someone using an interesting approach to get developers to address some technical debt.
2025-09-08
153 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers