2017-03-15
1,151 reads
2017-03-15
1,151 reads
2017-03-14
125 reads
It’s T-SQL Tuesday time again, and this is a good one. The host this month is Kennie Pontoppidan, who I...
2017-03-14
912 reads
2017-03-14
857 reads
2017-03-13
202 reads
I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since...
2017-03-13
1,147 reads
2017-03-13
925 reads
I’ve hosted a page on this blog that has all the T-SQL Tuesday blog invitations and roundups linked. I did...
2017-03-10 (first published: 2017-02-28)
2,013 reads
2017-03-10
987 reads
Steve Jones says you should treat your database servers like cattle. It makes life easier.
2017-03-09
348 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