Tag Archives: best practices

Lessons learnt by implementing Backup Encryption

We’ve already discussed Backup Encryption feature in detail, incase you’ve not covered those please find the link: Part-1Part-2Part-3   There are a few things you must know before you implement backup encryption in your environment, here I’ll try to list them: 1. Original Certificate which was used as an encryptor should be available at the …

SQL Tip-3 | Don’t Shrink your Database

You should avoid shrinking your database until and unless it becomes unmanageable. Shrinking is a Resource intensive task, Moreover it introduces high degree of fragmentation which affects performance. Let’s say you shrink a Database, Now if the data is growing in your database the data\log file will reserve more space by auto-growth (if configured) to meet the …