Skip to content
Stefano Demiliani

Stefano Demiliani

  • Follow me on Twitter
  • Follow me on LinkedIn

Taking the Web out of the box: Microsoft Dynamics 365 Business Central, Microsoft Dynamics NAV, Azure, Serverless, Power Platform and all about the Microsoft's technology stack | www.microsoftarchitects.com | www.d365bc.com

  • HOME
  • ABOUT ME
  • MY BOOKS
    • Mastering Dynamics 365 Business Central 2nd Edition
    • Mastering Dynamics 365 Business Central
    • Microsoft Dynamics 365 Business Central Development Quick Start Guide
    • Azure DevOps Explained
    • Building ERP Solutions with Microsoft Dynamics NAV
    • Implementing Azure Cloud Design Patterns
    • Migrating Applications to the Cloud with Azure
  • TRAININGS
    • Microsoft Official Trainings
  • PROJECTS
    • SDOps: build pipelines for Dynamics 365 Business Central made easy
  • SPEAKING
  • CONSULTANCY
  • MY COMPANY
  • Microsoft Dynamics 365 Business Central Community
  • Microsoft Dynamics NAV Community

Tag: Performance

Dynamics 365 Business Central: use sequential GUIDs when possible.

I think that everyone of you know what a GUID is. A GUID (Globally Unique Identifier) is a 128-bit number … More

AL, Azure SQL, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, SQL

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

Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, MsDynNAV, NAV, Performance, SQL

Evaluating LLMs performances for your AI task: presenting my LLMEvaluator.

After my session about creating AI solutions in Dynamics 365 Business Central using Managed vs Custom AI at Directions EMEA … More

.NET, .NET Core, AI, Azure, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, llm, MSDyn365BC, Performance

Introducing YAMPI: the MCP server for Dynamics 365 Business Central administration.

At the end of November 2024 Anthropic introduced the Model Context Protocol (MCP), an open standard and open-source framework created with the goal to standardize … More

AI, AL, Azure, Cloud, Copilot, D365BC, delegated admin, DevOps, Dynamics 365 Business Central, ERP, Extensions, GitHub, GitHub Copilot, MCP, MSDyn365BC, Performance, Security, Visual Studio Code

Dynamics 365 Business Central: announcing Italy North availability.

This is the post for the Italian customers and partners that I had in the bag from months. I think … More

Azure, Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance

Understanding LLM performance degradation: a deep dive into Context Window limits

Large Language Models (LLMs) have revolutionized how we interact with AI, but they come with a critical constraint: the context … More

.NET, AI, Azure, Cloud, D365BC, Dynamics 365 Business Central, llm, MSDyn365BC, Performance

Azure Logic Apps: Built-in vs Managed Azure Blob Storage Connector.

When creating workflows with Azure Logic Apps that uses the Azure Blob Storage Connector, you have the possibility to select … More

Azure, Azure Logic Apps, Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance, Security, Serverless

Dynamics 365 Business Central: finally we’ll have TRUNCATE table in SaaS.

In the last 3 years I wrote many times about the need to have the possibility to execute a massive … More

AL, Azure SQL, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, SQL

Azure Logic Apps: are you handling large blobs? Keep memory usage under control.

When working with Dynamics 365 Business Central (and generally speaking on a lot of other serverless projects) it’s quite common … More

Azure, Azure Logic Apps, Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance, Power Automate, Serverless

Dynamics 365 Business Central: compressing API responses at max.

In the last part of the session I’ve done with Duilio at BC TechDays this year on how we handle … More

AL, API, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, Visual Studio Code

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, Azure Logic Apps, Azure SQL, Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance, Serverless, SQL

Dynamics 365 Business Central: the problem of large data deletion – part 2: AlterKey

Yesterday I talked about the always more increasing need to perform large data deletion in SaaS for some tables and … More

AL, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance

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

AL, Azure, Azure SQL, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, NAV, Performance, SQL

Dynamics 365 Business Central: what I want for Santa is…

Often when approaching the end of the year we love to contact our Dynamics 365 Business Central customers and asking … More

AL, Azure, Azure SQL, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, MVP, Performance

Azure Logic Apps: stateful and stateless workflows overview and performance comparison.

Azure Logic Apps Standard is a new deployment option for creating and running automated workflows in a single-tenant environment. This … More

Azure, Azure Logic Apps, Cloud, D365BC, Dynamics 365 Business Central, MSDyn365BC, Performance, Serverless

Dynamics 365 Business Central: be careful on your upgrade code.

It’s the second time that I see partners asking informations about the following message coming from Dynamics 365 Business Central: … More

AL, Azure, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, Telemetry

How Dynamics 365 Business Central handles incoming web service calls (for dummies).

In the last two days I was in Assago (Milano) at the WPC Conference, probably the most important IT conference … More

AL, API, Azure, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, OData, Performance

Me @ Directions EMEA 2024

Also this year Directions EMEA conference is approaching and next week all the EMEA’s Microsoft Dynamics 365 Business Central partner’s … More

AL, Cloud, Conference, D365BC, Dynamics 365 Business Central, ERP, Extensions, Microsoft, MSDyn365BC, MVP, Performance

Dynamics 365 Business Central: adding fields to the new Modern Search engine via AL code.

Some weeks ago I wrote a post explaining, with some technical details, the new Modern Search feature introduced with Dynamics … More

AL, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance

Dynamics 365 Business Central 2024 Wave 2: new Search in List pages (but don’t abuse of it)

Dynamics 365 Business Central 2024 Wave 2 release (version 25) introduces a new search capability for list pages. Now users … More

Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance

Running inline C# scripts in Azure Logic Apps workflows

Last week I wrote a post explaining the new Inline Powershell action available in Azure Logic Apps standard. With this … More

.NET, .NET Core, Azure, Azure Logic Apps, Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance, Power Automate, Serverless, Visual Studio Code

Dynamics 365 Business Central: the power of NumberSequence

Assigning number series to documents seems a simple task to users but in an ERP (where concurrency is always present) … More

AL, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, Visual Studio Code

Dynamics 365 Business Central: monitoring field changes with telemetry is better…

In a traditional Dynamics 365 Business Central project, expecially when the customer is a large company, it’s quite often requested … More

Application Insights, Azure, Azure Monitor, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, Telemetry

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

Application Insights, Azure, Azure Monitor, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance, Telemetry

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

AL, Azure SQL, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, SQL

Monitoring your Azure OpenAI usage (part 2)

In a previous post I wrote about how you can monitor your Azure OpenAI usage with Azure Monitor and Application … More

AI, Application Insights, Azure, Azure Monitor, Cloud, D365BC, Dynamics 365 Business Central, MSDyn365BC, Performance, Telemetry

Azure Functions and Data Parallelism: things to know.

When working with code on some complex data operations, sometimes to improve performances it’s possible to use code techniques like … More

.NET, .NET Core, Azure, Azure Functions, Azure Storage, Performance, Serverless, Visual Studio Code

Monitoring your Azure OpenAI usage

I want to continue the saga of “using Azure OpenAI in a professional way” by talking a bit about a … More

AI, Application Insights, Azure, Azure Monitor, Cloud, Copilot, D365BC, Dynamics 365 Business Central, MSDyn365BC, Performance, Telemetry

Dynamics 365 Business Central: Copilot, Azure OpenAI and real-world enterprise usage.

We are entering a new era of AI, one that is fundamentally changing how we relate to and benefit from … More

AI, AL, API, Azure, Cloud, Copilot, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance

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

Azure SQL, Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance, SQL

Azure Functions and Blob Triggers: be careful on the binding type.

This post is borned to signal a problem that I’ve recently found in a customer and I think that sharing … More

Application Insights, Azure, Azure Functions, Azure Monitor, Cloud, Performance, Visual Studio Code

Dynamics 365 Business Central: is my on-premises customer ready for SaaS?

“Is my Dynamics 365 Business Central on-premises customer ready to be moved on SaaS?“. “Will the SaaS platform able to … More

Application Insights, Azure, Azure Monitor, Cloud, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance, Telemetry

The history of a Dynamics 365 Business Central data processing workflow…

Once upon a time there was a workflow named SpongeFlow created with the intention of processing complex data coming from … More

Azure, Azure Logic Apps, Cloud, D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, Performance, PowerAutomate, PowerPlatform

Dynamics 365 Business Central and Retention Policies: please KISS!

No… you don’t have to spread kisses all over the world, but probably the opposite… 🙂 I think that many … More

AL, D365BC, Dynamics 365 Business Central, ERP, Extensions, MSDyn365BC, Performance

Azure Functions with VNET integration: remember to enable Runtime Scale Monitoring

When working with Azure Functions, in real-world projects could happen that you need to connect to resources in an Azure … More

Azure, Azure Functions, Cloud, Performance, Serverless

Posts navigation

Older posts

Categories

.NET AI Azure Books Cloud Conference DevOps Docker Dynamics 365 Business Central MCT MVP NAV Personal Power Apps Power Automate Power Platform Powershell SQL Teams Uncategorized Visual Studio Code Webcasts
Follow Stefano Demiliani on WordPress.com

Post Archive

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Create a website or blog at WordPress.com
  • Subscribe Subscribed
    • Stefano Demiliani
    • Join 632 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Stefano Demiliani
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
 

Loading Comments...