SQL Concept

[Guest]

Hello Experts,

I appreciate this is not a SQL discussion group, but I always have the best
answers from here. So I thought I could try it here again.

I have installed SQL Server 2005 in my local machine for testing and I
expected to be presented with some kind of user interface where I could
manage my tables etc.

So I my questions is:
Can anybody explain me (in plain English please) the following?
What’s SQL Server 2005 for?
What’s the purpose of installing SQL Server in a machine (or server) if,
apparently, doesn’t change anything. I say this because I have always been
able to write SQL queries in Access and it works OK (without the SQL Server
2005 installed).
How can I use its unknown, (for me), potential?
Would you have any website that I can research about better these concepts
of SQL?

Many Thanks
Fabio

 

[Douglas J Steele]

SQL Server is a database. It stores the data.

Access is a both database and a development environment. You can create
forms and reports in Access: you can't in a database. The forms and reports
you create in Access can be used against tables in an Access database
(really a Jet database), or against databases from other DBMS, including SQL
Server.

 

[Guest]

Here is all the stuff

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

Have fun reading (there is quite a bit)