TVF

In the Ultra Transcenders books

DP-600DP-700DP-800

Each book explains TVF in context, with comparison tables and the common traps.

Terms in this definition

• Event

  Table in Log Analytics where entries from Windows event logs are kept.

• RETURN

  Comes after the VAR definitions in DAX and holds the expression whose value the formula gives back. While debugging, pointing it at one variable for a while is a useful trick.

• SELECT

  A DML command in SQL used to retrieve rows from one table or several.

• LIKE

  Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.

• View

  Shows a system through one chosen group of related concerns. No view is generic; each one is tied to whichever architecture it depicts.

• Serverless

  Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.

• RLS

  Row-level security: filtering the data each person can see down to permitted rows. Power BI models apply it through DAX rules on roles, which bind just Viewers and anyone holding Read or Build; Fabric Warehouse instead uses a T-SQL policy that calls a predicate function.

Related terms

• OPENJSON

  A table-valued function that turns JSON text into rows and columns of objects and properties, either using its built-in key, value and type columns or a schema you define with WITH.

• read_files

  A SQL table-valued function that loads files in formats such as CSV, JSON, XML, Parquet, Avro, ORC, text or binary and infers their schema to return rows. Used with the STREAM keyword inside a streaming table, it relies on Auto Loader.