Changing Default Database File Locations in SQL Server 2016
At some point in your career as a data professional you will need to change the default database file locations in SQL Server 2016.
backups
6 Ways To Treat Your Data Right
Not everyone understands just how important data is until it is gone. Here are six ways that you can treat your data right.
How To Survive A Database Disaster
I am here today to share with you my FOOLPROOF method that allows you and your business to SURVIVE any database disaster.
The DBA Plate for 2016
Four years ago I wrote about the DBA Plate, which was a reference to the food plate that replaced the food pyramid right about the time the U.S. Congress declared pizza to be a vegetable. I had every intention of keeping the plate updated annually but never got around to doing so because reasons. Well, today is the day. You’re welcome.
Lost Data
DBAs get paid for performance but we keep our jobs with recovery. Being able to recover data is the most important job function you have as a DBA. If you can’t recover your data because database backups are missing, or corrupt, then you should consider a new line of work. The year is 2015 and we … Read more
Differential Backups, Differential Terms
Backup or dump, which do you prefer to take? I have often referred to a database backup as a database dump. The reason for this goes back to an event that happened many years ago where the database backup files filled up a disk drive. As a result we were not able to recover data … Read more
