2019-02-19
5,335 reads
Database
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.
2020-08-28 (first published: 2018-12-11)
2,270 reads
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.
2017-01-23 (first published: 2017-01-18)
432 reads
2016-11-30
1,203 reads
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
2015-11-25 (first published: 2015-11-03)
1,698 reads
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.
2015-11-23 (first published: 2015-10-26)
640 reads
2012-07-25
2,696 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers