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

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

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

Next>