Top 10 Databases for 2019

A look at ten top databases fighting for mind-share in 2019.

Database Snapshot Use Case: Service Migration

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.

Generic, parameterised, create DB script

A script to be used as part of development deployments where new databases are required, so as to provide standardisation.

perform an activity on each database on the server

Database Backup Information Scripts

Scripts used to validate the backups information as below

1) Database Backups for all databases For Previous Week
2) Most Recent Database Backup for Each Database
3) Most Recent Database Backup for Each Database - Detailed
4) Databases Missing a Back-Up Within Past 24 Hours

Figure out recovery mode for each database

It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.

Rename column