New SQL Server 2016 Installation Features Walk through

In this post, we explore the New SQL Server 2016 Installation Features Walk through. If you are familiar with the SQL Server installation process, this should not be something alien to you. If you are new, this should help you. Read along to know more.

New SQL Server 2016 Installation Features Walk through

SQL Server 2016 came up with some exciting new features, which could sometimes be overwhelming for data professionals. On those lines, several new features came up in the SQL Server 2016 setup program. Features like R Studio, temp DB configuration right from the setup are certainly promising. In this post, I am going to talk about new SQL server 2016 installation features walk through.

The first thing that you would notice is that SQL Server Management is not included in the software package. You will need to click on the “Install SQL Server Management Studio” link to go to the Microsoft site to download the latest version.

New Standalone R Server is also included in the software package. It allows you to install R Server for advanced analytics purposes. The maintenance menu is mostly unchanged from the previous editions. You get the regular upgrade and repair options as you did before.

Also Read: Why SQL Server 2016 is Faster than Ever!

On the Tools menu, you have a lot of standalone tools included in the package. For example, MAP toolkit, PowerPivot configuration tools for SharePoint 2016 on-premises. SharePoint 2013 is not compatible with SQL Server 2016 at the time of writing this post. Finally, under the “Options” menu, you have additional options to select x86 or x64 edition of SQL Server to be installed.

SQL 2016: Feature Selection Menu

As you can see from the above screenshot, apart from the R-Services (In-Database) and Standalone, you have the Polybase connector. It allows you to connect to unstructured data like NoSQL etc. This feature already existed on the SQL Server Database appliance, a.k.a PDW (a.k.a APS).

In-Database R services provide you with basic libraries that allow you to execute R scripts on SQL Server. In case if you want to use a fully featured R server, install the standalone edition.

Server Configuration

There is a sleek new feature incorporated into the server configuration menu, called “Grant Perform Volume Maintenance Task Privilege.” This feature allows “Instant File Initialization” With this option checked, you get the following performance benefits:

• Create a new database.
• Adding additional Data files, log files to an already existing database.
• In case if you increase the size of an existing file which includes the “Auto-grow” operations.
• When you are restoring a database or a filegroup.

Database Engine Configuration: TempDB Tab

A lot has been said and written about temp DB and its benefits of splitting up into multiple dbs. You can now spawn multiple temp DB files from the setup menu along with the auto-growth settings. You will no longer have to change these settings post installation like in earlier releases.

Analysis Services Configuration

There is an additional “PowerPivot Mode” option. It is not a new feature but rather an old one that existed way back since SQL Server 2008 R2. It was the instance dedicated for rendering SharePoint On-premises Power-Pivot excel data models. It used to be an option under “PowerPivot” for SharePoint 2013 shared feature. With the new standalone option, it makes more sense and less confusion.

Conclusion

Although this is not an exhaustive list, we tried to cover most of the features added (and removed) in the SQL Server 2016 setup installer. Questions or comments are welcome in the comment section below.

Disclaimer: The Questions and Answers provided on https://gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.