Jim Dettman
jimdettman at verizon.net
Fri Mar 16 15:56:22 CDT 2012
Not quite the same thing were talking about, but another option for remote users (not sure if I posted this before): www.eqldata.com Someone tried them out and the service is exactly as described. They had a few hiccups in their app, but it was mostly due to the fact that their app was not setup to run remotely (ie. assumed local printers would be in place, pathing, etc). Comment was that tech support them helped them resolve all the issues in fairly short order and overall they were very happy. I'll come up with a link so you can read it yourself if anyone is interested. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Friday, March 16, 2012 04:47 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Windows Azure MS SQL DB hosting costs calculation -anybody? 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