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 permissions were needed for the service account dealing with the automation jobs. Specifically they needed control of the Availability Group object – so my colleague ran the following code 11527194375e31d0d856e0e_000000…
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…