December 12, 2019 at 12:00 am
Comments posted to this topic are about the item Querying Master Database DMVs in Azure SQL Database
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 12, 2019 at 8:04 am
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply