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

Tag: 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: 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

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: 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

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

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

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

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

Cloud, D365BC, Dynamics 365 Business Central, ERP, Integration, MSDyn365BC, OData, SQL

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

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

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

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

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

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

Azure, Azure Functions, Cloud, NAV, Serverless, 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

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