How HADR_SYNC_COMMIT waits can wreak havoc
It has been a decade since I have blogged. Or at least it feels like it. Today I would like...
2015-11-25 (first published: 2015-11-17)
4,533 reads
Roy Ernest
SQL Saturday # 103 in Curacao a Success
On 25th of February 2012, Curacao hosted its first SQL Saturday event. The event was held at the University of...
2012-03-01
2,321 reads
Ready for the new year?
The New Year is just around the corner. Every year I make a resolution. And every time I fail. That...
2011-12-29
2,286 reads
Junior DBA
At our company we have two DBAs to take care of all the databases in the production and QA. It...
2011-12-08
1,483 reads
It was a pleasure to work with the NomCom
With the announcement of the official slate for the BoD election for this year, the job of the NomCom is...
2011-11-30
2,548 reads
SQL Pass Update - Day 1
So far SQL Pass Summit has been great for me. I have had a great time from day one onwards....
2011-10-12
1,743 reads
PASS Summit is almost here
This is my second trip to Seattle for the annual bash. Last year I was a newbie. I did not...
2011-10-07
1,457 reads
Who says you cannot mix business with pleasure?
There is an advice out there that says never to mix business with pleasure. It is not true in all...
2011-09-21
2,008 reads
One hectic month ahead
The SQL Pass community summit is just around the corner. There is so little time and so much to do....
2011-09-07
1,387 reads
Why you should blog more
I was trying to write an article for a long time. Every time I start writing one, I would put...
2011-09-01
1,239 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat BCA KCU MATRAMAN Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah...
Alamat BCA KCU CIANJUR Tlp,Cs:0821-8154-393
WA:08218154393 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
Question of the Day
Multiple Values Inserted
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