Microsoft SQL Server
Microsoft SQL Server is a Relational Database
Management System (RDBMS) designed to run on platforms ranging from laptops to
large multiprocessor servers. SQL Server is commonly used as the backend system
for websites and corporate CRMs and can support thousands of concurrent users.
SQL Server comes with a number of tools to help you
with your database administration and programming tasks.
SQL Server is much more robust and scalable than a
desktop database management system such as Microsoft Access. Anyone who has
ever tried using Access as a backend to a website will probably be familiar
with the errors that were generated when too many users tried to access the
database!
Although SQL Server can also be run as a desktop
database system, it is most commonly used as a server database system.
Server Database Systems
Server based database systems are designed to run
on a central server, so that multiple users can access the same data
simultaneously. The users normally access the database through an application.
For example, a website could store all its content
in a database. Whenever a visitor views an article, they are retrieving data
from the database. As you know, websites aren't normally limited to just one
user. So, at any given moment, a website could be serving up hundreds, or even
thousands of articles to its website visitors. At the same time, other users
could be updating their personal profile in the members' area, or subscribing
to a newsletter, or anything else that website users do.
Generally, it's the application that provides the
functionality to these visitors. It is the database that stores the data and
makes it available. Having said this, SQL Server does include some useful
features that can assist the application in providing its functionality.
Enterprise Manager
Enterprise Manager is the main
administration console for SQL Server. Those of you familiar with
operating Windows servers will probably notice that Enterprise Manager sits
within the Microsoft Management Console (MMC). For those who aren't familiar
with MMC, MMC is the standard console for presenting administrative tools (such
as the IIS web server) within Windows.
Enterprise Manager enables you to create database
objects (such as databases, tables, views etc), you can configure user
accounts, you can set up scheduled tasks, transfer data between databases, and
more.
You can use Enterprise Manager to connect to as
many databases on as many servers as you like. You can group these servers by
configuring a "server group". The above screenshot has one server
group called "SQL Server Group". This is the default name SQL Server
gives to the initial server group. For each server group, you can add any
number of servers. And, for each server, you can add any number of databases.
Most of the tasks performed with Enterprise Manager
are initiated either from the top menu, or by right-clicking on an icon/object.
Technical
|
Information
|
|---|---|
| Title: | SQL Server 2000 Enterprise |
| File Size: | 463.2 MB |
| File Type: | Zip |
| Location: | Mediafire |
| Date Added: | January 23, 2013 |
Post a Comment
Please Comment.....