Skip to content

George Palacios – DBA

Tag: script

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

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