Thursday, July 16, 2015

New Features of SQL Server 2016

The next version of SQL Server looks to add more and more features helpful in database design and administration as well as Business Intelligence.

The first I found interesting is Temporal Tables. This table keeps a history of the changes made to the table over time. This will change how software developed to track changes will be coded in the future. How wonderful it would be not to have to worry about this. Another plus side to all these changes is more and more DBAs will be needed :)

The next feature is Stretch Database. This option lets you use Azure to store and retrieve archival data in the cloud. I was not much of a fan of the cloud in the beginning, but now I see benefits as the technology advances to make it easier to manage.

In-Memory technology as well as Column Store indexes seemed to be the big items for performance improvements. Check here and here for those updates. If you are really interested in reading about Column-store indexes, check out NikoPort’s blog.

Of course, I will have to mention something about SSIS. Incremental Package Deployment is the one that interest me most. Not having to deploy the whole project will help with the manageability of versions on the production server. It was great when SSISDB was released in 2012, and it looks like Microsoft is going to keep improving this option.

Performance improvements to the tabular model of Analysis Services seems to be the direction Microsoft is heading as far as SSAS improvements are concerned. The parallel Processing of Partitions will make it more in line with the advanced features of Multidimensional Cube. I still believe Multidimensional Cube is needed for Enterprise level cubes, but tabular is catching up.

New DBCC commands are added to check for corruptions in Analysis Services database (both Multidimensional Cubes and Tabular Models) as well as new DAX functions for Tabular. Read here for the full list for Analysis Services.

Of course, all of this is in the current CPT release and can change so get updated will the latest.

No comments:

Post a Comment