Latest Updates on New Features in SQL Server 2016

SQLServerF1

Recently Microsoft has made an announcement about the upcoming release of SQL Server 2016. Although the announcement is made, first there will be few CTP releases used by community users and few company’s to test the new SQL Server 2016 product and to send their feedback and any bugs with the product. As days progress, Microsoft SQL Server team will work and fix and issues or bugs reported on the product and its features and ship newer updated versions. After CTP releases, once SQL Server team is confident, they will go ahead with the announcement about the official release of the product. No matter, how much ever testing is done on the new SQL Server 2016, still there will be log of bugs which will uncover while the product is being deployed on to our servers, which is because there are wide variety of environments which are all different, this testing for all kinds of environments in not possible. Sometimes there are silly bugs which end up due to improper testing.

Microsoft SQL Server 2016 team has announced new features or enhancements to the existing features to make the SQL Server product much better and scalable and tighter integration with the SQL Azure. Below are some of the new SQL Server 2016 features or enhancements to existing features in SQL Server 2016.
Enhancement to In-Memory OLTP Technology – Microsoft SQL Server 2016 team claims that the in-memory OLTP transaction will be 30X faster and in-memory ColumnStore Real-time operational analytics will be 100X faster.
Always Encrypted – SQL Server 2016 team claims that this technology will help in protecting the data at rest and in motion, for on-premises and in the cloud, with master keys sitting with the application, without any application changes.

Enhancements to High Availability features like with the ability to have up to three synchronous secondary replicas, MSDTC support, and load balancing of the secondary replicas.
Scale and Manage expected to enhance the performance, scalability and usability across SQL Server Enterprise Information Management tools and Analysis Services.
Powerful Insights on any Device – Business insights through rich visualizations on mobile devices. Native apps for Windows, iOS and Android. New modern reports for all browsers.
Advanced Analytics at massive scale – Built-in advanced analytics provide the scalability and performance benefits of running your advanced analytical algorithms directly in SQL Server.
Stretch Database – SQL Server 2016 team claims that this technology keeps your historical data at your fingertips by transparently and stretching your warm and cold OLTP data to Microsoft Azure on-demand without application changes.
Temporal Database to Track historical changes.
Enhanced Database Caching – Cache data with automatic, multiple TempDB files per instance in multi-core environments.
Easy migration of on-premises SQL Server using simple steps to migration to SQL Azure.

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

 

Latest Update on SQL Server 2016

SQLServerF1

The following release of Microsoft’s well known SQL Server database programming will get to be accessible as an open see this mid year, Microsoft declared today at its undertaking focused Ignite meeting. The following real arrival of Microsoft’s leader database and examination stage gives leap forward execution to mission-discriminating applications and more profound bits of knowledge on your information crosswise over on-premises and cloud.

The discharge will accompany a few new highlights, incorporating encryption of information in movement and very still and a combination with the R programming dialect, taking after Microsoft’s securing a year ago of R appropriation supplier Revolution Analytics. SQL Server 2016 will likewise accompany Stretch Database, a highlight that permits organizations to “extend” certain information that isn’t regularly gotten to into Microsoft’s developing Azure open cloud.

Microsoft has been concentrating on its half breed cloud procedure recently as an approach to separate itself from other significant cloud suppliers, including Amazon Web Services and Google Cloud Platform. Other Microsoft items declared at Ignite today, similar to Azure Stack and Operations Management Suite, show that.

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

 

Latest Developments on New SQL Server 2016

SQLServerF1

Microsoft has made an announcement regarding the new and latest plans about next release of SQL Server which is SQL Server 2016. Satya Nadella, CEO of Microsoft, announced SQL Server 2016, as an intelligent platform for a mobile first, cloud first world. The significant arrival of Microsoft’s lead database and examination stage gives achievement execution to mission basic applications and more profound bits of knowledge on your information crosswise over on-premises and cloud. Some of the latest features that may come up with SQL Server 2016 are as mentioned below which are reported in the technet blog.

Always Encrypted – With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the application in the customers trusted environment. Encryption and decryption of data happens transparently inside the application which minimizes the changes that have to be made to existing applications.

Stretch Database – This technology allows you to dynamically stretch your warm and cold transactional data to Microsoft Azure, so your operational data is always at hand, no matter the size, and you benefit from the low cost of using Microsoft Azure. You can use Always Encrypted with Stretch Database to extend your data in a more secure manner for greater peace of mind.

Real-time Operational Analytics & In-Memory OLTP – For In-Memory OLTP, which customers today are using for up to 30x faster transactions than disk based systems, you will now be able to apply this technology tuned for transactional performance to a significantly greater number of applications as well as benefit from increased concurrency. With these enhancements, we also introduce the unique capability to use our in-memory columnstore delivering 100X faster queries with in-memory OLTP for in-memory performance and real-time operational analytics.

Built-in Advanced Analytics, PolyBase and Mobile BI – SQL Server 2016 expands its scope beyond transaction processing, data warehousing and business intelligence to deliver advanced analytics as an additional workload in SQL Server with proven technology from Revolution Analytics. Building PolyBase into SQL Server, expanding the power to extract value from unstructured and structured data using your existing T-SQL skills. With this wave, you can then gain faster insights through rich visualizations on many devices including mobile applications on Windows, iOS and Android.

visit the SQL Server 2016 preview page(valid URL) to read about the capabilities of SQL Server 2016 and sign-up to be notified once the public preview is available.

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

 
1 2 3 4