Enterprise TechSQL New SQL Server 2016 Installation Features Walk through July 6, 2016884 views0 Share By IG Share 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://www.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. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server By DataGeekApril 15, 2019
Enterprise Tech How to use Azure Ad Join on Windows Server 2019? & Gateway Access Just like Microsoft Windows 10, the Microsoft Server 2019 also lets you make use of ...
Enterprise Tech What is VMware VMotion? Limitations & Requirements – Storage & Shared If you are in the IT industry, especially infrastructure professionals, you may have heard the ...
Cloud Computing Differences Between VMWare SRM Standard and Enterprise Licensing Disaster Management is one of the essential aspects of any virtualization technique. VMWare, being one ...
Enterprise Tech Cisco WebEx vs Skype for Business: Differences and Comparisons The workforce today has become completely mobile. With that change in the work strategy, the ...