2026-02-25
1,139 reads
2026-02-25
1,139 reads
I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error...
2026-02-25
40 reads
2026-02-25
96 reads
As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.
2026-02-23
118 reads
2026-02-23
989 reads
Steve talks about some of the charitable work at SQL Server Central.
2026-02-20
74 reads
2026-02-20
659 reads
It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak...
2026-02-20 (first published: 2026-02-13)
304 reads
I coach volleyball and I do a lot of stat stuff on paper. I decided recently to see if I could find a way to more easily automate things....
2026-02-18 (first published: 2026-02-09)
563 reads
2026-02-18
634 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers