Shrinking a SQL Transaction Log File
DaleEvery so often, I run out of drive space on my SQL Server. The culprit ends up being the Transaction Log File (LDF) expanding to consume all available space. My…
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…
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…