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.