Post reply

Querying Master Database DMVs in Azure SQL Database

  • 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

  • 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

     

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply