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.
A quick code snippet to help find members of the local admin group.