BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
- What's new in SQL Server 2017 (differences versus 2016)
- Changes to SQL Server 2017 installation (this blog)
- What's new in the T-SQL language in SQL Server 2017
- What's new in Integration Services 2017 (SSIS 2017)
- What's new in Reporting Services 2017 (SSRS 2017)
- 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:
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 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?).
- What's new in SQL Server 2017 (differences versus 2016)
- Changes to SQL Server 2017 installation (this blog)
- What's new in the T-SQL language in SQL Server 2017
- What's new in Integration Services 2017 (SSIS 2017)
- What's new in Reporting Services 2017 (SSRS 2017)
- What's new in Analysis Services 2017 (SSAS 2017)