what’s the role of a “Master” database in a SQL Azure world?
One of the question that pops up in the head of first-time SQL Azure user is “What is Master Database doing in my server”. They try to delete/drop it. That does not happen. Fun fact: I tried dropping Master database when I had got my hand on SQL Azure for the first time. Any-who what we speculate is that “OMG! I paying for this SQL Azure Master database!” Wait…No, read this:
You are not charged for the SQL Azure Master Database.
Ok Good news, But why does this “read-only” master database exist?
Here is the information I have used that is available via SQL Azure Master Database:
It has SQL Azure usage metrics
It stores logins for a given SQL Azure LOGICAL server (To manage Server-Level security)
To view list of all databases via sys.databases
To create databases via TSQL. You do that by logging into master database first.
What do use SQL Azure master database for?
That’s about it for this post.
And Let’s connect! I Look forward to Interacting with you on any of these people networks:
