Upgrading to SQL Server 2014: Step 2 – Planning For Reporting

When planning for upgrading our servers to SQL 2014, I not only had to plan for our production instances, but also for our reporting instance. Before planning our capacity needs, I needed to decide on how to get our production data into our reporting environment. How I did that will be the subject of this post.  Continue reading Upgrading to SQL Server 2014: Step 2 – Planning For Reporting

Upgrading to SQL Server 2014: Step 1 – Planning our HA/DR Strategy

Choosing a SQL Server High Availability/Disaster Recover (HA/DR) strategy strongly depends on what the management of your company wants. Therefore you have to sit down with them and determine the Recovery Point Objective and the Recovery Time Objective (RPO/RTO). Once that’s done, you can start planning your HA/DR strategy. Here’s how I decided on our HA/DR strategy.  Continue reading Upgrading to SQL Server 2014: Step 1 – Planning our HA/DR Strategy

Upgrading to SQL Server 2014: Step 0 – Determining RPO/RTO

As a DBA, it is advisable to collaborate with your colleagues from the operations team. Especially when you are planning to upgrade to SQL Server 2014 and they are planning to buy new hardware for your new database servers. That is exactly what I recently did, and in this blog series I am going to explain and document the entire process of upgrading our databases from SQL Server 2005 to SQL Server 2014. In this first post I am going to talk about the Recovery Point Objective and Recovery Time Objective, because that’s where a project like this all starts. Continue reading Upgrading to SQL Server 2014: Step 0 – Determining RPO/RTO