Learning T-SQL - Revisited

In my current job, I get to write data extracts. eg. extract data from an SQL database, using Microsoft Access as the front-end. Not my preferred tool, but it’s what I’ve got.

Thought it would be useful to brush up on my T-SQL, so I purchased the book on the right.

Best darn [...]

Should I compress my SQL Database when backing up? - Maybe ...

SQL Server 2008 Backup Compression – by Varun Dhawan, over at MSDN blogs.

It’s a useful option for saving space with backing up to disk, but I would disagree with the guy over tape backup savings.

Some tape units have built-in hardware compression which already compresses the data being stored on tape. Which means there [...]