Returns rows from a sorted, optionally partitioned table, either at fixed positions (ABS) or relative to the current row (REL). Running totals plus moving averages are common uses.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains WINDOW 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.
Related terms
- Automatic backups
Backups that Azure SQL takes on its own, allowing point-in-time restore over a window of 1 to 35 days. Keeping backups longer requires long-term retention (LTR).
- Burndown
The Fabric capacity mechanism whereby spare CUs in later timepoints repay carryforward, the overage that went past the 10-minute window. Throttling stays in place until the carryforward has been fully paid off.
- Business hours
A pipeline check restricting stage starts to a configured time window.
- Carryforward
When a Fabric capacity's overage goes beyond the 10-minute throttling window, the excess is pushed into future timepoints and gradually repaid from unused capacity (burndown); throttling lasts until it's gone.
- Conditional Access insights and reporting
Using sign-in data sent to a Log Analytics workspace, this workbook estimates what all your Conditional Access policies, report-only ones included, would do together over a chosen window between 4 hours and 90 days. It needs an Entra ID P1 licence and a role of Security Reader or above.
- Duplicate detection
A Service Bus option that drops any incoming message whose MessageId, set by the sending application, matches one already received during a chosen time window.
- Enhanced session mode
A VMConnect mode in Hyper-V that runs over RDP, giving a virtual machine's console window resizing, a shared clipboard, sound and redirection of local devices.
- Event Hubs Capture
Automatically saves Event Hubs data as Avro files in ADLS Gen2 or Blob Storage, cutting a file whenever a size or time window is reached.