Category: DBA

SQL Server Backup to/Restore from AWS S3 Storage
Posted by Rob Risetto on December 05, 2015

The use of AWS S3 storage to store SQL Server backups makes sense, firstly it is significantly cheaper than EBS, secondly you can encrypt what’s stored and thirdly you can manage backup file retention and lifecycle using inbuilt functionality.

Continue Reading

Heartbleed SSL Bug – DBAs Should Be Aware
Posted by Rob Risetto on September 01, 2015

Whilst this bug is not directly related to SQL Server I thought DBAs should be aware of it since there are a lot of web servers out there accessing SQL Server back ends. I found this article Everything you need to know about the Heartbleed SSL bug by Troy Hunt to be one of the best in explaining the bug’s ins and outs.

Continue Reading

Monthly DBA Maintenance Tasks for SQL Server
Posted by Rob Risetto on July 22, 2015

This is Jason’s take on the monthly tasks for a SQL Server DBA (10 Monthly Maintenance Tasks for SQL Server). My recommendation is that these tasks should be automated where possible.

Continue Reading