Database Reference
In-Depth Information
•
MS SQL Sever is shipped with the following default databases:
master
,
model
,
tempdb
,
MSDB
,
pubs
, and
Northwind
.
•
MS SQL Sever has a number of shortcomings relating to
platform dependence (running only on Windows platform),
no load-balancing, poor performance, difficult reading
transaction logs, security, lack of support for Java.
MS SQL Sever has made a fair entry into a very competitive market. If not for any
other reason, we expect it to be around for the foreseeable future, due to its marriage to
the Windows platform.
18.11 Review Questions
1.
What are the main editions of MS SQL Server that are marketed?
2.
What are the main components of the MS SQL Server suite?
Briefly discuss how these components are related.
3.
Describe the default databases and logins that are provided by
MS SQL Server.
4.
Identify some benefits and drawbacks of the MS SQL Server suite.
18.12 References and/or Recommended Readings
[Beauchemin, 2005] Beauchemin, Bob, Niels Berglund, and Dan Sullivan.
A First Look at
Microsoft SQL Server 2005 for Developers.
Microsoft Press, 2005.
[DeBetta, 2005] DeBetta, Peter.
Introducing Microsoft SQL Server (TM) 2005 for Developers
(Pro - Developer)
. Microsoft Press, 2005.
[Microsoft, 2008] Microsoft.
SQL Server 2005
.
http://www.microsoft.com/sql/2005/default.mspx
(accessed October 2008).
[Microsoft, 2008] Microsoft,
SQL Server 2008
.
(accessed October 2008).
