• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

July 2, 2018

It's becoming less surprising, but no less scary when I find shops not taking regular database backups. This happens quite often in situations where there is no dedicated DBA. Meaning someone else just kind of took over those responsibilities ("accidental DBA", if you...

February 26, 2018

If you're storing any of your database backups off site or in the cloud, you might want to look into encrypting your backups. This feature was first introduced in SQL 2014.

Since we're working with encryption on SQL server the first step is to create a Database Master k...

December 13, 2017

It is unbelievable how common it is to walk into a new organization only to find that they have no database backups. But when having a conversation with management, they expect zero data loss.  Seems like a bit of a conundrum don't you think?

It's important to bring abo...

July 10, 2017

One of the great things about Azure is that backups are automated as part of the service.  Azure for SQL touts a 12 hour RTO and a 5 minute RPO for backups that are considered "in-region". 

The backup schedule is as follows:

Full: Weekly

Differential: Hourly

Transacti...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server.  When not working I like to lift weights, play music, and travel with my wife.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle