This is a post that quickly recaps 2022 and introduces this new blog design and a few 2023 goals.
Active Directory groups are used all over our IT estates. They can be used to simplify managing SQL Server access as well as for other applications.
Log shipping is a SQL Server feature used for disaster-recovery where the transaction log backups are ‘shipped’ from your production instance to a secondary instance.
Use Extended Events to easily measure the duration of queries with different batch sizes, so you can find the optimal.
A useful script to collate index usage stats across multiple AG replicas to help ensure you don't drop indexes that are unused on the primary, but vital on the secondary.