The widest DMV surface here, and the grant it depends on
Real blocked-session detection and real index seek and scan counts are things most engines cannot give, and a restricted login still sees none of them.
5 posts
Writing on SQL Server
Pooled connections with sys.* catalog introspection, estimated plans and DMV-backed monitoring. Where it stops: Agent mode is unavailable here; the editor, diagrams and health are identical.
Three quiet fidelity limits in a T-SQL result grid
Wide integers and high-scale decimals arrive as JavaScript numbers, only the first result set of a batch is read, and one paged statement is not recognised.
A plan that needs a session, and a path that has none
The showplan setting is session-level state and the explain path sends one statement, so the capability is declared false and the action is hidden.
SQL Server connects encrypted but unauthenticated by default
Encryption is on out of the box while certificate validation is off for any host that is not the recognised managed one, and two named modes do not pin a CA.
What silently degrades on a managed SQL Server database
The one managed host the code recognises by name switches certificate validation on, and the same move narrows the monitoring and maintenance surface.