[AccessD] SQL Server advice

Hi Steve:

To really get up to speed fast sell a project or make one of your own.

Your current computers are limited, the MS SQL is out of date and you need a
new server2008. Cost; are you can buy some MS SQL/Server 2008 as well as
hardware off EBay. A friend bought a older noisy server off EBay, 8GB RAM,
built in RAID with 7 350GB HD, for about $350.00...It has been running fine
for a year so it was a good deal.

If you want the latest MS software, it will cost about $1200 minimum and
$2000 for the premium TechNet addition. The minimum version has all the
Servers, Office products and MS SQL versions. The premium edition also
includes all the development packages. (VS/VS Lightswitch etc.)

If the budget is limited, there are free express versions of MS SQL and VS.
They do not have all the bell-and-whistles but their features are
impressive. If you simply must have the full versions, you can download and
use them for 60 to 90 day free-trial.

There also is some other pricing specifically for developers but I am not
familiar with process or the programs and some on the DBA will know the
details.

HTH
Jim
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond
Sent: Monday, September 05, 2011 12:55 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] SQL Server advice

After mucking around on the fringes for too long I am ready to make a more
committed leap into SQL Server.  I can foresee a customer  needing to
upgrade their Access back end within the next six months to a year and want
to get 'expertly' ahead <vbg>.
I have a fully licenced 2000 Standard edition (acquired with an Action Pack
in the days when MS New Zealand charged a one-time fee for Action Packs) on
a 10-year-old WinXP box (¾GB) and I am comfortable with this at the 'play'
level.

On a year-old Windows 7 box with 4GB, my question concerns which tool to
use, the above ... or SQL Server 2008 R2 Express?  The downsides that I can
see of Express 2008 would be (a) another learning curve (b) the nagging
feeling that I remember something about these less-than-complete SQL Server
implementations that is not good - like inability to do important
development stuff that is available in the full-blown models.  This, iirc,
was true for one of MS's implementations, long ago.  The upside is that I
make the enormous leap into another century.  But wait, there's got to be
more (to both -ve and +ve).

Any feedback gratefully received.   

Stephen Bond 

PS - I'm a bit like Arthur (same age and increasingly pursuing other
interests), so we're not talking long-term large commitments here (financial
or long learning curve).

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com