• QBS Navigator
  • QBS Academy
  • QBS Partner Portal
  • Word Partner
  • België - Nederlands
    • Global
    • Belgique - Français
    • Danmark
    • Deutschland
    • España
    • France
    • Italia
    • Nederland
    • Norge
    • Österreich
    • Polska
    • Schweiz
    • Sverige
    • United Kingdom
    • Africa - English
    • Middle East - English
  • Global Global Global en
  • Belgique - Français Belgique - Français Belgique - Français fr-be
  • België - Nederlands België - Nederlands België - Nederlands be
  • Danmark Danmark Danish 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 Swedish sv
  • United Kingdom United Kingdom United Kingdom en-uk
  • Africa - English Africa - English Africa - English en-af
  • Middle East - English Middle East - English Middle East - English en-me
QBS group
Menu
  • Info Center
    • Blogs
    • Evenementen
    • Nieuws
    • Referenties
    • Close
  • Trainingen
  • Solutions
  • Services
    • Leadgeneratie voor Microsoft Dynamics Partners
    • Dynamics 365 Business Central on Azure
    • Upgradeservices
    • Marketingservices
    • Close
  • Partner programma
    • Ready to Start – Microsoft Dynamics 365 Business Central SureStep Programma
    • Ready to Start – Dynamics 365 Customer Engagement
    • Ready to Go – Dynamics 365 Business Central
    • Indirect Provider binnen het Microsoft CSP Programma
    • Onze Partners
    • Word partner
    • Close
  • Over ons
  • Contact
Blog geschreven door:

Andy de Rosa

Leesduur:6 Minutes
Delen op:
  • Share on Facebook
  • Share on Twitter
  • Share on Google+
  • Share on Linkedin
  • Share by Mail
30 October 2020

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

You are here: Home » 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.

Meer artikelen

Dit vindt u wellicht ook interessant

  • SQL en Windows Server licenties beschikbaar via CSP

    Sinds 19 januari 2021 is het voor Microsoft partners […]

  • Dynamics 365 Update Webcast 10 December 2020

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

  • Waarom onze top 5 Dynamics Partners kiezen voor Azure Hosting

    Is de stap naar een complete Dynamics 365 Business […]

  • 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 […]

  • 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 […]

  • Bedrijven met een Dynamics Enhancement Plan kunnen nu ook naar maandbetaling via het Microsoft CSP programma

    Met een speciale promo biedt Microsoft haar klanten aan […]

  • 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 […]

  • Dynamics 365 Update Webcast

    Get the latest insights from Dynamics 365 and get […]

    28 January 2021 Webcast
  • 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 ERP oplossing binnen het MKB

    Wat biedt Dynamics 365 Business Central als ERP oplossing […]

  • Ontwikkel als partner een succesvol business model met Dynamics 365 Business Central

    Wat betekent het voor u als software reseller om […]

  • 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 […]

  • Ready to Start – Microsoft Dynamics 365 Business Central SureStep Programma
  • QBShare 16 mei 2019 – Elke dag een nieuwe klant erbij

    Donderdag 16 mei hadden we ons 11e QBShare event. Naast de interessante updates over Dynamics 365 Business Central en Dynamics 365 Customer Engagement, hadden we dit keer ook een interessante sessie van partner BETA.

  • 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.

  • QBS group Mid Europe team ontmoet 1ClickFactory

    Begin dit jaar zijn wij als QBS group het gezicht van 1ClickFactory binnen de Benelux. Hierdoor zijn wij vanuit QBS group de 2e regio waarin wij exclusief voor 1ClickFactory het direct aanspreekpunt zijn. Maar wie is 1ClickFactory precies en wat doen zij voor onze QBS group partners?

  • 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) […]

  • Blisss – Dynamics Trainingen
  • 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 – Dynamics 365 Business Central
  • QBS Azure Services

Wat partners zeggen over QBS group

  • 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

Programma

  • Word Partner
  • Onze Partners

Info Center

  • Referenties
  • Blog
  • Trainingen
  • Evenementen
  • Nieuws
  • Nieuwsbrief

Services

  • QBS Azure Services
  • Upgrade Services
  • Dynamics 365 for Sales Acceleration Program

QBS group volgen

© Copyright QBS group 2021
  • Privacy Statement
Dynamics 365 CRM Update Webcast 16 October 2020 Dynamics 365 CRM Update Webcast 6 November 2020
Please complete the form

Contact us, please complete this form

Join QBS Group, please complete this form

Join QBS Group please complete the form

Sign up QBS Group Membership

Send me an email.
Please complete the form


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

Download Center

Please complete the form

Register for this event
QBS
  • België - Nederlands
    • Global
    • Belgique - Français
    • Danmark
    • Deutschland
    • España
    • France
    • Italia
    • Nederland
    • Norge
    • Österreich
    • Polska
    • Schweiz
    • Sverige
    • United Kingdom
    • Africa - English
    • Middle East - English
  • Info Center
    • Blogs
    • Evenementen
    • Nieuws
    • Referenties
    • Back
  • Trainingen
  • Solutions
  • Services
    • Leadgeneratie voor Microsoft Dynamics Partners
    • Dynamics 365 Business Central on Azure
    • Upgradeservices
    • Marketingservices
    • Back
  • Partner programma
    • Ready to Start – Microsoft Dynamics 365 Business Central SureStep Programma
    • Ready to Start – Dynamics 365 Customer Engagement
    • Ready to Go – Dynamics 365 Business Central
    • Indirect Provider binnen het Microsoft CSP Programma
    • Onze Partners
    • Word partner
    • Back
  • Over ons
  • Contact

This website uses Cookies to give you the best experience. Agreed by clicking the 'Accept' button. After you've clicked on "Accept" you accept QBS group Privacy Statement.

Scroll to top