Looking Back

In July 2011 I took what felt like a big chance and a detour to lead a large and complex security upgrade for a large company. The project included replacing firewalls, re-ip’ing hundreds of servers, implementing updates to hardening standards, updating application logging, and a lot more. A ‘lot more’ doesn’t really begin to describe […]

A Surprising Result from Ident_Current

If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all sessions. It’s something to use carefully, and not fall into the trap of thinking that if Ident_Current = 2 and you insert a row that the value will be 3 – someone could have inserted […]

SQLAndy

Winning

Looking Back

A Surprising Result from Ident_Current