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…

Setting SQL Server Connection String Properties In Power BI and SSAS Tabular Modern Data Sources

It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern data source in Azure SSAS/SSAS Tabular 2017:

Bron : Chris Webb’s BI Blog
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…

NAV Help Server Full-Text Search Issues

Last year, we took the first steps towards proper on-line help for our add-on. Before, we had always had documentation in the form of Microsoft Word and PDF files on a network share, but the new system, based on the NAV Help Server, was intended to provide an easy-to-find, uniform, multi-language-enabled, extensible, searchable source of information for both our consultants and end-customers.

Bron : ZEN & THE ART OF C/SIDE DEVELOPMENT
Lees meer…

File to Byte Conversion – Client to Server Move

This is a very simple post on how to move a file from your client computer to server computer. We all are well equipped and experienced in moving a file directly from a physical path, if we simply need to just copy that file as we all have expertise in using File Management Codeunit.

Bron : Research – Develop – Share – Repeat
Lees meer…