Lets SSMS and similar tools create, change, remove or refresh objects over XMLA, through JSON-formatted commands plus object definitions. Requires compatibility 1200 or above.
Also called Tabular Model Scripting Language.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains TMSL in context, with comparison tables and the common traps.
Terms in this definition
- SSMS
SQL Server Management Studio, a tool for administering SQL Server, used for tasks such as building a target schema.
- CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.