Monday, November 7, 2016

Reviewing Query Store related items in SQL Server 2016

First off you should be using SQL Server 2016 because Query Store is a new feature in SQL Server 2016.

You should enable Query Store for the database you are going to use and you can enable Query Store using SQL Server Management Studio. You may review this post for enabling Query Store.

All objects in the SQL Server can be accessed using the sys.objects as shown:


If you filter the Sys.Objects as shown here you can find Query Store related objects.

Select * from Sys.all_objects
Where name like 'query_store%' or name like 'sp_query%' or name like 'query_context%'


The above query retrieves Views and extended stored procedures related to the Query Store.

Get the March 2018 Power BI update

The update is out and you can get it from here : You can also get it from Windows Store if you are running Windows 10. Well what is n...