SQL Server Database Tutorial

Check out the Latest SQL Server Management Studio Version 18.5 New Features and Bug Fixes:

https://sqlservertutorialspoint.blogspot.com/2020/05/sql-server-management-studio-version185.html

Commenting the doubts / questions / suggestions about this release will improve our SQL Server Knowledge and Expecting response from our SQL Experts.🤩🤩

SQL Server Management Studio Version 18.5 New Features and Bug Fixes SSMS 18.5, SQL Server Management Studio 18.5, SSMS New Features, Bug Fixes

What is SQL Server?

-> It is a software, developed by Microsoft, which is implemented from the specification of RDBMS.

-> It is also an ORDBMS.

-> It is platform dependent.

-> It is both GUI and command based software.

-> It supports SQL (SEQUEL) language which is an IBM product, non-procedural, common database and case insensitive language.

Usage of SQL Server:

-> To create databases.

-> To maintain databases.

-> To analyze the data through SQL Server Analysis Services (SSAS).

-> To generate reports through SQL Server Reporting Services (SSRS).

-> To carry out ETL operations through SQL Server Integration Services (SSIS).

SQL Server Components:

SQL Server works in client-server architecture, hence it supports two types of components: (a) Workstation and (b) Server.

-> Workstation components are installed in every device/SQL Server operator’s machine. These are just interfaces to interact with Server components. Example: SSMS, SSCM, Profiler, BIDS, SQLEM etc.

-> Server components are installed in centralized server. These are services. Example: SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL browser, SQL Server full text search etc.