Archives

Reasons to Upgrade to SQL Server 2014
Posted by Rob Risetto on August 28, 2015

As you know SQL Server 2014 was released this month so the question is why would you consider upgrading to SQL Server 2014?  If you have a budget to implement the Enterprise Edition then you probably have more of a case to upgrade now, though items 3, 9 and 10 below may provide enough performance benefit to also consider

Continue Reading

Migrating Database Mirroring to an Availability Group – No 2
Posted by Rob Risetto on August 09, 2015

Flowing on from my previous article Migrating Database Mirroring to an Availability Group I thought it might be worth posting the high level steps that worked for me in converting a SQL Server 2008 R2/Windows 2008 R2 Enterprise Database Mirroring implementation into a two node Availability Group environment with the second

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