Query Store OverviewIt's amazing that we never had a built in feature that logged historical record of queries. Sure we had the plan cache, but that was...
Backup EncryptionIf you're storing any of your database backups off site or in the cloud, you might want to look into encrypting your backups. This...
Clear cache for a single Stored ProcedureSometimes for testing purposes (or an emergency) one might find it useful to remove query plan for a single stored procedure. This way...