What’s not new in SQL Server 2014, and what I like most?


In follow up to the RTM of SQL Server 2014 announcement there’s lot going around the blogs about what’s new with this new version.

Rather I would like to pin up what’s NOT new in 2014, it is simple:

The SQL Server documentation confirms that SQL Server 2014 has not introduced significant new features to the following:

 

On that contrary I would like to remind you about the new changes with the SQL Server installation, which is the key point where you will begin the 2014 journey. The changes that I like in Installation arena are:

  • Windows Vista cannot be used to install SQL Server 2014. The minimum requirement on Operating System is Windows 7 and Windows Server 2008 R2. Here you will get to see Hardware and Software Requirements for Installing SQL Server 2014.
  • During SQLExpress 2014 setup files extract, it is a best practice to specify the directory to copy the installation files rather than leaving it to default User’s documents folder. And also make sure you delete those extracted files once the setup is complete.
  • SysPrep is now supporting failover cluster installations too (I thought it is supported from SP1 SQL Server 2012 (need to check)).
  • Good documentation and approach on SysPrep: Considerations for Installing SQL Server Using SysPrep and Install SQL Server 2014 Using SysPrep.
  • A big news on Upgrade projects, you can still upgrade from SQL Server 2005 to 2014 only using InPlace procedure only.

Coming days I’m going to blog more on upgrade process and procedures.