O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3Upgrading SQL Server 2014 Best Practices

WHAT'S IN THIS CHAPTER?

  • Planning an upgrade
  • Understanding discontinued and deprecated features
  • Choosing an upgrade method
  • Knowing what to watch for after the upgrade

Chapter 2, “SQL Server 2014 Installation Best Practices,” covers performing a new installation of SQL Server 2014. This chapter discusses upgrading SQL Server from a previous version. The best strategy for a successful upgrade is planning and preparation. First, you learn reasons for upgrading to SQL Server 2014. You then consider the pros and cons of various upgrade strategies, and you learn about the various tools available to help mitigate risk during the upgrade process. Then you learn about SQL Server 2014 behavior changes, and discontinued features that you need to know about before upgrading. To wrap up, this chapter explores unexpected issues you might encounter after the upgrade. By the end of the chapter, you will have learned everything you need to know to perform a successful upgrade to SQL Server 2014.

WHY UPGRADE TO SQL SERVER 2014?

This book introduces significant enhancements throughout the product. During the development cycle, consider the three pillars of focus for the product: mission-critical confidence, breakthrough insight, and cloud on your terms. With the release of SQL Server 2014, Microsoft enhanced numerous features in the areas of scalability, reliability, availability, and security. Following are many benefits that these new features ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required