MS SQL Server 2012 - DBA Articles

Overview of SQL Server Services



Overview of SQL Server Services

SQL Server components are executable programs that run as a Windows service. Programs that run as a Windows service can continue to operate without displaying any activity on the computer screen.

SQL Server Database Engine

The Database Engine component of SQL Server is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications in your enterprise.

SQL Server supports up to 50 instances of the Database Engine on a single computer. For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.

More Reference URL: http://msdn.microsoft.com/en-us/library/ms144296%28v=sql.110%29.aspx

SQL Server Agent

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server 2012. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database.

SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company servers every weekday after hours, you can automate this task. Schedule the backup to run after 22:00 Monday through Friday; if the backup encounters a problem, SQL Server Agent can record the event and notify you.

More Reference URL: http://msdn.microsoft.com/en-us/library/ms189237%28v=sql.110%29.aspx

SQL Server Browser Service

The SQL Server Browser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions:

    01. Browsing a list of available servers
    02. Connecting to the correct server instance
    03. Connecting to dedicated administrator connection (DAC) endpoints

More Reference URL: http://msdn.microsoft.com/en-us/library/hh510203%28v=sql.110%29.aspx

SQL Server Integration Services

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

More Reference URL: http://msdn.microsoft.com/en-US/library/ms141026%28v=sql.110%29.aspx

SQL Server Analysis Services

Analysis Services provides a range of solutions for building and deploying analytical databases used for decision support in Excel, PerformancePoint, Reporting Services, and other business intelligence applications. The basis of any Analysis Services solution is a business intelligence semantic data model and a server instance that instantiates, processes, queries, and manages objects in that model.

More Reference URL: http://msdn.microsoft.com/en-us/library/bb522607%28v=sql.110%29.aspx

SQL Server Reporting Services

SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality.

Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.

More Reference URL: http://msdn.microsoft.com/en-us/library/ms159106%28v=sql.110%29.aspx

SQL Full-Text Search

Full-Text Search in SQL Server lets users and applications run full-text queries against character-based data in SQL Server tables. Before you can run full-text queries on a table, the database administrator must create a full-text index on the table. The full-text index includes one or more character-based columns in the table. These columns can have any of the following data types: char, varchar, nchar, nvarchar, text, ntext, image, xml, or varbinary(max) and FILESTREAM. Each full-text index indexes one or more columns from the table, and each column can use a specific language.

More Reference URL: http://msdn.microsoft.com/en-us/library/ms142571%28v=sql.110%29.aspx

* * * * *


Email Your Comment To AUTHOR