Microsoft Dynamics NAV Sustained Engineering Team Blog
Final Posting on the NAV Sustained Engineering Team Blog
We’re combining the NAV Sustained Engineering Blog with the NAV Team Blog, and will no longer be...
Date: 10/23/2009
Setting Up a Mail Template for Document Approval Notifications
The email notifications that are sent between users according to the document approvals setup are...
Date: 09/29/2009
Disable UAC if you are doing a technical upgrade from the same machine where SQL is hosted.
When doing a technical upgrade running Microsoft Dynamics NAV CSIDE client on the same machine as...
Date: 09/28/2009
How do Record Links encode their data in SQL server?
Recently I was asked about the encoding that it is done for record links in SQL. If you are not...
Date: 08/06/2009
SPN name Changes
It should be a common installation scenario to have NAV 2009 components installed on three different...
Date: 07/01/2009
Installing Business Notification with SQL Server 2008
We are glad to announce that compatibility between Business Notification and SQL Server 2008 is as...
Date: 05/14/2009
An almost exact decimal
Recently I was working with a very interesting case, involving Automation, and AL runtime. This...
Date: 04/08/2009
Cursor Types
One of the changes in Microsoft Dynamics NAV version 5, was to change from primarily making use of...
Date: 02/20/2009
The COPYSTREAM “problem” for Sockets
I must say that since I started working in the integration area of NAV (from within NAV), I got very...
Date: 01/15/2009
The asymmetric stream
Since NAV’s Stream introduction, there has been confusion about when to use READ and when to use...
Date: 10/15/2008
Simple query to check the recent performance history II - now including Query Plan information
One of the queries I use the most, is the pplan-cache query from this post: Simple query to check...
Date: 10/14/2008
Session Monitor for SQL Server 2005
Session Monitor is not a new tool, but it did stop working with SQL Server 2005. So I think that a...
Date: 09/11/2008
How to deploy multiple NAS’es in ADCS
Although this is not related to the ‘core C/Side’, I would discuss about configuring ADCS with...
Date: 07/31/2008
Jobs Update for Microsoft Dynamics NAV 5.0 SP1 is now released.
I am pleased to announce the release of Jobs Update for Microsoft Dynamics NAV 5.0 SP1. This update...
Date: 06/28/2008
Modern NAV/SQL troubleshooting II
Please refer to this post about what I mean with "modern troubleshooting". This post describes...
Date: 06/11/2008
Microsoft Dynamics NAV 5.0 SP1 and SQL Server 2000
Microsoft Dynamics NAV 5.0 SP1 introduces a new way to handle SIFT. Instead of maintaining totals in...
Date: 06/03/2008
NAV and the .Net Garbage Collector
Many NAV solutions, including internal ones, have the necessity to use .Net as a supplement of NAV...
Date: 05/27/2008
What is the cost of maintaining an indexed view?
In previous versions, Microsoft Dynamics NAV maintains SIFT totals in SIFT tables. So updating the...
Date: 05/22/2008
Index View Matching & Dynamics NAV 5.0 SP1
In a recent question we were asked whether it was required to use Dynamics NAV 5.0 SP1 with...
Date: 05/14/2008
Changes to Microsoft Dynamics NAV 5.0 SP1 with Microsoft SQL Server
I just want to point you to the whitepaper describing the changes done for the Microsoft Dynamics...
Date: 05/13/2008
Modern NAV/SQL troubleshooting
This post is the first in a planned series to describe various "modern" methods for troubleshooting...
Date: 05/12/2008
SQLIndex property
In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm...
Date: 04/21/2008
Bulk Inserts in Microsoft Dynamics NAV 5.0 SP1
Bulk Inserts is a new feature in NAV 5.0 SP1 which is designed to improve performance when inserting...
Date: 04/14/2008
My experiences with Microsoft Dynamics NAV 5.0 SP1 …
I spent last week performing a Microsoft Dynamics NAV 5.0 Update 1 to Microsoft Dynamics NAV 5.0 SP1...
Date: 04/04/2008
SQL Pre-processing in Microsoft Dynamics NAV 5.0 SP1
One of the major changes in Microsoft Dynamics NAV version 5 SP1 (in relation to performance on SQL...
Date: 04/03/2008
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...
Date: 03/28/2008
Microsoft Dynamics NAV, SQL Server 2008 and Windows Server 2008
Microsoft Dynamics NAV plans to support Microsoft SQL Server 2008 and Microsoft Windows Server 2008...
Date: 03/05/2008
Index Usage Query
This is a follow up from an earlier blog "Finding Index usage". In that blog, I described a very...
Date: 02/26/2008
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...
Date: 02/20/2008
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...
Date: 02/06/2008
Overview of updates for SQL Server 2005 SP2
This post has the following three purposes: Give awareness that there are updates available for SQL...
Date: 01/11/2008
Simple query to check the recent performance history
The query described in this blog is a variant of a query described in KB 935395 on Partnersource...
Date: 01/04/2008
Job Queue in Microsoft Dynamics NAV 5.0
IntroductionWith Microsoft Dynamics NAV 4.0 we had a job scheduling mechanism available in the...
Date: 12/19/2007
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...
Date: 12/19/2007
Job Queue Example in Microsoft Dynamics NAV 5.0
What if all posting routines in Microsoft Dynamics NAV could be scheduled to a more sufficient time...
Date: 12/18/2007
Finding Index usage
When troubleshooting performance problems, a typical questions is: "which indexes can be disabled on...
Date: 12/10/2007
Overview of Microsoft Dynamics NAV W1 5.0 SP1
I have often been asked about the content of Microsoft Dynamics NAV W1 5.0 SP1.I will here give a...
Date: 11/30/2007
How to use the new Employee Portal with Microsoft Dynamics NAV 4.0 SP3
The Released Employee Portal can also work with NAV 4.0 SP3. If you want to run the new employee...
Date: 10/31/2007
Employee Portal for Microsoft Dynamics NAV 5.0
I am pleased to announce the update of Employee Portal for Microsoft Dynamics NAV 5.0. This update...
Date: 10/26/2007
Platform Roll-up Update for Microsoft Dynamics NAV 5.0
I am pleased to announce that the first platform update is now available for Microsoft Dynamics NAV...
Date: 10/19/2007
Diagnose your SQL Server
I assume that anyone reading this will be very familiar with collecting traces with SQL Server...
Date: 10/19/2007
Unique IDs for ISVs
Problem Statement When you create an add-on solution, you must make sure that the new objects you...
Date: 10/08/2007
Index Hinting in Platform Update for Microsoft Dynamics NAV 4.0 SP3 KB940718
Introduction On SQL Server, you can use index hinting to force the server to use a particular index...
Date: 09/19/2007