Setup Visual Studio Code and NAV 2018 for local NAV server installation

It is clear that the future of NAV is Visual Studio Code and AL. And to be honest I find more fun and interesting to play with this “smart text editor” compared to the old “development UI” C/Side. Even if at the beginning it seems more difficult because you need to know in what places to add certain pieces of code related to the object’s structure while in C/Side you are helped by the UI.

Bron : Andrei Lungu
Lees meer…

SQL Server 2017 and Dynamics NAV

Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to announce that the following Dynamics NAV versions are compatible with the SQL Server 2017 database engine:
• Microsoft Dynamics NAV 2018
• Microsoft Dynamics NAV 2017
• Microsoft Dynamics NAV 2016
• Microsoft Dynamics NAV 2015

Bron : Dynamics NAV Team Blog
Lees meer…

How to connect SQL Server Management Studio to the NAV 2018 database on Docker?

Recently someone asked me how to connect SQL Server Management Studio to the database on a Docker image for NAV 2018. Before I could answer Jakub Vaňák already did and said: “Of course it is. If you want to access the default instance inside one of MS NAV containers you can access it from your docker host machine providing the name of your container.”

Bron : Think about IT
Lees meer…

How the SQL Server Transaction Log Works for You

The transaction log lies at the core of SQL Server, but it’s often misunderstood. Understanding the log architecture will give you peace of mind and make you a better administrator.

The transaction log is a double entry system. Every activity is recorded in the log before it is carried out in the database. So what’s the purpose of all this extra work?

Bron : Fenwick Software
Lees meer…