Tag Archives: sql server

SQL Server Backup – Inadvertent Striping

Posted on July 18, 2011 by way0utwest

When I started working with SQL Server I got bit in the rear one day while I was testing backups. I was in the process of making a quick backup before I deployed some changes. I think this was in … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SQL Server Backup – Inadvertent Striping

DRI or No DRI?

Posted on July 14, 2011 by way0utwest

This editorial was originally published on Feb 19, 2006. We are reprinting pieces this week as Steve is traveling in the UK. There is a great debate going on in the forums about using PKs/FKs to enforce RI, in other … Continue reading →

Posted in Editorial | Tagged , | Comments Off on DRI or No DRI?

Striping Backups in SQL Backup Pro

Posted on July 11, 2011 by way0utwest

There are times you really do want to stripe backups across multiple files. If you have a short backup window, or a large data set, if you can write the backup to multiple files at the same time, you can … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Striping Backups in SQL Backup Pro

Measurements

Posted on July 7, 2011 by way0utwest

“If you cannot measure it, you cannot improve it” – Lord Kelvin. That’s a quote that comes from this blog post, talking about ways in which you might measure your performance. Numbers are not the only important thing to measure, and … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Measurements