SQL Server installed on Windows azure platfrom vs SQL Azure

  • Hi All,

    I am looking for the advantages of Windows Azure/SQL Azure.

    Windows Azure is like a service oriented i.e., if we install sql server on Windows azure then that will be like SQL Azure?

    why we have two different stuffs?

    The above statements may be wrong, please correct if i am wrong.

    Please explain the above basic doubts.

    🙂

  • Windows Azure is just application hosting. It's not an entire OS. For that you'd want to look at Amazon or Google. Windows Azure is for applications and SQL Azure is for databases.

    "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

  • Actually, you can now host Windows Servers on Azure. This was in beta for a while but MS just announced the new Azure code release on June 7th, which means you can now run Windows Servers on Azure and its fully supported. There were a lot of other features that came with the new version also. You should check out the intro by Scott Guthrie for a good summary of what you can do with Azure. http://www.meetwindowsazure.com I watched it live but I'm sure it is still available for viewing.

    SQL Managed

  • Steve Turner - SQL Managed (6/12/2012)


    Actually, you can now host Windows Servers on Azure. This was in beta for a while but MS just announced the new Azure code release on June 7th, which means you can now run Windows Servers on Azure and its fully supported. There were a lot of other features that came with the new version also. You should check out the intro by Scott Guthrie for a good summary of what you can do with Azure. http://www.meetwindowsazure.com I watched it live but I'm sure it is still available for viewing.

    Sorry, must have missed that one. So you can run SQL Server, not SQL Azure, on a hosted server? Interesting.

    "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

  • Grant Fritchey (6/12/2012)


    Steve Turner - SQL Managed (6/12/2012)


    Actually, you can now host Windows Servers on Azure. This was in beta for a while but MS just announced the new Azure code release on June 7th, which means you can now run Windows Servers on Azure and its fully supported. There were a lot of other features that came with the new version also. You should check out the intro by Scott Guthrie for a good summary of what you can do with Azure. http://www.meetwindowsazure.com I watched it live but I'm sure it is still available for viewing.

    Sorry, must have missed that one. So you can run SQL Server, not SQL Azure, on a hosted server? Interesting.

    The answer is probably Yes - I have not seen it stated explicitly - but you will have to supply your own license and be responsible for maintenance.

    And I still have not seen an explicit statement whether for IaaS Microsoft provides automatic behind the scenes cloning and synchronization. (Which, since the announcement, is no longer SQL Azure, it is Windows SQL.)

    edit: typo 'whether'

  • I believe someone mentioned this at a cloud event. You can install SQL on a VM role, but as Revenant said, you are responsible.

    You also don't get any more flexibility in terms of I/O than a normal sized machine in Azure.

  • Hi,

    What is VM and Cloud? how these two are different?

    Can you give me some graphical representation or any helpful links

    Thanks

    🙂

  • VM = Virtual Machine. Cloud = just about whatever people want it to these days. But in general it refers to a virtual environment. And on this thread it refers to Microsoft's cloud computing solution, Windows Azure. I have no links handy to point you to a diagram. But check out Scott Guthrie on meetwindowsazure.com that I mentioned before to see what Azure can do currently. Maybe someone else here can point you to a couple of good simple diagrams.

    SQL Managed

  • Overview of Azure is here: http://msdn.microsoft.com/en-us/library/windowsazure/dd163896.

    I recommend that you start from Mark Russinovich's overviews: http://technet.microsoft.com/en-us/sysinternals/bb963887.aspx

    edit: added link to Mark's videos

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply