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 12»»

Why so few topics on SQL Azure - Is anybody using it? Expand / Collapse
Author
Message
Posted Thursday, May 27, 2010 4:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:23 PM
Points: 266, Visits: 893
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


.
Post #928853
Posted Monday, June 7, 2010 7:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:23 PM
Points: 266, Visits: 893
I guess the lack of responses answers my question!



.
Post #933516
Posted Tuesday, June 8, 2010 12:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 14, 2012 7:18 PM
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?
Post #933812
Posted Tuesday, June 8, 2010 2:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:23 PM
Points: 266, Visits: 893
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


.
Post #933851
Posted Thursday, August 12, 2010 11:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 8, 2014 12:50 AM
Points: 72, Visits: 183
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.
Post #968660
Posted Wednesday, May 25, 2011 10:24 AM


SSC-Dedicated

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

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
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
Post #1114895
Posted Thursday, May 26, 2011 1:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:23 PM
Points: 266, Visits: 893
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


.
Post #1115211
Posted Thursday, May 26, 2011 9:05 AM


SSC-Dedicated

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

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
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
Post #1115588
Posted Thursday, May 26, 2011 9:27 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 3, 2014 2:23 AM
Points: 3,108, Visits: 11,503
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.

Post #1115613
Posted Thursday, May 26, 2011 2:20 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:23 PM
Points: 266, Visits: 893
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


.
Post #1115836
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse