Skip to content

George Palacios – DBA

Categories Uncategorized

Living with PTSD

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…

by George PalaciosMarch 4, 2021March 4, 2021
Leave a Comment on Living with PTSD
Categories SQL Server, Trouble Shooting

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…

August 22, 2019August 22, 2019
Categories SQL Server, Useful scripts

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…

July 19, 2019August 22, 2019
Categories Engine, SQL Server

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…

July 16, 2019August 22, 2019

Recent Posts

  • Living with PTSD
  • EXCEPTION_ACCESS_VIOLATION when working with Availability Groups
  • How to find SQL Object dependencies
  • Should I add the Clustering key to a non-clustered index?

Recent Comments

    Archives

    • March 2021
    • August 2019
    • July 2019

    Categories

    • Engine
    • SQL Server
    • Trouble Shooting
    • Uncategorized
    • Useful scripts

    Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org

    George Palacios – DBA

    Proudly powered by WordPress | Theme: Yosemite by GretaThemes