---
id: video/Sh3ySQSTw-o
type: video
title: "What's new: Server and Database (2026 release wave 2)"
summary: "Server and database changes in the 2026 release wave 2: AL runtime on .NET 10, streaming Excel import, a recent records virtual table, zero-join table extensions (up to 30 percent faster), index management changes, system fields in analysis mode and profiles, permissions overview navigation, and telemetry RT 0056 for Excel exports."
tier: official
language: en
tags:
  - al runtime
  - .net 10
  - excel streaming
  - recent records
  - table extensions
  - database optimization
  - zero-join
  - index management
  - system fields
  - analysis mode
  - permissions
  - telemetry
system: platform
review:
  state: reviewed
  by: opus
  at: "2026-10-07T22:43:41.717Z"
  flags: []
generated:
  at: "2026-10-09T00:29:02.995Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 54550bd8d4984c59773df77bf52e7ca85f87940413daa0f482c6d287fdd8e4f9
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=33s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 33
    quote: with this version the NST now runs on .NET 10, the latest and greatest in the net
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=59s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 59
    quote: now we're using a streaming based implementation for open Excel way more way less memory usage when you want to open up big uh
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=172s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 172
    quote: fields back on the base table there will be no more joints
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=195s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 195
    quote: will be up to uh 30% faster. You can see uh the different um numbers here from our benchmark
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=282s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 282
    quote: you can both find in normal tellme by searching indexes or you can use the advanced one via semantic search and you will now
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=413s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 413
    quote: we can now add an index that spans both the base table and your extension fields
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=447s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 447
    quote: you can now use system fields uh in analysis mode and also in profiles.
  - kind: video
    url: https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=725s
    title: "What's new: Server and Database (2026 release wave 2)"
    date: "2026-10-01T13:03:24.000Z"
    commit: null
    t: 725
    quote: we have had an ask for adding telemetry on who did open in Excel. the like the the best fraud example I can come
links:
  learn: []
  objects: []
  features:
    - feature/573314
    - feature/573315
    - feature/573317
    - feature/573322
    - feature/573332
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: Sh3ySQSTw-o
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=Sh3ySQSTw-o
published_at: "2026-10-01T13:03:24.000Z"
duration_s: 831
captions: full
audience:
  - developer
  - administrator
  - functional consultant
chapters:
  - t: 0
    title: Introduction
  - t: 33
    title: "AL runtime: .NET 10, Excel streaming, recent records virtual table"
  - t: 106
    title: "Database optimization: table extensions data model history"
  - t: 172
    title: Zero-join table extension benefits and performance
  - t: 227
    title: "Index management: discoverability improvements and Tell me integration"
  - t: 353
    title: "Index management: runtime enablement and cross-table indexes"
  - t: 424
    title: System fields in analysis mode and profiles
  - t: 536
    title: MCP server and reporting features
  - t: 605
    title: "Security: permissions overview navigation and telemetry for Excel exports"
  - t: 760
    title: Resources and closing
features:
  - name: .NET 10 runtime
    status: unclear
    t: 33
    verified: false
    status_source: video
  - name: Streaming-based Excel import
    status: unclear
    t: 46
    verified: false
    status_source: video
  - name: Recent records virtual table
    status: unclear
    t: 70
    verified: false
    status_source: video
  - name: Optimized table extensions data model - zero-join
    status: ga
    t: 117
    verified: false
    status_source: roadmap
    roadmap_ids:
      - "573332"
  - name: Table extension performance gains
    status: ga
    t: 172
    verified: false
    status_source: roadmap
    roadmap_ids:
      - "573332"
  - name: Index management improvements
    status: unclear
    t: 227
    verified: false
    status_source: video
  - name: Runtime-controlled index enablement
    status: ga
    t: 353
    verified: false
    status_source: roadmap
    roadmap_ids:
      - "573314"
  - name: Cross-table indexes
    status: ga
    t: 397
    verified: false
    status_source: roadmap
    roadmap_ids:
      - "573315"
  - name: System fields in analysis mode
    status: ga
    t: 447
    verified: false
    status_source: roadmap
    roadmap_ids:
      - "573322"
  - name: System fields in profiles
    status: ga
    t: 536
    verified: false
    status_source: roadmap
    roadmap_ids:
      - "573322"
  - name: Permissions overview navigation
    status: unclear
    t: 605
    verified: false
    status_source: video
  - name: Telemetry for Excel export audit
    status: ga
    t: 705
    verified: false
    status_source: roadmap
    roadmap_ids:
      - "573317"
objects_mentioned:
  - other recent records virtual table
  - table GL Entry
quotes:
  - t: 33
    text: with this version the NST now runs on .NET 10, the latest and greatest in the net
    check: exact
  - t: 59
    text: now we're using a streaming based implementation for open Excel way more way less memory usage when you want to open up big uh
    check: exact
  - t: 172
    text: fields back on the base table there will be no more joints
    check: fuzzy
  - t: 195
    text: will be up to uh 30% faster. You can see uh the different um numbers here from our benchmark
    check: exact
  - t: 282
    text: you can both find in normal tellme by searching indexes or you can use the advanced one via semantic search and you will now
    check: exact
  - t: 413
    text: we can now add an index that spans both the base table and your extension fields
    check: exact
  - t: 447
    text: you can now use system fields uh in analysis mode and also in profiles.
    check: exact
  - t: 725
    text: we have had an ask for adding telemetry on who did open in Excel. the like the the best fraud example I can come
    check: exact
---

# What's new: Server and Database (2026 release wave 2)

> Server and database changes in the 2026 release wave 2: AL runtime on .NET 10, streaming Excel import, a recent records virtual table, zero-join table extensions (up to 30 percent faster), index management changes, system fields in analysis mode and profiles, permissions overview navigation, and telemetry RT 0056 for Excel exports.

[Watch on YouTube](https://www.youtube.com/watch?v=Sh3ySQSTw-o) · Microsoft Dynamics 365 Business Central (YouTube) · 2026-10-01 · 13:51 · tier official · reviewed (checked by Opus)

## Overview

This 14-minute video from the Business Central team covers the server and database area of the 2026 release wave 2. It starts with the AL runtime: the NST now runs on .NET 10, Excel files are opened with a streaming implementation that uses less memory, and a new virtual table exposes recent records to AL.

The main part covers the table extension data model. Extension fields are stored back on the base table, so reads of base and extension fields together need no joins. The video then covers index management (discoverability, runtime enablement, cross-table indexes), system fields in analysis mode and profiles, permissions overview navigation, and telemetry for Excel exports.

## Key points

- The NST runs on .NET 10, so the AL runtime gets the improvements of that platform.
- Opening Excel files uses a streaming implementation, which lowers memory usage and avoids out-of-memory errors on large files.
- A recent records virtual table is exposed to AL. It lets you query and delete the recent records shown in the UI when pages open, and is otherwise read-only.
- Table extension fields are stored back on the base table, which removes all joins between base and extension fields. Reads are faster, and delete, update, insert and modify are up to 30 percent faster in the shown benchmark.
- Indexes can be defined with enabled equal false and enabled or disabled at runtime in code, for example based on feature usage. Indexes can also span base table and extension fields.
- Index management is easier to find: Tell me search (including semantic search) opens an index management list where you pick a table, and the table information page has a new manage indexes button. SIFT indexes are now listed so they can be disabled too.
- System fields (created by/on, last modified by/on, system ID) show in analysis mode column pickers, and system fields such as modified by can be added to profiles in the page designer. Telemetry tag RT 0056 records who opens data in Excel, and the permissions overview can be reached from permission sets and table information pages.

## Chapters

- [0:00](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=0s) Introduction
- [0:33](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=33s) AL runtime: .NET 10, Excel streaming, recent records virtual table
- [1:46](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=106s) Database optimization: table extensions data model history
- [2:52](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=172s) Zero-join table extension benefits and performance
- [3:47](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=227s) Index management: discoverability improvements and Tell me integration
- [5:53](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=353s) Index management: runtime enablement and cross-table indexes
- [7:04](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=424s) System fields in analysis mode and profiles
- [8:56](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=536s) MCP server and reporting features
- [10:05](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=605s) Security: permissions overview navigation and telemetry for Excel exports
- [12:40](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=760s) Resources and closing

## Features

| Feature | Status | At |
|---|---|---|
| .NET 10 runtime | status not stated | [0:33](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=33s) |
| Streaming-based Excel import | status not stated | [0:46](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=46s) |
| Recent records virtual table | status not stated | [1:10](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=70s) |
| Optimized table extensions data model - zero-join | generally available (roadmap [Faster data loading with improved data model for table extensions](../features/573332.md)), demoed | [1:57](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=117s) |
| Table extension performance gains | generally available (roadmap [Faster data loading with improved data model for table extensions](../features/573332.md)), demoed | [2:52](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=172s) |
| Index management improvements | status not stated, demoed | [3:47](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=227s) |
| Runtime-controlled index enablement | generally available (roadmap [AL developers can turn indexes on/off in AL code.](../features/573314.md)), demoed | [5:53](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=353s) |
| Cross-table indexes | generally available (roadmap [Developers can define indexes that span fields from a base table and its table extensions](../features/573315.md)) | [6:37](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=397s) |
| System fields in analysis mode | generally available (roadmap [Use system audit fields in analysis mode and in profiles](../features/573322.md)), demoed | [7:27](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=447s) |
| System fields in profiles | generally available (roadmap [Use system audit fields in analysis mode and in profiles](../features/573322.md)), demoed | [8:56](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=536s) |
| Permissions overview navigation | status not stated, demoed | [10:05](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=605s) |
| Telemetry for Excel export audit | generally available (roadmap [Monitor usage of Open in Excel with telemetry](../features/573317.md)) | [11:45](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=705s) |

A status with a roadmap link comes from the Microsoft 365 roadmap feature this part of the video covers (matched by Haiku; links Opus dropped are not used); other statuses need a status word in the video itself.

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- other "recent records virtual table" at [1:30](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=90s)
- table "GL Entry" at [4:55](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=295s)

Not found in BC28-30: table "GL Entry".

## Quotes

- [0:33](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=33s) "with this version the NST now runs on .NET 10, the latest and greatest in the net"
- [0:59](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=59s) "now we're using a streaming based implementation for open Excel way more way less memory usage when you want to open up big uh"
- [2:52](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=172s) "fields back on the base table there will be no more joints"
- [3:15](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=195s) "will be up to uh 30% faster. You can see uh the different um numbers here from our benchmark"
- [4:42](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=282s) "you can both find in normal tellme by searching indexes or you can use the advanced one via semantic search and you will now"
- [6:53](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=413s) "we can now add an index that spans both the base table and your extension fields"
- [7:27](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=447s) "you can now use system fields uh in analysis mode and also in profiles."
- [12:05](https://www.youtube.com/watch?v=Sh3ySQSTw-o&t=725s) "we have had an ask for adding telemetry on who did open in Excel. the like the the best fraud example I can come"

Presenters (as heard): Kenny Pabidan, Mascot.