XML

In the Ultra Transcenders books

AZ-305AZ-104DP-900DP-750AZ-400AZ-802DP-600DP-700PL-300SC-401MD-102DP-800

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

Terms in this definition

• FORMAT

  A DAX function that turns a value into text according to a format string, for instance "MMMM" to show a month's name. Since the output is text, numeric operations can't use it, and dynamic format strings were introduced to get around that.

Related terms

• ADMX

  Group Policy settings are defined in these XML files. The settings catalog in Intune already has many settings that depend on them, and you may import up to 20 of your own or third-party ones, at most 1 MB each and in en-us only, along with matching ADML files.

• Checksum

  Confirms that a check digit in text found by a custom sensitive information type's regex is correct, calculated from weights and a mod value. The advanced version can only be set up in PowerShell XML.

• EVENTDATA

  Inside a logon or DDL trigger, this T-SQL function hands back XML about what fired it, including the command text, login, time and type of event. Anywhere else it simply gives NULL.

• Full-text index

  Built with CREATE FULLTEXT INDEX, this token-based index covers xml, character or varbinary(max) columns in a table or indexed view. Each table can have just one, and it needs a single-column, unique, non-nullable key index.

• Native execution engine

  A vectorised engine written in C++, based on Velox and Apache Gluten, that speeds up Fabric Spark by running supported operators natively, notably for Parquet, Delta and CSV. Anything it can't handle, such as JSON, XML or structured streaming, goes back to the JVM engine; you switch it on with spark.native.enabled.

• Office Customization Tool

  Rather than writing XML by hand, admins use this browser-based tool to pick products, languages, an update channel and app preferences for Microsoft 365 Apps, then export a file for the Office Deployment Tool.

• RDL

  Paginated reports are saved as .rdl files, an XML format describing both layout and how data is retrieved. Power BI Report Builder creates them, and existing SSRS reports in this format can move to Power BI.

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