During installation of SQL Server 2008 also comes a very important part of communications tools, providers, maintenance plans, implementation of backup plan and further development opportunities through BI (Business Intelligence) that are SERVICES.
Through these services managed data, their security reach to have a very strong integration with the operating system Windows Server 2003 and later, with Visual Studio through which achieved a genuine development of many parts of the application associated with services for example sending automatic messages, replication of the data, mirroring etc.
The following will describe in detail all these services that are available to be used by you as Administrator.
SQL Server Configuration Manager is responsible for managing SQL Server services and protocols.
The primary tasks that you will perform after installation are:
- Starting, stopping, pausing and restarting service
- Changing service accounts and service account passwords
- Managing the start-up mode of a service
- Configuring service start-up parameters
You should never change service accounts or service account passwords using the Windows Service Control applet.
Instances define the container for all operations you perform within SQL Server. At the time of creating instance automatically create all objects of it as the SQL Server level but also at the database level. Two Instances never used the same objects; each has its own objects.
By disabling enumeration responses by setting the Hide Instance to Yes, you prevent someone from using discovery techniques to locate servers running SQL Server for a possible attack.
GO: SQL Server Configuration Manager à SQL Server Network ConfigurationàProtocols for instance name à right click Propertiesà Flagsà Hide Instance: Yes/No.
SSIS (SQL Server Integration Services) has a variety task to enable packages to upload or download file from FTP sites, manipulate files in directories, import files into databases, or export data to files.
SSIS can send and receive messages from Microsoft Messages Queue (MSMQ), and respond to Windows Management Instrumentation (WMI) events.
If SSIS does not ship with a task already designed to meet your needs, you can write your own processes using the Visual Studio Tools for applications.
SSRS (SQL Server Reporting Services) fills the data delivery gap by providing a flexible platform for designing reports as well as distributing data throughout an organization.
A sales Manager can create a subscription to a daily sales report such that the report is generated at midnight after all sales activity is completed, have it rendered in a .PDF format, and dropped in his e-mail inbox for review.
SSRS ships to main components a report server and a report designer.
SSAS (SQL Server Analysis Services) as a volume of data within an organization explodes; you need to deploy tools that allow users to make business decisions in a near-real-time basis.
Users can no longer wait for IT to design reports for the hundreds of questions that might be asked by a single user.
SSAS was created to fill the gap between the data needs of business users and the ability of IT to provide data.
SSAS encompasses two components
Online Analytical Processing (OLAP)
OLAP engine allows you to deploy, query, and manage cubes that have been designed in BIDS.
Data Mining engine extends business analysis to allow users to fund patterns and make predictions.
I hope that this was even a little bit of help, explanations and function of these services. If a good configuration and use of services, remains the only identification of further opportunities for these services.
Hotek, Mike. MS SQL Server 2008-Implementation and Maintenance