Server – Pardaan.com

Running Microsoft SQL Server 2019 Developer Edition in a Docker Windows container

Note: This work is based on the “Official Microsoft repository for SQL Server in Docker resources” found here: https://github.com/microsoft/mssql-docker/tree/master/windows/mssql-server-windows-developer Unfortunately this has not been updated to run Windows ServerCore 1890 and Microsoft SQL Server 2019 – so this is what this blog post is about… Source…

18 November 2021

Dynamics NAV & BC Tips & tricks

How Do I – Create a Docker Container Using Local SQL Server using BC-Containerhelper

This video explains how we create a docker container using BC-Containerhelper for Dynamics NAV or Business Central with database that is hosted in your local SQL Server. Source : Saurav Dhyani Read more...

7 May 2021

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central SaaS: save a file to an SFTP server (the Logic App way)

Yesterday I’ve provided a solution for saving a file generated directly from a Dynamics 365 Business Central SaaS tenant to an SFTP server by using Azure Functions. I’ve to admit that this is my preferred way because it gives me more freedom, scalability and adaptability. But…

9 April 2020

Dynamics NAV & BC Tips & tricks

Creating new instances of Business Central web servers using PowerShell

Although you can use the Business Central Setup to install the Business Central Web Server components and create a single web server instance in IIS for client connection, there may be scenarios when you want to set up multiple instances. For example, you could set up…

8 April 2020

Data & Analysis

Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler

A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what happens when a dataset is refreshed, for example…

7 April 2020

Dynamics NAV & BC Tips & tricks

Add translations to your NAV/BC Server

Yesterday I got a question via LinkedIn. I need to add Spanish translation to my W1 instance. How do I do that? So, let me walk you through that process. Here is my Business Central setup. It is the Icelandic Docker Container, so I have Icelandic…

2 April 2019

Dynamics NAV & BC Tips & tricks

Using SQL Server Transparent Data Encryption (TDE) with Dynamics NAV

Over the last few months, the Dynamics NAV team has been testing compatibility with SQL Server Transparent Data Encryption (TDE), and we are now proud to announce that the following Dynamics NAV versions all support SQL Server Transparent Data Encryption (TDE): Bron : Dynamics NAV Team…

1 May 2018