SQL Server services for managing SQL Server services
can provide data storage, processing, controlled access, is the most basic SQL Server System services
SQL Server Analysis Server service
provides analytical processing (olap,on-line analysis processing) and data mining capabilities for business intelligence applications
SQL Server Agent Service
Monitor SQL Server, fire alerts, allow automatic execution of certain administrative tasks
Opening and closing of services
Press and hold Win+r, open the Run box, enter Services.msc, open the Services window
Locate the SQL Server service, right-click to start, stop, pause, restart
Managing SQL Server services using SSMS
Start SQL Server Management Studio, select View Registered server
Select the database server that you want to start, right-click Service control to start
SQL Server2008 Main Components Introduction
SQL Server2008 is primarily composed of server components, management tools, and 3 parts of the documentation.
Server components
SQL Server database engine, a core service for storing, processing, and securing data, replication, full-text search, and tools for managing relational and XML data.
Analysis Services services, tools for creating and managing online analytical processing (OLAP) and data mining applications.
The Reporting Services service, a server and client component for creating, managing, and deploying tabular reports, Matrix reports, graphical reports, and free-form reports, can be used to develop extensible platforms for reporting applications.
The Integration Services service is a set of graphical tools and programmable objects for moving, copying, and transforming data.
Not to be continued ...
SQL Server Learning 3