• Une évaluation gratuite
  • Navigator
  • Academy
  • Partner Portal
  • Devenez partenaire du QBS Group
  • France
    • Global
    • Belgique - Français
    • België - Nederlands
    • Danmark
    • Deutschland
    • España
    • Italia
    • Nederland
    • Norge
    • Österreich
    • Polska
    • Schweiz
    • Sverige
    • United Kingdom
  • Global Global Global en
  • Belgique - Français Belgique - Français Belgique - Français fr-be
  • België - Nederlands België - Nederlands België - Nederlands be
  • Danmark Danmark Danmark da
  • Deutschland Deutschland Deutschland de
  • España España España es
  • France France France fr
  • Italia Italia Italia it
  • Nederland Nederland Nederland nl
  • Norge Norge Norge no
  • Österreich Österreich Österreich at
  • Polska Polska Polska pl
  • Schweiz Schweiz Schweiz ch
  • Sverige Sverige Sverige sv
  • United Kingdom United Kingdom United Kingdom en-uk
QBS group
Menu
  • Informations
    • Blogs
    • Actus
    • Close
  • Événements
  • Solutions logicielles
  • Services
    • QBS Academy
    • Services Azure by QBS
    • Close
  • Programmes
    • Ready to Start – Programme Microsoft Dynamics 365 Business Central
    • Fournisseur indirect Microsoft CSP
    • Programme ISV
    • Nos partenaires
    • Close
  • Qui sommes-nous
    • Qui sommes-nous
    • Vision, Mission and Strategy
    • Timeline
    • Contact
    • Close
Blog écrit par:

Andy De Rosa

Temps pour lire:6 Minutes
Partagez ceci:
  • Partager sur Facebook
  • Partager sur Twitter
  • Partager sur Google+
  • Partager sur Linkedin
  • Partager par Mail
30 octobre 2020

Why is Azure SQL so important for Dynamics 365 Business Central?

Vous êtes ici : Accueil » Why is Azure SQL so important for Dynamics 365 Business Central?

Azure

Business Central

Let us start with a common question:

“When a customer is not considering going with Business Central SaaS, what are the options to move to the cloud?”

Dynamics 365 Business Central has a clear advantage against competitor ERP solutions that do not offer and on-premises or hybrid solution. When we talk about deployment choices, we are really referring to two elements:

  1. Business Central Service Tier(s)
  2. SQL Server database

Most non-SaaS deployments are often split into three configurations:

  1. Fully on-premises
  2. Azure VM hosted (Service Tiers) & tenanted SQL database (PaaS)
  3. Azure VM hosted (Service Tiers & SQL Server)

Each of these common configurations has its own advantages and disadvantages. There is clearly not a right or wrong configuration here. It is ultimately all down to what requirements customers have.

Whilst the three options above are the snapshot of a complete Business Central deployment, we need to pay particular attention to the database and where it is hosted!

When deciding on where the database should reside, the options are:

  1. Install SQL Server on-premises
  2. Install SQL Server on an Azure VM
  3. Use Azure SQL Database (PaaS)

When you decide to adopt options 1 and 2, there is a high level of maintenance involved. This often falls entirely or partially with the Dynamics partner, certainly with many SMB customers deployments, where they do not have a dedicated IT department.

Option 3, on the other hand, offers the capabilities of SQL Server in a PaaS configuration. This means that the maintenance (patching, security, etc.) fall entirely on the service provider, in this case, Microsoft Operations.

Contrary to general belief, SQL Server (on-premises/Azure-hosted version) and Azure SQL, differ in design. The latter is specifically architected for cloud computing, performance, and scalability. Some additional features such as geo-replication and geo-redundancy, are only available with Azure SQL.

What’s the difference between Azure SQL and SQL Server?

When comparing the performance of Azure SQL database and a SQL Server deployed to a virtual machine, we need to consider a few intrinsic “differences”:

  • Azure SQL Database is a high-availability database.
  • Azure SQL Database is a scalable and intelligent service that includes features such as high-availability, backups, automatic index tuning, security vulnerability assessment, and advanced threat detection. When choosing a pricing tier for running your production database, make sure that you compare this to a similar setup for SQL Server on a virtual machine (including the cost of administration and maintenance).
  • The performance of an Azure SQL database is correlated to the price you pay for usage, and new pricing models evolve over time. Use the scalability options within the service to change the database performance tier for your installation as your workload changes over time.

So why is it recommended for Business Central?

You can deploy a Business Central database to Azure SQL Database. Azure SQL Database is a cloud service that provides data storage as a part of the Azure Services Platform.

To optimize performance, Microsoft recommends that the Business Central Server instance that connects to the database is also deployed on a virtual machine in Azure. Additionally, the virtual machine and SQL Database must be in the same Azure region.

For development and maintenance work on Business Central applications. If the Dynamics NAV Development Environment is installed on the same virtual machine in Azure as the Business Central Server, then you can connect to the Azure SQL database from the development environment.

Does QBS Group offer any training for my technical resources on this specific topic?

Of course, we do! Our very own Jan Veenendaal, Partner Technical Strategist, has developed a unique “hands-on” workshop only available from QBS Group to educate our Partners about this topic. Here you will find the full details of the workshop: Learn more about Workshop Azure SQL on our Training page.

Plus d’articles

Ce qui pourrait également vous intéresser

  • Hébergement Azure pour Dynamics NAV/Business Central ?

    Qu’est-ce que l’hébergement Azure pour Dynamics NAV/Business Central et […]

  • Do you really need the Business Central Universal Code Initiative? Are you shocked? Let’s hope not…

    What’s the Business Central Universal Code Initiative? For a […]

  • Dynamics 365 Update Webcast – 9 December 2021

    Microsoft Dynamics 365 update 9 décembre 2021 Ce webcast […]

  • The Dynamics 365 Migration Journey – Infographic
  • En tant qu’entreprise informatique, votre organisation est-elle prête à vendre Microsoft Business Solutions ?
  • Partenaire, développez un business model réussi avec Dynamics 365 Business Central

    En tant que revendeur de logiciels, qu’est-ce que cela […]

  • Solution ERP Microsoft Dynamics 365 Business Central pour les PME

    Que vaut Microsoft Dynamics 365 Business Central en tant […]

  • Dynamics 365 Update Webcast 1 July 2021

    This series of webcasts is intended to share the […]

  • Cosmos versus Azure SQL and how to integrate with Dynamics 365 Business Central #MSDYN365BC

    One of the highest-scoring FAQs from partners and customers […]

  • Dynamics 365 Update Webcast 27 May 2021

    This series of webcasts is intended to share the […]

  • How to use the Dynamics 365 Business Central API with C# in Service-to-Service scenarios

    A question that was raised more frequently than others […]

  • Get Insights from Microsoft about the directions of Business Central in the SMB Channel

    Michael Hartman, CEO of QBS Group, interviewed Mike Morton, […]

  • ERP Migration – the Friendly Hill That One Day May Become a Hostile Mountain

    Cloud computing is probably the most profound IT-innovation of […]

  • Why is Application Insights so important with Dynamics 365 Business Central?

    I can understand why some people would still refrain […]

  • Ready to Start – Programme Microsoft Dynamics 365 Business Central
  • Dynamics 365 Update Webcast 10 December 2020

    This series of webcasts is intended to share the […]

  • Dynamics 365 Update Webcast 15 October 2020

    This series of webcasts is intended to share the […]

  • What is the MB-800 Microsoft Dynamics 365 Business Central Exam and why does it matter?

    Microsoft has launched a brand-new certification exam for Dynamics […]

  • Why use Azure BLOB Storage with Business Central?

    What is Azure BLOB Storage and why is this […]

  • Dynamics 365 Update Webcast 25 June 2020

    This series of webcasts is intended to share the […]

  • From NAV via Business Central on-premises to Cloud

    In this time of digital transformation, it is recommended […]

  • Best practices of migrating your customer to Business Central SAAS

    “Migrating Dynamics NAV customers to Dynamics 365 Business Central […]

  • Dynamics 365 Update Webcast 7 May 2020

    This series of webcasts is intended to share the […]

  • Dynamics 365 Update Webcast 6 February 2020

    This series of webcasts is intended to share the […]

  • Update on Dynamics 365 Business Central 18 November 2019

    This series of webinars is intended to share the […]

  • Dynamics 365 Business Central 2019 release Wave 2

    As of October 1, 2019, Microsoft has launched Dynamics […]

  • QBS Marketplace
  • Update on Dynamics 365 Business Central 27 August 2019

    This series of webinars is intended to share the […]

  • Dynamics 365 Business Central April 2019 update – key findings

    April 19 2019 Dynamics 365 Business Central Release   Our […]

  • Update on Dynamics 365 Business Central 13 June 2019

    This series of webinars is intended to share the […]

  • Update on Dynamics 365 Business Central 9 May 2019

    Watch here the Webinar update of the 9th of May 2019.

  • What does the latest Dynamics 365 Business Central Update (April ’19) mean for Europe, Middle East & Africa?

    The April 2019 Business Central Licensing Guide has recently been released, but are there differences from the previous ones? In short, yes.

  • L’équipe QBS group Mid Europe rencontre 1ClickFactory

    Depuis le début de l’année, QBS group représente 1ClickFactory au Benelux. Il s’agit dès lors de la 2e région où QBS group constitue le point de contact exclusif de 1ClickFactory. Toutefois, quelle est l’action de 1ClickFactory et de quels avantages nos partenaires QBS group peuvent-ils bénéficier?

  • Update on Dynamics 365 Business Central 11 April 2019

    This series of webinars is intended to share the […]

  • Update on Dynamics 365 Business Central 14 March 2019

    Technical update and License update 1 April 2109

  • All you need to know about Microsoft Dynamics NAV coming to an end and becoming Microsoft Dynamics 365 Business Central

    (this page will continuously be updated as information arrives) […]

  • Update on Dynamics 365 Business Central 7 February 2019

    This series of webinars is intended to share the […]

  • Directions EMEA 2018 Business Report

    This unique report features a broad but insightful and independent business reporting on the happenings at DIRECTIONS EMEA 2018.

  • Microsoft Dynamics 365 – the perfect platform for new business ventures

    Microsoft has thousands of business partners. Is this market not the red ocean?

  • Ready to Go for Dynamics 365 Business Central
  • Dynamics 365 Business Central sur Microsoft Azure

Ce que l’on dit à propos du Groupe QBS

  • Ferry Schrijnewerkers

    Owner en Co-founder at MKB365

    Since the start of our company 4 months ago, we have already completed 12 Dynamics 365 for Sales implementations.

    Read the reference case
  • Joaquim Antón Gimeno

    GRUPO CHOICE

    "Our relationship with QBS group allows us to improve our marketing strategy."

    Read the reference case
  • Sofkia

    "Our alliance with QBS group has been very important in the development of our business strategy."

    Read the reference case
  • VS Sistemas

    "QBS group helps us build our road to success."

    Read the reference case
  • Berith Skov - C2IT Business Solutions

    “We are very satisfied with the services provided by and through QBS group."

    Read the reference case
  • Herke ICT Group- Karing Buzing

    We are once again part of a NAV community.

    Read the reference case
  • Owe Loonstra - Verito

    Manager Sales & Marketing

    The fact that we belong to a larger organisation gives our customers security.

    Read the reference case
  • Adfocom - Jeroen Kersten

    Partner Care saved us a lot of time.

    Read the reference case
  • NavAzure - Michael Francois Knudsen

    “It is important to me, that I through QBS become part of a greater network, where partners can share experience"

    Read the reference case
  • Blisss - Dirko Wijers

    Without the help from QBS group we wouldn’t have succeeded.

    Read the reference case

Programme

  • Devenir partenaire
  • Fournisseur indirect du programme Microsoft CSP
  • Programme ISV
  • Nos partenaires

Centre d’Information

  • Références
  • Blog
  • Formation
  • Événements
  • Actus
  • Newsletter

Prestations de service

  • Dynamics 365 Business Central sur Microsoft Azure
  • Services de mise à niveau
  • QBS Academy

Follow QBS group

© Copyright QBS group 2023
  • Cookie Policy
  • Privacy Policy
Dynamics 365 CRM Update Webcast 16 October 2020 Dynamics 365 CRM Update Webcast 6 November 2020
We are now Companial!

This is our old website, we’re now Companial.

The content on this page might be outdated.

Enjoy all the new information on our new website.

 

Go to Companial

Contactez-nous, merci de remplir ce formulaire

Rejoignez le QBS Group veuillez remplir le formulaire

Rejoignez le QBS Group veuillez remplir le formulaire

Veuillez remplir le formulaire

Veuillez remplir le formulaire

Veuillez remplir le formulaire


If you are not seeing the form, please check your ad-blocker settings.

Sign up QBS Group Membership

Send me an email.
Download Center

Register for this event
QBS
  • France
    • Global
    • Belgique - Français
    • België - Nederlands
    • Danmark
    • Deutschland
    • España
    • Italia
    • Nederland
    • Norge
    • Österreich
    • Polska
    • Schweiz
    • Sverige
    • United Kingdom
  • Informations
    • Blogs
    • Actus
    • Back
  • Événements
  • Solutions logicielles
  • Services
    • QBS Academy
    • Services Azure by QBS
    • Back
  • Programmes
    • Ready to Start – Programme Microsoft Dynamics 365 Business Central
    • Fournisseur indirect Microsoft CSP
    • Programme ISV
    • Nos partenaires
    • Back
  • Qui sommes-nous
    • Qui sommes-nous
    • Vision, Mission and Strategy
    • Timeline
    • Contact
    • Back

Nous utilisons des cookies pour vous offrir la meilleure expérience possible. En cliquant sur le bouton "Accepter", vous acceptez les cookies et consentez à la politique de confidentialité.

Faire défiler vers le haut