Friday, May 29, 2015

What is different in first install of SQL 2016 CTP2



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.