Note: This blog was transposed from an internal intranet at my work. “Just like there’s always time for pain, there’s always time for healing.”― Jennifer Brown, Hate List I am a trauma survivor – I live with Complex Post-Traumatic Stress Disorder. This post is something very personal for me. I want to share this with you, my colleagues…
EXCEPTION_ACCESS_VIOLATION when working with Availability Groups
My colleague was dealing with a request from another member of IT today – they’re currently automating the process of patching, and as such some…
How to find SQL Object dependencies
From SQL Server 2008 and onward we gained a new DMV called sys.dm_sql_referenced_entities – this allows us to track object dependencies rather neatly. This covers…
Should I add the Clustering key to a non-clustered index?
I was sent a CREATE INDEX script by a third party today – it was non-clustered. Whilst reviewing the index definition I noticed that the…