July 2, 2016 at 12:54 pm
I will be celebration the USA's Independence, have some bar-b-que and go hiking with my family. 😀
But I also intend to spend some time getting acquainted with Azure in holiday weekend. Especially SQL Azure. I previously asked How do I set up Azure SQL? and got great feedback. Now I'm going through the tutorial referenced. However I'm not sure what some of the terminologies are. In creating a database in SQL Azure clicking on the New button, what's the difference between:
From my point of view they're all the same. I just don't see what's different between the two and why I'd select one over the other.
Rod
July 2, 2016 at 7:24 pm
When you say you are creating a new database, do you mean in the Azure Portal?
July 3, 2016 at 9:59 am
Yes
Rod
July 4, 2016 at 2:43 am
you basically build a SQL Database within a Logical SQL Server... if that helps?
July 4, 2016 at 9:21 am
It does help, but I find the terminology confusing. It's virtual, and yet I can put something into it? Sounds like it's not real, but is, all at the same time.
Rod
July 5, 2016 at 4:20 am
I just read the online docs, I see your point!
However if you login right now and type SQL Database in the search bar you will only see:
> SQL Database
> SQL Server (logical server)
> SQL DWH
and other stuff...
July 5, 2016 at 6:29 am
Any database created as a SQL Database, is the same. It doesn't matter if you create the database using the portal, powershell or T-SQL. It's a database. Databases live in these things called servers, but they're not really "servers." It's a management and security construct. A server can have multiple databases. A database will only ever belong to a single server.
Same thing with Azure SQL Data Warehouse. There is a server and on that server can be multiple databases. Note though, Azure SQL Data Warehouse servers are different than Azure SQL Database Servers. It goes without saying that an Azure SQL Data Warehouse database is a different critter than an Azure SQL Database database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 5, 2016 at 7:45 am
Thank you, Grant. I don't think I'll want the Azure SQL Database Warehouse. My database is pretty small stuff. Just a way for me to learn Azure and SQL Server in the cloud.
Rod
July 5, 2016 at 8:38 am
I said all that, and I'm a little wrong. The servers are the same. My mistake.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply