Dynamics 365 Business Central 2023 Wave 1 release (version 22) officially supports SQL Server 2022. This means that you can … More
Tag: Azure SQL
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: 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
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
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
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
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
Dynamics 365 Business Central on-premise performances to the max with Azure SQL Database Hyperscale
When you’re start implementing Dynamics 365 Business Central on-premise (because you’re not ready for the SaaS now), one of the … More