Allan Hirt

Allan Hirt consults for and trains clients all over the world. He has written or co-authored numerous SQL Server publications; his latest book is Pro SQL Server 2005 High Availability (Apress). You can find him on the Web at http://www.sqlha.com.

[email protected]

Allan’s Recent activity

Compression Testing and Results

Mar 27, 2008

To test compression in the three products in this review, I used a 539GB real-world database loaned specifically for my testing. (A small database would not have yielded results showing how efficient a compression was...

Backup Compression and SQL Server 2008

Mar 26, 2008

The “X factor” regarding SQL Server backup compression in the next 24 months is SQL Server 2008. Backup compression will be built into SQL Server 2008 Enterprise Edition, and I suspect that many customers currently...