Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server installed on Windows azure platfrom vs SQL Azure Expand / Collapse
Author
Message
Posted Tuesday, June 12, 2012 1:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, December 11, 2014 2:19 AM
Points: 415, Visits: 1,605
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.


Post #1314230
Posted Tuesday, June 12, 2012 7:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 14,205, Visits: 28,534
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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1314416
Posted Tuesday, June 12, 2012 12:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 9:52 AM
Points: 44, Visits: 235
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. www.meetwindowsazure.com I watched it live but I'm sure it is still available for viewing.

SQL Managed
Post #1314641
Posted Tuesday, June 12, 2012 12:26 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 14,205, Visits: 28,534
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. 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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1314645
Posted Tuesday, June 12, 2012 12:52 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
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. 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'
Post #1314660
Posted Tuesday, June 12, 2012 1:58 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:11 PM
Points: 31,368, Visits: 15,837
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1314717
Posted Tuesday, June 12, 2012 10:29 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, December 11, 2014 2:19 AM
Points: 415, Visits: 1,605
Hi,

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

Can you give me some graphical representation or any helpful links

Thanks


Post #1314848
Posted Wednesday, June 13, 2012 6:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 9:52 AM
Points: 44, Visits: 235
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
Post #1315077
Posted Wednesday, June 13, 2012 9:23 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
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
Post #1315228
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse