Upgrade, Migrate, Consolidate: The SQL Server Lifecycle

Session information

The last decade has brought about a great deal of change in the IT world. In that time, there have been 5 versions of SQL Server released, with a sixth on its way (not to mention the regular operating system releases). Microsoft is pushing to ever more frequent releases, with the pinnacle of this being the Azure offerings, where change is almost a daily thing. This means that upgrading and migrating is going to be a big topic for many people, especially with the impending “end of life” of SQL 2005 in April 2016.

But before we dive into actually upgrading or migrating, we need to do a little research into what we can expect from a newer version of SQL Server.

André and William will spend the day with you going through the different aspects of SQL Server lifecycle management:

  • How to identify and catalogue the SQL Servers in your network (you’d be surprised at how many rogue SQL Servers are out there!)
  • How to see which features you are using to decide which future version and edition will be required
  • How to identify possible compatibility issues early on
  • How to implement best practices for all SQL Servers (regardless of version and edition) and ensure those best practices remain in place
  • How to decide if on-premises or cloud services is the best option
  • How to identify and investigate performance issues in your SQL Server environment

We will close the day out with an open discussion about the topics discussed and how they affect your environment.

You will leave the training day with a clear understanding of how to approach managing different versions of SQL Server. You will also be equipped with the knowledge to approach any upgrade or migration in a clear and structured way.


<strong>We are offering a voucher for a fourth person to attend a session for free if your company (or a group of friends) book 3 attendees on our training day sessions email SQLSatExeter @ SQLSouthWest.co.uk for further details</strong>


André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA.nl. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW. André is a Data Platform MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland.

William Durkin is a DBA and SQL Server Solutions Architect for CloudDBA.de. He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects spanning 5 continents. One highlight was creating a world-wide, 12 site transactional replication system (buy him a drink and he’ll tell you the story).