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...
Author: mniel 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...
Author: Soren Groes-Petersen 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...
Author: Jorge Alberto Torres [MSFT] 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...
Author: Jorge Alberto Torres [MSFT] Date: 08/06/2009
SPN name Changes
It should be a common installation scenario to have NAV 2009 components installed on three different...
Author: Jorge Alberto Torres [MSFT] 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...
Author: scalin Date: 05/14/2009
An almost exact decimal
Recently I was working with a very interesting case, involving Automation, and AL runtime. This...
Author: Jorge Alberto Torres [MSFT] Date: 04/08/2009
Cursor Types
One of the changes in Microsoft Dynamics NAV version 5, was to change from primarily making use of...
Author: Lars Lohndorf-Larsen 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...
Author: Jorge Alberto Torres [MSFT] 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...
Author: Jorge Alberto Torres [MSFT] 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...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: Jorge Alberto Torres [MSFT] 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...
Author: Mtoo Norrild Date: 06/28/2008
Modern NAV/SQL troubleshooting II
Please refer to this post about what I mean with "modern troubleshooting". This post describes...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: Jorge Alberto Torres [MSFT] 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...
Author: Lars Lohndorf-Larsen 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...
Author: mniel 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...
Author: mniel Date: 05/13/2008
Modern NAV/SQL troubleshooting
This post is the first in a planned series to describe various "modern" methods for troubleshooting...
Author: Lars Lohndorf-Larsen Date: 05/12/2008
SQLIndex property
In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: rmiller 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...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: mniel 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...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: Lars Lohndorf-Larsen 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...
Author: mniel 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...
Author: mniel 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...
Author: mniel Date: 12/18/2007
Finding Index usage
When troubleshooting performance problems, a typical questions is: "which indexes can be disabled on...
Author: Lars Lohndorf-Larsen 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...
Author: mniel 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...
Author: Mtoo Norrild 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...
Author: Mtoo Norrild 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...
Author: mniel Date: 10/19/2007
Diagnose your SQL Server
I assume that anyone reading this will be very familiar with collecting traces with SQL Server...
Author: Lars Lohndorf-Larsen 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...
Author: mniel 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...
Author: mniel Date: 09/19/2007