William Benson
vbacreations at gmail.com
Fri Mar 16 21:12:34 CDT 2012
Just getting database envy "listening" in on this discussion because I don't know anything but access and vba and don't know any techy people who have that sw. I also don't have any friends with Xbox 360 and heard that's fun too. I know I need to get out more but am too busy with outdated, under powered and lonely technology that makes getting tasks done quite challenging. I am thinking of a sabbatical where I apprentice myself to some folks doing interesting things. But I know that's dreaming and I am not sure I will find the right environment. But thanks for these discussions. I used to have a mind that could (or thought it could ) visualize what I had no experience with but no longer it seems. Boo hoo pity party for myself. On Mar 16, 2012 5:03 PM, "Salakhetdinov Shamil" <mcp2004 at mail.ru> wrote: > 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 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >