The two most visible changes to installation of SQL server are:
1. The installer now recognizes the number of
cores in your serer and creates tempdb with the
number of cores if the cores
are less than 8 or 8 if the number of cores is more than 8. At last
Microsoft addressed
what SQL Server User community and professionals were recommending.
See image below. In my case, my server has four cores and it recognizes and create temp files.
2. Another exciting feature that was brought
into main stream SQL server is Polybase. Polybase is a
T-SQL front end that
allows users to query non-relational data.
Polybase was used to query an
external Hadoop cluster connected to APS.
This is good news for queries non-relational data from
within SQL server
engine. I personally cannot wait to play with it and finally if good may use it
for real. To use this feature you need
to install Oracle JRE Update 51 or higher. Otherwise you
will get the following
error and will not progress with installation.
