(SQL) Tip of the Day: List failing Queries using Query Store

With modern programming systems such as Entity Framework or LINQ we are able to query databases for information quickly but we do not know the TSQL on the backend. This becomes more of a problem when these queries start failing while they are running. Running the query below will get you the full plan of the query and the query_id which will let you dig in further via Query Store views.