Ian Norris

I found if I have multiple upserts in flight at the same time I get this: > Microsoft.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 114) was deadlocked on lock | communication buffer...

So I've dug into this and I found to eliminate the deadlock I had to also add OPTIONS (MAXDOP 1) to the end of the query. I tested this by...

Wow, that's a complex solution. There's a few nice tricks in there that I wasn't aware of, so I'm going to dig into those. Here's the query I ended up...

I don't know enough on the details on UPDLOCK vs HOLDLOCK to answer your question unfortunately. I felt this was a good time to give a further update though. Since...

Apologies for the delay on this, hoping to get back to fixing the defects mid next week.

I've added some docs around using this including some example queries to get people started (as this may be the first time many people are experiencing KQL). I'm not sure...

Thanks @evchaki, I'd managed to miss the bit about redirect URIs in the docs, I'm not sure how I missed it. However even when configured as described I'm now getting...