Just a few minutes ago SQL Server 2016 is released. You can download SQL Server 2016 Developer Edition for FREE. There are many different versions of SQL Server 2016 and they are all available for download for everyone who has a valid MSDN subscription.
SQL Server 2016 have many new features. I have been exploring some many of the features in the Release Candidates and I have blogged before. I will be blogging about SQL Server 2016 in the future blog posts. Here is the list of top 10 features which I have liked so far and I will start my focus from these features.
|Always Encrypted||Query Store|
|Row Level Security||R Built-in T-SQL|
|Temporal Table||Stretch Database|
|Dynamic Data Masking||PolyBase|
|Multiple TempDB Database Files||JSON Support|
Additionally, there are many improvements in the In-Memory OLTP which I will be looking forward to explore and implement at my customer.
Download SQL SERVER 2016 Developer Version for FREE
Earlier Microsoft has announced that SQL Server 2016 Developer version is available to download for FREE. You will have to sign in to Visual Studio Dev Essentials before you can download SQL Server 2016 Developer Edition. Remember that Visual Studio Dev Essential is FREE developer program.
(You will have to either login via your Microsoft account – hotmail, outlook or create a new one)
If you have an MSDN subscription you can download SQL Server 2016 from here.
In other news, AdventureWorks sample database is retired now and Microsoft has released new sample database WideWorldImporters.
I will write future blog posts about how to use this sample database with SQL Server 2016.
Pro Tip: Bookmark this blog post for future reference. I will keep it updated with the latest information.
Here is a 2 minute short video which explains how to install SQL Server 2016.
Reference: Pinal Dave (https://blog.sqlauthority.com)