SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Why so few topics on SQL Azure - Is anybody using it?


Why so few topics on SQL Azure - Is anybody using it?

Author
Message
Tim Walker.
Tim Walker.
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1315 Visits: 1001
I'm doing a project at the moment to see how Azure works in practice, and I'm surprised how little interest there seems to be in SQL Server Azure on SQL Server Central compared to the more traditional editions (only eight Azure threads in total across the two forums!)

I've been at it for a couple of days and having overcome the usual firewall issues now have a single table database in place which seems to work fine with OLE-DB and ODBC. Today I'm hoping to migrate a more substantial database to it and run up an application against it. The application will run in my environment rather than Windows Azure for now.

Are any of you using it, and if so, how are you finding it in practice?

Tim

.
Tim Walker.
Tim Walker.
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1315 Visits: 1001
I guess the lack of responses answers my question!

;-)

.
callum.bundy
callum.bundy
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 125
Hi Tim,

Have you started looking at any use cases for Azure? We are wondering *when* we would want to recommend Azure to our clients for their SQL needs.

Does it look good so far?
Tim Walker.
Tim Walker.
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1315 Visits: 1001
It looks like a version 1 product really, with all that implies.

We are very much at the R&D stage with no plans to go further yet. I currently have a data structure in place that comprises about 60 tables with associated views, stored procedures, functions etc. I've had to make some compromises to put it up because some features are deprecated sooner in Azure than SQL Server 2008 e.g. OPENXML is not supported.

Because there are charges to move the data in and out Microsoft say it's only really cost effective if you deploy an application in Windows Azure that goes with it (therefore all the data stays in the cloud). I haven't tried this as the application I'm using doesn't lend itself to doing that very easily, so I can't confirm what the charges wopuld be in practice.

DML looks quite quick (caviat: low volumes), DDL is much slower (ten times slower). I'm in the UK and on the European data centre.

You have to be very disciplined to use it as you are charged for whatever you put up whether you use it or not. The lack of tools like profiler make it unsuitable for development anyway. Might be OK for testing.

Currently my gut feeling is that the more traditional third party hosting of SQL Server model offered by a number of vendors works better (for live systems), particularly given the 10GB limit in Azure. And frankly the sharding approach they suggest for larger databases is a non runner for most applications unless they were originally designed like that.

That's a potted summary of my view.

Hope that helps!

Tim

.
koustav_1982
koustav_1982
Old Hand
Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)Old Hand (349 reputation)

Group: General Forum Members
Points: 349 Visits: 194
The small review by Tim was excellent.

I am just starting with SQL Azure and was going through diff documents available under MS Windows Azure site.

As far as i understand its not a very good platform for data warehousing applications and can only be usefult for small OLTP applications. One of the case studies given in MS Site is of 3M where they have implemented Azure to host a complex visual designing system which runs complex algorithms in parallel but not very sure how much of it was in Azure and how much on premises.


Hope to find many more Azure developers soon.;-)
Steve Jones
Steve Jones
SSC Guru
SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)

Group: Administrators
Points: 148006 Visits: 19444
I think the cost has deterred much experimentation. There are some MVPs doing work and Grant Fritchey is testing some stuff. I'll see if we can't get some articles going.

Grant's blog: http://www.scarydba.com/

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Tim Walker.
Tim Walker.
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1315 Visits: 1001
Thanks for the link Steve.

I agree that cost is a barrier, but I don't think it was the main barrier for me.

What I didn't like was that it's not very portable. You have to do things to your database to get it up there. And to make it work well you need your apps in Azure too. Which usually means you have to rewrite them. Bad.

And then you are tied in to Azure. Double Bad.

And then they might change the cost model. Aaargh!

It is really telling to me that with all the users you have on SQL Server Central hardly anyone is interested even though it's been free to try things in it for months. Which is a shame for Microsoft given that I've been told they think the future is almost entirely in the cloud. I'm sure I remember them telling me that's where 90% of their investment is going.

Looks like they'll need more bang for their buck to get it started!

Tim

.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)

Group: Administrators
Points: 148006 Visits: 19444
I've started looking for some, and we'll see.

I think many of the people at SSC are worried about cost, others worried about security or legal issues. There are people using it, and I think it makes sense for some new ventures. One thing I did like is that you can ask for a new server and it can be spun up in minutes, not days as it takes in many companies.

I tend to agree with you on the lock in, though it's still (cut down) SQL Server. You can slip your data back out of the cloud.

The hard part for me is that you have to test and work in the cloud, which can add to the costs. Any idea how often developers hit test machines to "try things"? Imagine of those transfers cost money? Course, might help us get rid of SELECT * in applications.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Michael Valentine Jones
Michael Valentine Jones
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14687 Visits: 11848
The one really good use I have heard was a company that needed to collect responses to their Super Bowl advertising.

It let them put up a high volume server quickly, use it for just a few days, and shut it down with very reasonable cost.

For short-term apps like that, it might be the platform of choice.
Tim Walker.
Tim Walker.
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1315 Visits: 1001
Michael that's a very fair point.

Don't get me wrong. For some things I can see it would be great. Ticketing applications are the obvious example where the latest hot thing is probably only active for a week and needs loads of power for hardly any time. Funnily enough Microsoft quote this one a lot.

But ... most apps aren't like that are they ...

Tim

.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search