ArcherPoint Dynamics NAV Developer Digest – vol 51
The ArcherPoint technical staff—made up of developers, project managers, and consultants – is constantly communicating internally, with the goal of sharing helpful information with one another.
As they run into issues and questions, find the answers, and make new discoveries, they post them companywide on Yammer for everyone’s benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this group—so we thought, wouldn’t it be great to share them with the rest of the Microsoft Dynamics NAV Community? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from the ArcherPoint staff. We hope these insights will benefit you, too.
Michael Heydasch shared an article on SQL Server Worker Threads and NAV:
From the NAV Team, good information about parallelism and worker threads in Microsoft SQL Server: "Microsoft Dynamics NAV has been configured to use the Microsoft SQL Server database engine as efficiently as possible. This includes using SQL queries which are appropriate for parallel query execution to speed up the retrieval of data when the SQL Server is configured to allow this..."
Kyle Hardin on NAV 2013 R2 company-level company backup and restore:
If you are using the new NAV2013R2 company-level backup and restore, be aware that it is common to get a Schema error message during the restore: Cannot import the data because the database schema in the database is different from the schema for the data that you want to import.
I first suspected a difference in table objects, but that wasn't it. This article says to clear out certain data from the Object Metadata Snapshot table in the source database and the restore worked.
Cannot Import the Data because the Database Schema in the Database is Different from the Schema for the Data that You Want to Import
There is a better article on how to do company-level backup and restore:
Dara Daly shared an article on getting more out of your marketing automation investment:
This useful article covers several ways companies can get their lagging marketing automation efforts re-energized and moving forward again. Worth the read.
Scott Peetz shared a video on the Backward Bicycle:
This is a great video that demonstrates how hard it is to relearn something we already know. There are several great takeaways from this video, and it is definitely worth the time to watch it.