| Lesson 5 || Starting SQL Server services |
| Objective ||Start the Services available in Microsoft SQL Server 2012 |
Start Services available in Microsoft SQL Server
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 Service Manager
Programs>>Microsoft SQL Server 2012>>Service Manager
If you are using Windows, you can configure your computer to
invoke 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
Here is the result:
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