Why Rolling back inserts with Identity columns is a bad idea.

It wasn't until the other day that I realised what the behaviour was when rolling back a transaction with an insert on a table with an identity column, to be fair I have never had a need to do so but I know that there are people who like to run code like below to... Continue Reading →

Apr 11, 2019 7

UNDERCOVER TOOLBOX: Get Details of All Open Transactions

It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a dream because I was surrounded by drifting clouds, singing angels and hundreds of softly humming SQL Servers where the hardware had been sensibly provisioned and all code carefully optimised) when I was rudely awoken by... Continue Reading →

Feb 7, 2018 6