Benefits at Glance of Using New SQL Server 2016

SQLServerF1

Microsoft has released most awaited RTM version of SQL Server 2016 on June 1 2016. There was lot of buzz around with the release of new SQL Server 2016 and has been already downloaded by many community DBAs and developers to start testing or learning using the new features. Just like any other SQL Server version, even in new SQL Server 2016, there has been lot of new features introduced in areas like security, performance, scalability, stability, etc. Also there is support for SQL Server on linux in pipeline, which makes it much more interesting and to enter new companies which did not use windows operating system. As a DBA or developer it is very important to gets handon new features and suggest to the management how it will benefit the clients or customers or their own business with the new features. Always, test in a test environment thoroughly before deciding to move to production. Also, as like any new version, it is expected to have lot of bugs too, so it is up to you to decide whether to wait till a service pack is released or just go ahead and install it right away now. My preference is to start testing on test environment and see how application reacts to it, and if the new features are beneficial and performance has improved with the applicaion, then I prefer to go ahead with the new SQL Server 2016 on production environment.

Following are some of the important benefits of new SQL Server 2016 which we might want to keep on top of our head.
– Microosft claims Enhanced in-memory performance which provides up to 30x faster transactions, and more than 100x faster queries than disk based relational databases and real-time operational analytics.
– New security feature Always Encrypted which helps in protecting our data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without requiring any changes to the application.
– Built-in advanced analytics– provide the scalability and performance benefits of building and running advanced analytics algorithms directly in the core SQL Server transactional database.
– Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android
Simplify management of relational and non-relational data with ability to query both through standard T-SQL using PolyBase technology

– New features like Stretch Database technology keeps more of our historical/cold data at our fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes.
– Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore our on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure.
– Closer integration with Azure SQL Database which helps more customers comfortable to migrated to cloud with the new security features.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2016

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

Pre-install Information for SQL Server 2016

SQLServerF1

Microsoft has officially released new SQL Server 2016 on June 01 2016 for public to download and install it on their development, test or production servers. It is important to test the applications thoroughly before moving to production environment, as there may be some changes required to the application to work seamlessly. If the application is vendor application, then contact the respective vendor and get approval to use new SQL Server 2016, most times, vendors releases new version of the application which works fine on new versions of SQL Server. Although, installing and using SQL Server 2016 is straight forward, but important to take care of things prior to install to ensure no hiccups later for the installation process. SQL Server 2016 has a critical pre-requisite for updated Visual Studio VC++ 2013 Runtime Libraries. To install or check if this update is required on your system, refer KB316398 for further information.

Review SQL Server 2016 system requirements – Memory Minimum requirement for Express Editions is 512 MB, All other editions: 1 GB, however recommended for Express Editions is 1 GB and for All other editions is at least 4 GB and should be increased as database size increases to ensure optimal performance. Processor speed required minimum is x64 Processor: 1.4 GHz, however recommended is 2.0 GHz or faster. Type of x64 Processor is AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support. Important point to note is SQL Server 2016 is supported on x64 processors only. It is no longer supported on x86 processors. WOW64 is not supported for SQL Server 2016. Review SQL Server release notes – check the release notes of SQL Server before installation to get all the details.
Download and install full-featured software for a 180-day trial edition or buy a licenseed edition for production environments and developer edition for development purposes. We may also choose to use express edition based on our requirement, if we are not using all features.

Make sure the account which used to RDP to the server has administrative rights on the computer to install SQL Server 2016. We will have SQL Server 2016 DVD Image or ISO file for the installation.
The Microsoft SQL Server 2016 release is available for testing purposes only and should NOT be installed and used in production environments.
Side-by-Side installation with down-level production SQL Server instances as well as in-place upgrades of down-level production SQL Server instances, is supported for SQL Server 2008 and higher.
If you have questions or concerns that come up during your testing and evaluation, we encourage you to use the MSDN forum for SQL Server 2016 to search for answers or ask new questions.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2016

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings