2025-12-29 (first published: 2025-12-24)
590 reads
2025-12-29 (first published: 2025-12-24)
590 reads
I was chatting with the product managers at Flyway and one asked me whether I’d seen the new tab for Automation in Flyway Desktop. I hadn’t and decided to...
2025-12-29 (first published: 2025-12-08)
169 reads
2025-12-29
848 reads
2025-12-29
82 reads
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he hosted (back at #4), but he answered my call for hosts and I appreciate that....
2025-12-26 (first published: 2025-12-09)
238 reads
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia I miss Brad. I enjoyed traveling around and working with him. I’d forgotten about Bob...
2025-12-26
37 reads
The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?
2025-12-26 (first published: 2015-08-13)
814 reads
2025-12-26
998 reads
On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]
2025-12-24 (first published: 2019-12-24)
375 reads
2025-12-22
568 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
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