dataplatform.blog
SQL Tips & Tricks
(updated on )

Claus Munch

Backup/Restore progress

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.

SQL Tips & Tricks
(updated on )

Claus Munch

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.

SQL Tips & Tricks
(updated on )

Claus Munch

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.

SQL Tips & Tricks
(updated on )

Claus Munch

Locating views

SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'M42'

SQL Tips & Tricks
(updated on )

Claus Munch

Backup Restore progress