Database Reference
In-Depth Information
Overview of MS SQL Server
This chapter provides an overview of the Microsoft SQL Server DBMS. Relatively
speaking, SQL Server represents the most recent introduction of a major DBMS suite in
the marketplace. It is also somewhat different from other products. For these two reasons,
we will deviate slightly from the structure of the previous two chapters, as we cover
additional but relevant information about the product. The chapter therefore proceeds
under the following captions:
•
Introduction
•
Main Features of SQL Server
•
Editions of SQL Server
•
Main Components of the SQL Server Suite
•
SQL Server Default databases
•
SQL Server Default Logins
•
Named versus Default Instances
•
Removing SQL Server
•
Shortcomings of SQL Server
•
Summary and Concluding Remarks
By the time this volume is available to the public, many of components mentioned
will likely be outdated. The focus therefore is to describe the general product
environment that an MS SQL Server user is likely to see. The discussion will be broadly
based on products MS SQL Server 2005 and MS SQL Server 2008.