navteam articles
navteam
Published
4 min read
Sample of how to write a simple XML document using MSXML DOM in NAV
This post if for when you need to export data in the form of XML from Microsoft Dynamics NAV. If you are not familiar with how to program with MSXML DOM, then it can take a lot of time and work to create even a simple XML document.
Published
1 min read
Release of Microsoft Dynamics NAV 5.0 SP1
It is with great pleasure that I can announce the release of Microsoft Dynamics NAV 5.0 SP1. During today the first countries will be available from PartnerSource and I would really like you to pay attention to the following two web sites on PartnerSource: Microsoft Dynamics NAV 5.
Published
2 min read
Simple query to check the recent blocking history
SQL Server 2005 keeps (some) history of the number and time that blocking occurred on indexes. This blog contains a query that queries this information to help identifying on which tables blocking happens most. The query shows accumulated numbers (no. of blocks, wait time, etc) since SQL Server was last restarted.
Published
4 min read
How to detect locking order for a NAV process
The nature of a deadlock is that two processes lock resources in different orders. Deadlocks can in theory be eliminated by ensuring that all processes always lock resources in the same order. This document describes how to determine the locking order of a process in Microsoft Dynamics NAV. Note, that I mention locking of “resources”.
Published
3 min read
Record-level locking in the SQL Server option for Microsoft Dynamics NAV
If you are designing a system for high throughput and want to minimize blocking, it’s important to know in advance exactly what kind of locking behaviour to expect. On SQL Server, Microsoft Dynamics NAV uses record-level locking, as opposed to table-level locking on the native database server.
Published
3 min read
How to Set Up Job Queue in Microsoft Dynamics NAV 5.0
The Job Queue is handling the order of batch jobs and code units that are setup to run at a given time. The application server reads from the job queue and determines what job to run next. Several parameters can be set up to determine this.
Published
3 min read
The Personal Touch : Personalization in Microsoft Dynamics NAV “6.0”
One of the most important features (if not the most important) of Dynamics NAV ‘6.0’ is the innovative RoleTailored user experience (UX).
Published
2 min read