SQL Server Learning 3

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