What's new in SQL Server 2017? For SSAS Tabular, lots, it transpires.
Part two of a six-part series of blogs

This blog summarises the main new features of SQL Server for non-administrators (that is, most of us). Most parts of SQL Server get minor changes at best, but SSAS Tabular 2017 gets a host of major improvements.

  1. What's new in SQL Server 2017 (differences versus 2016)
  2. Changes to SQL Server 2017 installation (this blog)
  3. What's new in the T-SQL language in SQL Server 2017
  4. What's new in Integration Services 2017 (SSIS 2017)
  5. What's new in Reporting Services 2017 (SSRS 2017)
  6. What's new in Analysis Services 2017 (SSAS 2017)

Posted by Andy Brown on 23 January 2018

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Changes to SQL Server 2017 installation

When you install SQL Server 2017 Developer Edition, you now do so in chunks:

Installing SQL Server 2017

As this shows, Reporting Services is now a completely separate installation.

As part of the installation process, you have to confirm your acceptance of R and Python:

R and Python

R has been renamed to Machine Learning Services, a feature which now also supports Python.

Other than that, everything is pretty much as it used to be!

One other change: Analysis Services installation defaults to using tabular models, rather than multi-dimensional (a sign of the times?).

This blog has 0 threads Add post