SQL Server DBA
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network
The Database Engine sits at the core of the SQL Server components. The engine operates as a service
on a machine, which is often referred to as an instance of SQL Server. You can run multiple instances
of SQL Server on a given server. When you connect to SQL Server, the instance is the target of the
connection. Once an application is connected, it sends Transact-SQL (T-SQL) statements to the instance. The instance in return sends data back to the client. Within the connection is a security layer
that validates access to the data as specified by the database administrators (DBAs).
Transact structured Query language (T-SQL)
TSQL stands for Transact structured Query language which is a Microsoft tool and extension of SQL language. TSQL mainly used for writing entire program of block function procedure that defines how things need to be complete and creating an application in which each application sending transact query over SQL server and there is no interaction with database. It executes as a whole block with extension of SQL language.
There different type T-SQL function are used in T-SQL :
- Scalar function
- Ranking function
- Aggregate function
- Row set function