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 and all about the Microsoft's technology stack | www.microsoftarchitects.com

  • HOME
  • ABOUT ME
  • MY BOOKS
    • 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

Category: SQL

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

AL, Azure SQL, D365BC, Dynamics 365 Business Central, MSDyn365BC, MsDynNAV, NAV, Performance, SQL

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

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

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

D365BC, Dynamics 365 Business Central, ERP, MSDyn365BC, MsDynNAV

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

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

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

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

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

D365BC, Dynamics 365 Business Central, Extensions, MSDyn365BC

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

Azure, Azure SQL, Cloud, Datawarehouse, Security, SQL

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

Cloud, D365BC, Dynamics 365 Business Central, MSDyn365BC

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

Azure, Azure SQL, Cloud, Dynamics 365 Business Central, MSDyn365BC, MsDynNAV, SQL

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

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

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, Azure Functions, Azure SQL, AzureDevOps, Cloud, Global Azure Bootcamp

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

Azure, Azure SQL, Cloud, D365BC, Dynamics 365 Business Central, MSDyn365BC, Serverless, SQL

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

D365BC, Dynamics 365 Business Central, MSDyn365BC, MsDynNAV, NAV, SQL

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

AL, D365BC, Dynamics 365 Business Central, Extensions, MSDyn365BC, 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

Azure, Azure SQL, Dynamics 365 Business Central, Microsoft Dynamics, MSDyn365BC, MsDynNAV, Powershell

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

D365BC, Dynamics 365 Business Central, Extensions, MSDyn365BC, SQL

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

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

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

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

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

Azure, Cloud, D365BC, Dynamics 365 Business Central, MSDyn365BC, MsDynNAV, Powershell, SQL

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

Azure, NAV, SQL

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

Azure, Cloud, ERP, NAV, SQL

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

Azure, NAV, SQL

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

GDPR, NAV, SQL

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

Azure, GDPR, NAV, SQL

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, Cloud, NAV, SQL

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

Azure, Cloud, NAV, SQL

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

Azure, Big Data, BigQuery, Google, SQL

Categories

.NET Azure Books Cloud Conference DevOps Docker Dynamics 365 Business Central 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
  • Follow Following
    • Stefano Demiliani
    • Join 412 other followers
    • Already have a WordPress.com account? Log in now.
    • Stefano Demiliani
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

    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