Querying Master Database DMVs in Azure SQL Database

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  December 12, 2019 at 12:00 am

  #3703857

  Comments posted to this topic are about the item Querying Master Database DMVs in Azure SQL Database

• Henrik Staun Poulsen

  SSCertifiable

  Points: 6592

  More actions

  December 12, 2019 at 8:04 am

  #3707269

  hi Steve,

  Thank you very much for showing how to access sys.sql_logins. I was not aware of the needed role.

  May I suggest a naming convention? (Yes, I know, it depends on taste, and taste differs, but still...)

  I think we should call the tables something like mastersys.<tablename>, as in mastersys.sql_logins, mastersys.firewall_rules. That will make it easy to convert your existing old code (from on-prem), and make it easier for 3rd part tool-makers like sp_Blitz to provide code that works on Azure SQL Databases as well as other types of SQL Server.

  Best regards

  Henrik

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  December 14, 2019 at 8:22 am

  #3707880

  Henrik,

   

  That's actually a great suggestions. I wasn't sure what naming to recommend, and hadn't spent much time on it, but I like the idea of mastersys as a way to differentiate this.