BINARY

In the Ultra Transcenders books

DBX-GENAI

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

Terms in this definition

• 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.

• PATH

  Parent-child hierarchies in DAX rely on this function. For each row it builds one delimited text value listing the IDs of the row's ancestors, top level first and ending with the row's own ID, which PATHITEM, PATHLENGTH and friends can then pick apart.

• STRING

  The SQL type that holds text.

Related terms

• aes_encrypt

  Encrypts a value in SQL and gives back BINARY. The key must be 16, 24 or 32 bytes long, GCM is the default mode, and aes_decrypt undoes the operation.

• ai_parse_document

  Turns a BINARY document into VARIANT holding its structured content. This AI Function's output can then feed ai_prep_search, ai_classify or ai_extract.

• Apache Avro

  Compact binary data format organised by rows; Event Hubs Capture produces its files in this format natively.

• Avro

  An Apache file format that stores rows: a JSON header describes the layout, followed by record blocks held as binary. It compresses well, cutting storage needs and bandwidth.

• BLOB

  Short for binary large object: raw binary data, like pictures, audio, video or documents, that only an application can make sense of. Azure keeps these files as blobs in Blob Storage.

• Block blob

  The blob type built from individual blocks, suited to text and binary files of up to roughly 190.7 TiB; access tiers and object replication work only with this type.

• BSON

  Binary JSON, the binary form of JSON that MongoDB uses. Azure Cosmos DB for MongoDB uses it too, and you query it with MQL, the MongoDB Query Language.

• Data consistency verification

  An optional Copy activity check (validateDataConsistency) that compares row counts when copying tables, or file size, modified date and checksum when copying binary files. The extra checking makes the copy slower.