영업: 1-800-867-1380

 none
Azure Server vs storage accounts

    질문

  • Hi.

    What is the difference between SQL servers and Storage accounts. Is it like SQL server is for relational databases (like SQL server) and storage accounts for Tables (NoSQL).

    Also is there a way to create SQL servers distributed in different data centers around US ? when I try to create a Storage account there, I can choose between 4 data centers around US, but when I try to create a SQL server, I only have one choice in US.

    Thanks

    Muhannad

    2012년 4월 15일 일요일 오후 3:58

답변

  • Question 1: Difference between SQL Server and Storage Account. I believe you are asking for the difference between SQL Azure and Azure Storage.

    Answer :

    • SQL Azure is almost like having a SQL Server (DB Server) on cloud. It has almost all the major functionalities of what you get in your on-premise SQL Server - DB Server. 
    • Azure Storage consists of Table, Blob, Queue and Drive. Table has a semi relational structure to store and retrieve data based on Keys [Row Key and Partition Key]. Blob is used to store any binary data [images, ppt, txt, etc.]. Queues are used for tasks and messages.

    Question 2: 

    Azure storage available in 4 locations and not SQL Azure.

    • US East and US West of Azure storage are new additions, for SQL Azure, give it a little while.
    • 답변으로 제안됨 Horizon_NetMVP 2012년 4월 15일 일요일 오후 9:50
    • 답변으로 표시됨 mhand7 2012년 4월 15일 일요일 오후 10:15
    2012년 4월 15일 일요일 오후 8:13