SQL Server Database Administration Tips & Tricks

Welcome to SQL Server Dba Traning Blogs WeWill Learn SQL Developer, SQL DBA, SQL Reporting Services, SSRS, SSIS & Performance Tuning Releated Query & Articles. We, Will, Provide to all VMware, Windows Server Administration Training with Updated Versions  in this Blogs 

SQL Server Key Components and Services.

Database Engine: This component handle storage, Rapid transaction Processing, and Securing Data.

SQL Server: This service starts, stops, pauses, and continues an instance of Microsoft SQL Server. The executable name is sqlservr.exe.

SQL Server Agent: It performs the role of Task Scheduler. It can be triggered by any event or as per demand. The executable name is sqlagent.exe.

SQL Server Browser: This listens to the incoming request and connects to the desired SQL Server instance. The executable name is sqlbrowser.exe.

SQL Server Full-Text Search: This lets users running full-text queries against Character data in SQL Tables. An executable name is fdlauncher.exe.

SQL Server VSS Writer: This allows backup and restoration of data files when the SQL server is not running. The executable name is sqlwriter.exe.

SQL Server Analysis Services (SSAS): Provide Data analysis, Data mining, and Machine Learning capabilities. SQL Server is integrated with R and Python language for advanced analytics. The executable name is msmdsrv.exe.

SQL Server Reporting Services (SSRS): Provides reporting features and decision-making capabilities. It includes integration with Hadoop. The executable name is ReportingServicesService.exe

SQL Server Integration Services (SSIS): Provided Extract-Transform and Load capabilities of the different types of data from one source to another. It can be view as converting raw information into useful information. Executable name is MsDtsSrvr.exe