How exactly is SQL Server?

Question

Is it where I put my DB? and how can I connect to the SQL server and to the DB in the SQL server? and what wil my DB called then? SQL DB or what? I am confused between the actual DB where all the tables/records are stored & the SQL server

Answer 1

SQL is a like of database language stand for "Structured Query Language"
and SQL server is a service/software when you make a request and response a set of data.
There are 4 basic syntax: select, insert, update, delete.

It is not a "FILE" type database It's a "Server-Client" type database.

There are several SQL you can get:
A. Microsoft SQL Server: http://www.microsoft.com/sql/default.mspx
B. My SQL Server: http://www.mysql.com/
C. Oracle: http://www.oracle.com
D. Sybase: http://www.sybase.com
F. Pervasive: http://www.pervasive.com/psql/?WT.ac=PSQLv9sp2_home

1. where I put my DB?
There is not file for db. you need to use import export or use query to add in database/table/records.

2. how can I connect to the SQL server and to the DB in the SQL server?
use the tool provide by the company or use "ODBC" to connect

3. what will my DB called then? SQL DB or what? I am confused between the actual DB where all the tables/records are stored & the SQL server
You can call any name for your database table.
You may not see the actual file. You just request to server and it will response your data.

Answer 2

SQL Server 2008 and SQL Server 2008 R2 are the actual Enterprise level Database Management Systems. R2 is just the most recent release. SQL Server Management Studio is part of SQL Server. It serves as a way for the Database Engineers and Administrators to setup the system and the underlying databases.

Answer 3

SQL: Structured query language.

Getting it setup is pretty is, you can just use the default options. However when it asks you authentication method I generally recommend 'Mixed Mode'. Set your sa password as something easily memorable, however its easy to get back if you forget.

Where do I put a database? -This is kinda managed for you. You run a query or right click, create database. Query would be 'Create Database Training'. This would generate two files.
1)MDF File -This is your data file.
2)LDF File -Your log file.

You need both of these.

Once you run the query I gave above, right click on 'Databases' then press refresh. Then expand.
You will see a new database called 'Training' along with a few other databases, such as 'Master' -Do not delete these.

SQL, as mentioned above is a server-client application. Meaning multiple machines 'clients' can access one central location 'server' to access the same data.

For a complete guide I recommend WS3Schools. Give it a google!

Answer 4

SQL Server is a relational database management system that is capable of handling large amount of data apart from providing several methods to ensure data integrity, it also provides advance administrative utilities. It renders complete data integrity protection and advanced security to objects.

SQL Server is a client/server Relational Database Management System (RDBMS) that uses Transact-SQL to send request between a client and SQL Server