SQL Server installed on Windows azure platfrom vs SQL Azure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Cloud Computing » SQL Azure - Administration » SQL Server installed on Windows azure...

SQL Server installed on Windows azure platfrom vs SQL Azure

Rate Topic

Display Mode

Topic Options

Author

Message

SQL*

Posted Tuesday, June 12, 2012 1:15 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:39 AM
Points: 414, Visits: 1,454

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.

Smile

Post #1314230

Grant Fritchey

Posted Tuesday, June 12, 2012 7:14 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 13,371, Visits: 25,145

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1314416

Steve Turner - SQL Managed

Posted Tuesday, June 12, 2012 12:22 PM

SSC 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

Grant Fritchey

Posted Tuesday, June 12, 2012 12:26 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 13,371, Visits: 25,145

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

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1314645

Revenant

Posted Tuesday, June 12, 2012 12:52 PM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:24 PM
Points: 3,448, Visits: 2,523

Grant Fritchey (6/12/2012)

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

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

Steve Jones - SSC Editor

Posted Tuesday, June 12, 2012 1:58 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406, Visits: 13,723

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

SQL*

Posted Tuesday, June 12, 2012 10:29 PM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:39 AM
Points: 414, Visits: 1,454

Hi,

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

Can you give me some graphical representation or any helpful links

Thanks

Smile

Post #1314848

Steve Turner - SQL Managed

Posted Wednesday, June 13, 2012 6:45 AM

SSC 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

Revenant

Posted Wednesday, June 13, 2012 9:23 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:24 PM
Points: 3,448, Visits: 2,523

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 »

Permissions