SQLConfiguration SQLConfiguration


SQL Server  «Prev  Next»
Lesson 5 Starting SQL Server services
Objective Start the Services available in Microsoft SQL Server 2012

Start the Services available in Microsoft SQL Server 2012

In the previous lesson, you learned about the services that enable you to access SQL Server. These services are configured via the Service Manager dialog box.
To invoke the Service Manager, choose Programs>>Microsoft SQL Server 2012>>Service Manager.
If you are using Windows, you can configure your computer to
invoke the SQL Server services automatically on start-up.
The simulation below will show you how to start the MS SQL Server.
start-msSql-server
In the next lesson, you will learn about the SQL Server 2012 architecture.

Do not use Hungarian notation for Relational Databases

Often, novice database designers (particularly those who come from interpretive or procedural programming backgrounds) feel the need to use a form of Hungarian notation and include prefixes or suffixes in names to indicate the kind of object. For example, tblEmployee or tblCustomer.
Prefixes like this are generally considered a bad practice, because names in relational databases are almost always used in an obvious context. Using Hungarian notation is a good idea when writing procedural code (like Visual Basic or C#), since objects do not always have a very strict contextual meaning that can be seen immediately upon usage, especially if you are implementing one interface with many different types of objects. In SQL Server Integration Services (SSIS) packages, I commonly name each control with a three- or four-letter prefix to help identify them in logs.
However, with database objects, questioning whether a name refers to a column or a table is rare. Plus, if the object type is not obvious, querying the system catalog to determine it is easy. I will not go too far into implementation right now, but you can use the sys.objects catalog view to see the type of any object. For example, this query will list all of the different object types in the catalog

SELECT distinct type_desc
FROM sys.objects

Here is the result:
type_desc
-------------------------
CHECK_CONSTRAINT
DEFAULT_CONSTRAINT
FOREIGN_KEY_CONSTRAINT
INTERNAL_TABLE
PRIMARY_KEY_CONSTRAINT
SERVICE_QUEUE
SQL_SCALAR_FUNCTION
SQL_STORED_PROCEDURE
SQL_TABLE_VALUED_FUNCTION
SQL_TRIGGER
SYNONYM
SYSTEM_TABLE
UNIQUE_CONSTRAINT
USER_TABLE
VIEW


We will use sys.objects and other catalog views throughout this book to view properties of objects that we create.

Starting MS Sql Server Service - Exercise

Click the Exercise link below on the left to practice starting the services that are part of SQL Server 2012.
Starting MS Sql Server Service - Exercise