Is there any way we can get these info like server/program/user/session id for historical queries with the help of query store or DMV's? I know dmv's store session info for currently fired queries but not getting from where we can get session info for historical data.
When will you add Query Store to Azure Data Studio? :)) As a DBA, I still can't use ADS because it's more designed for developers and not DBAs. This is very sad.