[AccessD] New SQL Server license scheme is RADICALLLY more expensive

Salakhetdinov Shamil mcp2004 at mail.ru
Tue Nov 15 01:40:39 CST 2011


Hi Darryl --

I wonder, what raw (server side views, SPs, UDFs, triggers, ...) data processing/manipulation are you doing with your large dataset, which doesn't fit MS SQL Express?
What data processing/manipulation is done on your client side - just conceptual view of it?...

Thank you.

-- Shamil


15 ноября 2011, 06:22 от Darryl Collins <darryl at whittleconsulting.com.au>:
> Well,
> 
> Been an interesting couple of days. Have a very large dataset, far too large for Access so I have been playing with it in SQL Server Express, but been hitting issues with that as well - the data just fits (just) but it leaves almost no space do perform any actions on it.  So now I am trying MySQL.  Been a bit of a learning curve this morning, for example, it was awful until I found a decent GUI (that needs to be downloaded separately).  But so far so good, I am liking it.  Got it hooked into MS Access for import / export and the rest of it seems rather doable as well.  Fairly intuitive so far, which I like.
> 
> Will be a change as I have used SQL server for a few years now, but Express is getting too limiting and there is no way we can justify paying for a dedicated server.
> 
> See how this turns out - early days yet so I am not getting too pleased with things, but an encouraging start none the less.
> 
> Cheers
> Darryl.
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov Shamil
> Sent: Tuesday, 15 November 2011 7:52 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] New SQL Server license scheme is RADICALLLY more expensive
> 
> Thank you, Arthur,
> 
> I thought you have used more powerful hardware - but if it works well for you, no problem.
> I've even a bit "weaker" system than you do (and just 3GB RAM), and I can have several VS2010 sessions, as well MS SQL, MS Word, Excel and Access etc. running simultaneously. They work rather smoothly but it's becoming as you say "confusing" to have all that stuff opened on one physical box, so I'm considering upgrading my hardware to something more modern (but not as mighty as JWC has) to run development for different customers in different VMs...
> 
> -- Shamil
> 
> 13 ноября 2011, 22:21 от Arthur Fuller <fuller.artful at gmail.com>:
> > My hardware is pretty modest, Shamil, especially when compared with JWC's.
> > On the OS side, I run Windows 7 Ultimate. On the hardware side, the
> > workstation is a gracefully aging HP with 4GB of RAM and a few hard
> > disks and a dual-layer DVD burner. Oh yeah, there's also a USB hard
> > disk with a mere 250 GB. That's about it. Oh, I forgot the
> > flash-memory sticks: a pair of 16 GB sticks. I'm considering mounting
> > the new version of Solaris on one of them.
> >
> > I should add that I don't run everything all at once; what's the point
> > of running Ubuntu and Mint simultaneously? The one problem that I have
> > with my setup is that I don't have a Windows XP VM. Within the Ubuntu
> > VM and also the base Windows 7 boot, I run Chrome as my browser, but
> > each instance opens pages related to the particular OS. I find this
> > approach leads to less confusion, and since I'm going to become 64 in
> > two days, I have to consider confusion as a major topic LOL.
> >
> > A.
> >
> > On Sun, Nov 13, 2011 at 12:49 PM, Salakhetdinov Shamil <mcp2004 at mail.ru>wrote:
> >
> > > Hi Arthur --
> > >
> > > > At the moment, I'm running Windows 7 as the native boot, and then
> > > > running Oracle VirtualBox inside that, and inside that, I run
> > > > various VMs, including Ubtuntu, Mint and Windows 8 Preview CTP 3.
> > > > Everything works just ducky.
> > > > ...for now this arrangement suits me to a tee.
> > >
> > > May I know what is your hardware to run all that stuff?
> > >
> > >
> > --
> > 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
> 




More information about the AccessD mailing list