Like any big conference from Microsoft, we also got a lot of news from the Fabric Community Conference in Stockholm around Microsoft Fabric.

We really got a lot of news at Keynote, and I cannot share all of it with you. Here are my top new releases from the keynote on Tuesday:

Data Warehouse – Copilot and T-SQL Notebooks

The Data warehouse service in Fabric now has Copilot and the ability to create a T-SQL Notebook. Both are public preview state.

The Copilot on Data Warehouse can help you with the following tasks:

• Generate T-SQL queries for data analysis.
• Explain and add in-line code comments for existing T-SQL queries.
• Fix broken T-SQL code.
• Receive answers regarding general data warehousing tasks and operations.

The Copilot service in Fabric needs an F64 capacity or above to be enabled.

The new (and long waited) capability to create a T-SQL Notebook in Fabric is now also available in public preview.

With this feature, we can now leverage the T-SQL knowledge in a Notebook directly in Fabric.

Yes, we could have used PySpark SQL in the past, but now we don’t have to put our T-SQL code in the PySpark wrapper. Just write your code in the notebook and get things done.

VS Code integrations

Environments and vscode.dev integration.

With the environments in Fabric, you can control the environment settings and fully manage each environment from the portal.

This is now integrated into VS Code.

Here you can configure everything you need around runtimes, compute and public libraries (to mention a few).

There is no longer any misconceptions around Microsoft Fabric and the road to a fully online experience. With the VS Code integration in Fabric and now we also get the vscode.dev integration for Notebook debugging. This feature gives us a fully online experience for working with Notebooks in the browser in a scaled down version of VS Code. Here you will have everything you need to work on your notebooks, including breakpoints and watchers…

Lakehouse news

The Lakehouse service is not missed at this Keynote.

We saw the release of spaces in Delta table names. This gives us the ability to create table names with spaces in it. Perhaps not the biggest news, but still a huge ask from the clients I’ve been working with since the release of Fabric.

Lakehouse will now by default be Fabric Runtime 1.3, as this was announced GA. This includes the upgrade to Delta Lake version 3.2 and some updates to the Python libraries.

Fabric AI skill get a share feature

The, for me personal really awesome feature, AI skill now gets a Sharing feature. This enables you to create and share AI skills with a comprehensive security setup around the sharing experience.

The roles are:

• Co-create
• View configuration
• Query

Wait, there is more. You can also control different versions of the AI skills. You can have one version in production, one in development and one in test (or what setup you like) and easily switch between them for comparison.

Reserved max cores in workspace level

This is perhaps my most wished feature of them all, even tough it is hard to select a favorite.

With this public preview feature, we can now configure the max cores available for each workspace. Enabling the governance for distributing the compute between workspaces to ensure critical workloads to be executed before other. With a reservation of 6 nodes, the engine will ensure that all 6 nodes are available for scale up, even if the current execution is only using 4 nodes.

We also get a new setting to configure the timeout of Notebook interactive runs. By default, the session have a timeout of 20 mins, but now we can configure this to fit our needs, ensuring the distribution and usage of nodes to be as needed. There will also come an “extend session time” option for end users.

OneLake

With this public preview feature, you can now access DataBricks Unity Catalogue from OneLake as a new option in Fabric.

It is made very easy – just put in the URL of your DataBricks workspace and select the catalogue you want to be mirrored to OneLake. It is creating a shortcut to the Unity Catalogue, reflecting what is happening in the backend.

You can read all about the latest releases right here.