What is MSSQL Server?
MS SQL Server is a Relational Database Management System (RDBMS) developed by Microsoft. A Relational database is based on a Relational Model architecture. The data is organized in tables(relations), and the tables are related to each other. Each table has rows and columns(attributes). MS SQL Server is a software product used to administer the database and retrieve information.
What is SQL and T-SQL
SQL (Structured Query Language) is a domain-specific language to manage data in RDBMS. The scope of SQL includes data query, data manipulation, data definition, and data access control.
MS SQL Server has its proprietary query language called Transact-SQL or T-SQL to interact with MS SQL Server.
You can run T-SQL queries via SQL Server Utility available in SQL Server Management Studio (SSMS) or via the
Azure portal provides Query editor(preview) to run sql queries against Azure SQL database.
Tools that use T-SQL
Some of the Microsoft tools that are used to run T-SQL commands are:
In this tutorial, we will use SSMS on Windows Server 2019.
What is SQL Server Management Studio SSMS
SQL Server Management Studio (SSMS) is a management software for SQL Server database engine. An SSMS is a primary tool to connect and administer the SQL Server database engine and run Transact-SQL on the database.
- Build apps and APIs 10x faster
- Built-in authorization and caching
- 8x more performant than hand-rolled APIs