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 multiple records by delaying the physical inserts on the SQL Server. Before this change, inserts happen in the order that the C/AL code is running. With Bulk Insert, the NAV-client delays the actual inserts until the last…

0

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 database conversion for a customer.  The process went very smoothly and the customer was very excited about the increase in performance we were able to achieve.  Just as an illustration of our success, the customer ships hundreds…

0

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 Server), is a new way to send queries to SQL Server. In previous versions of NAV, we some times saw SQL Server 2005 optimizing query plans for extreme parameter-values, which – when re-used from cache for queries…

0

Sample of how to read a simple XML document using MSXML DOM in NAV

This is a follow-up to the post “how to write a simple XML document”. The other post conitains a few more background details which I won’t repeat here. So even if you only want to read XML Documents, then you may want to have a look there anyway. But let’s get straight to the point. This…

7

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. The purpose of this post is to show…

0

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.0 SP1 General information:https://mbs.microsoft.com/partnersource/products/navision/newsevents/news/50sp1.htm Microsoft Dynamics NAV 5.0…

0

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. The query does have…

0

What is SEPA?

We get a couple of questions asked quite regularly: “How can I make my ERP system SEPA compliant” and a more basic one “What is SEPA? And how does this affect my daily work?” With this blog entry I’ll try to answer these questions. SEPA is short for Single European Payment Area – which is…

1

Bio – Rikke Lassen

Rikke Lassen is a program manager working in the Microsoft Dynamics NAV team. She has been with the NAV Application team since 2004 with a main focus on Office Integration.  Her areas of responsibility are also to look at features within integration in general such as BizTalk, Web Services and Business Notification etc. from an…

0

Bio – Dan Brown

Dan Brown is the General Manager for Microsoft Dynamics NAV. Dan has been with Microsoft since 2002, working on the Microsoft Business Framework, Project Fenway, and Dynamics AX.  Before joining Microsoft, Dan ran the R&D group for a Silicon Valley start-up called Bistro that built workflow-based business applications (including financials management) for small-to-medium sized businesses.  The rest…

0