Tag Archives: Redgate

Office Work

I have been working at home for over 8 years, sharing an office with my wife for most of that time. I like working at home, though I do notice that if my wife is gone for a few days, … Continue reading

Posted in Blog | Tagged , , | Comments Off on Office Work

Striping Backups in SQL Backup Pro

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

The Exceptional DBA for 2011

Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last three years, and it’s been a hard choice trying to pick from some great applications. This year the judges are … Continue reading

Posted in Blog | Tagged , , | Comments Off on The Exceptional DBA for 2011

Clean Code is Easier to Read – SQL Prompt

I saw a post recently that had query that looked like this: select a.*,name, b.* from sys.database_principals a, sys.database_permissions b where permission_name = ‘INSERT’ and b.grantee_principal_id = a.principal_id   Ugly to read, at least to me, and in a poorly … Continue reading

Posted in Blog | Tagged , , , | 1 Comment