[AccessD] Windows Azure MS SQL DB hosting costs calculation - anybody?

Hi Jim --

Thank you for your link.
Windows/SQL Azure looks now less attractive than a regular ASP.NET/MS SQL hosting solution with custom web services. The following Windows Azure requirement looks rather restrictive:

"One of the major problems to is that you have to open a hole in the Azure firewall for MS Access to get at the Azure SQL db.  That's fine so long as you are on the LAN with a static IP.  Not so good for what I want--access from 3G clients."

They say SQL Azure hosting have to be "informed" about clients' IP addresses - and I and my customer could have dynamic ones...

Thank you.

-- Shamil


Fri, 16 Mar 2012 16:16:02 -0400 от "Jim Dettman" <jimdettman at verizon.net>:
> Shamil,
> 
> <<They (MS) seems to be now providing Windows Azure free trial
> (http://www.windowsazure.com/en-us/offers/ms-azr-0018p), was that available
> before?>>
> 
>  Yes, it has.
> 
> <<I suppose my sample/probable real life project case Windows Azure MS SQL
> DB hosting costs calculations would be interesting to many developers from
> this list ?>>
> 
>  Before you go too far down the path, you might want to check out the
> following thread:
> 
> http://rdsrc.us/NlPrvS
> 
>  Which is a link to a thread on EE where one of the Expert's tried out Azure
> and Access and his trials and tribulations.  It's fundamentally different
> then what your looking to do (he was looking to work over a 3G cellular
> network), but some of what he discovered will still apply.
> 
>   Think it's worth a few minutes to read through.
> 
> Jim.
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov
> Shamil
> Sent: Friday, March 16, 2012 03:14 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Windows Azure MS SQL DB hosting costs calculation -
> anybody?
> 
> Hi All --
> 
> They (MS) seems to be now providing Windows Azure free trial
> (http://www.windowsazure.com/en-us/offers/ms-azr-0018p), was that available
> before?
> 
> Anyway I have a prospect customer who wanted to have their DB "on  a cloud".
> That DB is not big in size - less than 1GB, and it should have <= 10,000
> (ten thousands) updates (inserts/updates/deletes) per month, and 30-50
> millions reads.
> By update and read I mean one DB record CRUD or retrieve operation from
> several DB tables.
> This is  a look-up DB with two large tables having about half million rows
> and one much smaller table.
> There could be other tables added later.
> 
> I wonder how to calculate what would be the monthly costs of keeping such a
> DB with such operations as described above "on  a  Windows Azure cloud"?
> 
> Yes, I can read Windows Azure docs and I can try to use their calculators to
> calculate my customer monthly spending on keeping their look-up db on
>  Windows Azure cloud  but if anybody of you here have already got experience
> in calculating such spending I'd like to get "ballpark quote" ASAP, and if
> that figure will be affordable then I'd start three months free Windows
> Azure trial...
> 
> I suppose my sample/probable real life project case Windows Azure MS SQL DB
> hosting costs calculations would be interesting to many developers from this
> list ?
> 
> TIA,
> -- Shamil 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>