Along with the release of SQL server 2016 CTP 3 now comes the preview of a brand new feature for on premise databases – the Query Store. This feature enables performance monitoring and troubleshooting through a log of executed queries. This blogpost will cover the aspects of this new feature including: Introduction How to activate it Configuration options What information is found in the Query Store How to use the feature What’s in it for me
With the release of SQL Server 2016 CTP 3.0 also comes the ability to test the Many-to-Many functionality within the SSAS Tabular. This blogpost will cover the aspects of the many-to-many feature from SQL Server 2016 – including: Prerequisites The old way The new way This post is based on data from the AdventureWorksDW2012 database.