Dynamics 365 Business Central on-premises and SQL Server 2025.

Yesterday Microsoft announced the general availability for SQL Server 2025. This new edition brings important changes for partners and customers … More

High performance workflows with Azure Logic Apps: using Azure SQL as storage provider.

In the past I wrote many posts and also done a lots of sessions at different conferences about how to … More

Azure Function SQL Trigger: how to use it (and why it can be useful in your Business Central projects)

This post comes as a follow-up of my “Serverless Integrations for Dynamics 365 Business Central” training I’ve done yesterday in … More

Dynamics 365 Business Central: the problem of large data deletion.

In the last two months I was invited to speak at two partner’s events and during those events I had … More

Dynamics 365 Business Central: Cloud Migration FAQ (Directions EMEA version)

At Directions EMEA 2024 in Vienna I talked a bit about the Cloud Migration tool during the Microsoft Regional Session … More

Dynamics 365 Business Central: why not start supporting the JSON data type for table fields?

In the last months I worked on some cloud-based applications that use Azure SQL as backend (details not relevant here) … More

Dynamics 365 Business Central: Cloud Migration secrets and tips.

I think that everyone of you know that you can quite easily migrate from Dynamics 365 Business Central on-premises to … More

Dynamics 365 Business Central: why not reviewing the SaaS storage cost policy?

In these days I had a talk with some partners asking me some guidelines and suggestions on how trying to … More

Semantic Search and Vectors support on Dynamics 365 Business Central: this is the right moment.

Some weeks ago we had a nice interview with two amazing US guys (Brad Prendergast and Kristoffer Ruyeras aka Kris … More

Dynamics 365 Business Central: Edit in Excel and Long Running SQL queries

Dynamics 365 Business Central has (from a long time) a nice feature for the end user called Edit in Excel. … More

How we (probably) broke limits at the #BCAIHackathon

Last week Microsoft organized the #BCAIHackathon initiative, a 3 days dedicated to create innovative solutions using generative AI in Dynamics … More

Dynamics 365 Business Central: introducing the new Table Key module

One of the announced features for Dynamics 365 Business Central 2024 Wave 1 release is the possibility to enable or … More

Dynamics 365 Business Central: SQL Server and Read Committed Snapshot Isolation impact.

One of the greatest thing introduced in the latest Dynamics 365 Business Central release if cerainly the TRI STATE LOCKING … More

“Decoupling”: the misterious word for many Dynamics 365 Business Central partners.

In the last year I’m seeing lots of existing Dynamics 365 Business Central on-premises customers deciding to move their ERP … More

Dynamics 365 Business Central 2023 Wave 2 release: measuring the impact of the new data structure

Dynamics 365 Business Central 2023 Wave 2 release (v23) introduces important changes on the new data structure for table extensions … More

Dynamics 365 Business Central 2023 Wave 2 release: will it be the fastest release so far?

Some days ago Microsoft publicly releases the Release Wave 2 plans for Dynamics 365 and Power Platform products and also … More

Dynamics 365 Business Central and SQL Server 2022

Dynamics 365 Business Central 2023 Wave 1 release (version 22) officially supports SQL Server 2022. This means that you can … More

Dynamics 365 Business Central, Azure SQL and Optimized Locking

Optimized locking is a new Azure SQL database engine feature recently announced that drastically reduces lock memory and the number … More

Dynamics 365 Business Central and bulk inserts

Today I’ve discovered that not everyone knows how Dynamics 365 Business Central (but also Dynamics NAV) handles inserts on the … More

Dynamics 365 Business Central: DataTransfer on upgrades and performances

At the beginning of September 2022 I wrote this post introducing the new DataTransfer data type (available from Business Central … More

Dynamics 365 Business Central: are you doing cloud data migration? Please sanitize your database before doing it.

I’ve decided to write this quick post after having spent some hours on supporting a partner in order to discover … More

Dynamics 365 Business Central: new indexing features on 2021 Wave 2 release

Dynamics 365 Business Central 2021 Wave 2 release (version 19) introduces some new indexing features that you can use on … More

Dynamics 365 Business Central on-premise and SQL on Azure VM: reducing storage costs

If you search on my blog, I’we written in the past a lot of articles with suggestions and best practices … More

Dynamics 365 Business Central: SetLoadFields performances with reference passing or value passing parameters

I’ve written in the past some posts with tips on how to write code for performances and how to be … More

Securing your Azure SQL Database with a private endpoint

Some days ago I discussed with some partners the architecture of a possible datawarehouse system for external BI analysis connected … More

Dynamics 365 Business Central: point in time restore of a Production environment

Yesterday Microsoft has officially released one of the most requested feature for the Dynamics 365 Business Central SaaS environment: point … More

Auto-scaling your Azure SQL database with Logic Apps

I think that you know that I’m a huge fan of using Azure SQL database for your workloads in the … More

Read-scale out with Azure SQL and Dynamics 365 Business Central

In the last month I had the chance to test the read-scale out feature of an Azure SQL Database with … More

My session at Global Azure Bootcamp 2020: 15 tips to follow when deploying Azure Functions to production

Thanks to all the attendees that followed my session yesterday at Global Azure Bootcamp 2020. We saw 15 tips that … More

Azure SQL Serverless tier: a way to save cost for your workloads in the cloud

When going to the cloud, saving costs while maximizing performances is always a goal to reach but sometimes also not … More

Dynamics 365 Business Central and data compression

Yesterday Kennie Nybo Pontoppidan (from the Dynamics 365 Business Central Team) asked us an interesting question: do you use data … More

LinkedObjects on Dynamics 365 Business Central: be careful now!

One of the common (and basic) way to create integrations between systems in Microsoft Dynamics NAV in the past was … More

Creating an Azure SQL Database backup via Powershell

I have several Azure SQL databases (mainly Microsoft Dynamics NAV databases) on different Azure subscriptions and often I need to … More

Dynamics 365 Business Central Wave 2: on-premise and direct SQL integrations

Do you remember this post? I wrote it long time ago to explain what happens on SQL Server when you … More

Azure SQL Elastic Pools: a way for saving costs with your Microsoft Dynamics ERP databases in the cloud

I’ve written a lot in the past about how you can move your existing on-premise Microsoft Dynamics NAV / Dynamics … More