+ Post New Thread
Results 1 to 5 of 5
Educational Software Thread, SQL Server Express for ICT students in Technical; I've had a request from one of the 6th form ICT students, via his ICT teacher, to have SQL Server ...
  1. #1

    Join Date
    Jul 2006
    Location
    London
    Posts
    2,962
    Thank Post
    159
    Thanked 152 Times in 116 Posts
    Rep Power
    49

    SQL Server Express for ICT students

    I've had a request from one of the 6th form ICT students, via his ICT teacher, to have SQL Server Express installed on all the ICT machines, as they apparantly need it.

    My question is, do they? We currently have Visual Studio 2008 (to be upgraded to 2010 over summer) and I'm sure that it included some sort of basic SQL server for use in development? (to be fair we may not have installed it) Would that be enough?

    Just not really sure I want 60+ SQL servers on our network. If the above is incorrect, would a single server that students could put their databases on be better?

  2. #2

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    Set it up in a single instance on a server and create a database for each student on it.

  3. #3


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    Server instance would be far better.

    Your argument for this is that if kids move around they might fancy keeping their databases.

  4. #4

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,156
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    124
    If you've done a full install of Visual Studio 2008 (or 2010) then you will have SQL installed.

    I'd definitely recommend putting it on a server for the students to use. You need to find out exactly what they're wanting to do. If they need to be able to create databases (which is quite reasonable) then you may be better having multiple instances (name them with the student usernames??) because you can then make the student the owner of the databases and they can't accidentally or deliberately mess up other people's work.

    If they're just going to create/modify/delete tables then giving them each a database on the same SQL server should be fine.

  5. #5

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,927
    Thank Post
    1,626
    Thanked 1,895 Times in 1,408 Posts
    Blog Entries
    2
    Rep Power
    429
    Server instance once again. No need for each child to have there own individual databases when a server instance will easily cover all of there needs.

SHARE:
+ Post New Thread

Similar Threads

  1. SQL Server Express 2005 Memory Limit per instance?
    By localzuk in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 30th April 2010, 01:27 PM
  2. SQL Server Express 2008
    By damienharrison in forum Windows Vista
    Replies: 6
    Last Post: 13th March 2009, 11:26 AM
  3. Serco Facility and MS SQL server Express edition
    By cheredenine in forum MIS Systems
    Replies: 19
    Last Post: 19th December 2008, 06:42 PM
  4. SQL Server Management Studio Express
    By Michael in forum Windows
    Replies: 4
    Last Post: 21st May 2008, 05:09 PM
  5. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 02:56 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •