Transact-SQL, or T-SQL, is Microsoft’s extension to the Structured Query Language (SQL) used to manage and query Microsoft SQL Server. It includes standard database operations as well as features for variables, procedural logic, and administering SQL Server.
In cyber security, T-SQL matters because commands run with a database account’s privileges can affect sensitive data and, in some configurations, reach beyond the database. For example, SQL Server’s xp_cmdshell feature can launch Windows processes when enabled and permitted, creating a potential path from database access to host-level activity. Attackers may use database commands after obtaining credentials; defenders can reduce risk with strong authentication, least privilege, restricted network access, and monitoring for unusual commands and processes.


