About Sql Server

 

What is SQL  Introduction, Version History

SQL SERVER is a Relational Database Management System (RDBMS) developed by Microsoft.

SQL Server is tied to Transact-SQL, or T-SQL, Microsoft’s implementation of SQL that adds a set of proprietary programming constructs.

SQL Server works exclusively on Windows & Linux  Environments Since 2016, Microsoft made it available on Linux. SQL Server 2017 became generally available in Oct 2016 that ran on both Windows and Linux Platform.

SQL Server Editions

Below are editions are available in SQL 

SQL Server Standard: It is suitable for Mid-Tier Application and Data marts. It includes basic reporting and analytics.

SQL Server Enterprise: It is used in the high end, large scale, and mission-critical business. It provides High-end security, Advanced Analytics, Machine Learning, etc.

SQL Server WEB: It is designed for a low total-cost-of-ownership option for Web hosters. It provides scalability, affordability, and manageability capabilities for small to large scale Web properties.

SQL Server Developer: It is similar to an enterprise edition for the non-production environment. It is mainly used to build, test, and demo.

SQL Server Express: It is for small scale applications and free to use.

SQL Server Instances

SQL Server allows you to run multiple services at a go, with each service having separate logins& credentials, ports no's, databases, etc. These are divided into Parts.

• Primary instances
• Named instances.

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