Sometimes you just need to have an idea of how long a backup/restore has been running or maybe for how long it will roughly run.
Here's a small script, that will give you these indications.
Database Mirroring to offsite server
Using SQL Server Database Mirroring to offsite servers, can at times be tricky, as latency becomes an issue.
At a recent engagement, they where experiencing that their mirror got suspended several times a day.
Idempotent SQL change script
Today I had a small chat with one of our developers, about adding a column to a table "the right way". I told him, that depending on how they needed to deploy it, it might be beneficial to make it idempotent.
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'M42'
Backup Restore progress