Salakhetdinov Shamil
mcp2004 at mail.ru
Fri Mar 16 16:02:26 CDT 2012
Hi Doug -- Yes, I will very probably use and I will recommend to use to my customer a non-SQL Azure ASP.NET + MS SQL hosting, in fact I do have one like that for testing purposes, rather inexpensive, and I have used it already, and it worked well with MS Access linked tables and also "talking via Internet to MS SQL hosted DB" using custom coding (C#).... Thank you. -- Shamil Fri, 16 Mar 2012 13:46:35 -0700 от "Doug Murphy" <dw-murphy at cox.net>: > I looked at Azure for a project we were doing on an automated internet data collection system. SQL Server seemed a good deal, but then to add the services we needed we had to subscribe to 2 other instances. For this project it was too costly. I ended up getting a web hosting account with SQL Server service and put the functionality in an ASP.NET page and a couple of class modules. Works well. The hosting service provides a scheduler that fires the page and the system does its thing and stores the information in the SQL Server database. Azure does not have a scheduler so you have to create your own. The system just runs, and collects it's data. We also have an Access Front end linked into the SQL server so we can run reports. Much cheaper than Azure. > > Doug > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov Shamil > Sent: Friday, March 16, 2012 12: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 >