One of the common (and basic) way to create integrations between systems in Microsoft Dynamics NAV in the past was … More
Category: SQL
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
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
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
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
New book: Building ERP solutions with Microsoft Dynamics NAV
Today is THE DATE! After 9 months of work, we’re ready to go: my new book Building ERP solutions with Microsoft … More
New book: Building ERP solutions with Microsoft Dynamics NAV (ITA version)
Ebbene si… ora è ufficiale e possiamo divulgare al mondo la notizia 🙂 Dopo 9 mesi (praticamente un parto!) di … More
SQL Server backup on cloud
In my daily work I see different types of Microsoft SQL Server installations and different types of IT managers that … 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
