A major release for dbatools is bringing big changes. We'll review the what, the why and a breaking change to be aware of.
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.
