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: