As part of my preparation for last week’s Embarcadero DataU 2015 Online Conference, I tried searching for articles, blog posts and videos about useless SQL Server backups. Now, you might be asking, “why would I even be searching for that specific topic?” The primary (if not the most important) task of a database administrator (DBAs) […]
NO, that is certainly not a typo. I really did intend to say SQL Server 2005 and SQL Server 2008. Note that a previous blog post mentioned that you only have less than a year before SQL Server 2005 is out of extended support. So, why, you might ask, would I still be talking about features […]
This week started off with news about the Amazon AWS DynamoDB’s outage and Skype’s network-related issues. For organizations who do not run mission-critical applications on Amazon or who use Skype for communications, this may not be a big of a deal. But for companies like NetFlix, Buffer (I use this to schedule some of my social […]
Don’t we usually hear this a lot when implementing a new high availability and disaster recovery (HA/DR) solution? The stakeholders want zero downtime and zero data loss. As IT professionals we struggle so much trying to find the right solution that would meet the requirements. We ask questions on forums, newsgroups, Facebook groups, Twitter, etc., […]
Pop quiz: You manage a production database and you need a copy of your backups to restore them on a development environment for application testing or performance tuning. You need to do this on a regular basis. Do you Take a backup of the database and restore it on your development environment? Configure replication between your […]