Connect Azure SQL

-- Run in virtual master.
CREATE LOGIN querycomment WITH PASSWORD = 'replace-with-strong-password';
ALTER SERVER ROLE ##MS_ServerStateReader## ADD MEMBER querycomment;
ALTER SERVER ROLE ##MS_DefinitionReader## ADD MEMBER querycomment;

-- Run in each application database.
CREATE USER querycomment FOR LOGIN querycomment;

USE master;
CREATE LOGIN querycomment WITH PASSWORD = 'replace-with-strong-password';
CREATE USER querycomment FOR LOGIN querycomment;

GRANT CONNECT ANY DATABASE TO querycomment;
GRANT VIEW SERVER STATE TO querycomment;
GRANT VIEW ANY DEFINITION TO querycomment;

SELECT TOP (1)
  query_hash,
  execution_count,
  total_elapsed_time
FROM sys.dm_exec_query_stats;

SELECT TOP (1) sql_text.text
FROM sys.dm_exec_query_stats AS query_stats
CROSS APPLY sys.dm_exec_sql_text(query_stats.sql_handle) AS sql_text;