One of the announced features for Dynamics 365 Business Central 2024 Wave 1 release is the possibility to enable or … More
Tag: SQL
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
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: 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
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: new features for performant code
In the training I’ve done to some partners last week, when talking about performances I shared an example of an … 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
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
Exposing Dynamics 365 Business Central data to the outside world: my two cents
I had a discussion in the last days on socials with some of my followers (yes, I have them :D) … More
Dynamics 365 Business Central on-premise Wave 2: how to create databases and perform technical upgrades
I’ve explained few days ago how to change a license from customer’s one to partner’s one when working with Dynamics … 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
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
Moving an on-premise Dynamics 365 Business Central database to Azure SQL via Powershell
If I have an on-premise installation of Dynamics 365 Business Central, can I move my database from a local SQL … More
Dynamics 365 Business Central on-premise and extensions: what happens to my third-party integrations?
In a real-world Microsoft Dynamics NAV implementations, is quite common to see integrations with third-party external applications. These integrations are … More
Using SQL Data Sync with Microsoft Dynamics NAV on-premise and Azure SQL Database
In many Microsoft Dynamics NAV implementations we have situations where the NAV database is often “coupled” with a second database … More
Backup your NAV on-premise database to Azure Blob Storage
In these days we had an internal discussion with our marketing department in order to increase the Azure adoption of … More
Microsoft Dynamics NAV on Azure: SQL Server on Azure VM best practices
When talking about Microsoft Dynamics NAV installed on Azure, we have mainly two choices: use an Azure VM with SQL … More
Serverless processing with Microsoft Dynamics NAV and Azure Functions
Deploying Microsoft Dynamics NAV to the Azure cloud (IaaS) is now one of our first proposal on every new customer. … More
GDPR: Data Classification for on-premise SQL databases
We’ve talked some days ago about the new Azure SQL feature (actually in preview) regarding data discovery and classification, in … More
Azure SQL and Information Protection (GDPR)
I’m talking a lot on this blog about Azure SQL and its usage as a PaaS database engine for many … More
Microsoft Dynamics NAV on Azure SQL: performance tuning
In the previous days, we’ve discussed a serie of benefits of using Azure SQL Database with NAV if you’re planning … More
Azure SQL needs more consideration with NAV
When deploying a solution architecture with Microsoft Dynamics NAV as the ERP of your choice, you already know that the … More
Google BigQuery: and Microsoft?
Google BigQuery is really a fascinating technology for big data analysis. In short terms BigQuery enables super-fast, SQL-like queries against … More