Archive for October, 2014

Optober – SQL sp_configure options – Backup Compression Default

Optober continues with more sp_configure option descriptions. This time it’s all about backup compression default. I was surprised today when doing a review that a client was still under the impression that backup compression was still an enterprise feature. No no no no no. It’s there for everyone with standard edition since SQL Server 2008 R2 and there’s really no reason not to be using it.

Read More →