How Do I Set Up Microsoft Dynamics NAV to work with Azure SQL Database

Dynamics NAV 2016 supports the option of using Azure SQL Database, and we have recorded a “How Do I” video to explain the steps involved in deploying a Dynamics NAV SQL Server database to an instance of Azure SQL Database. This blog post includes a Windows PowerShell script that can be used to configure the Dynamics… Read more

SQL Server Worker Threads and Microsoft Dynamics NAV

Microsoft Dynamics NAV has been configured to use the Microsoft SQL Server database engine as efficiently as possible. This includes using SQL queries which are appropriate for parallel query execution to speed up the retrieval of data when the SQL Server is configured to allow this. Parallelism in SQL Server can be controlled using the… Read more

Watch Out for Zombies When Using Microsoft Dynamics NAV with “xact abort” Enabled

If you have turned on the xact abort connection setting option for the Microsoft Dynamics NAV SQL Server instance, then you should watch out for Zombies. With this option turned on, users of your solution risk seeing an error stating This SqlTransaction has completed; it is no longer usable along with a crash signature which includes a… Read more

Compatibility with SQL Server 2014

SQL Server 2014 released earlier this year with many new and interesting capabilities. For further information, please take a look at the product information at this location: Over the last few months, the Microsoft Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to… Read more

Synchronize metadata, please…

One of new procedures/functions we have in NAV 2013 R2 is “metadata synchronization”. It is process when object (table) description done in C\SIDE by NAV developer is applied to SQL object (object structure in SQL becomes the same as we have in NAV object designer). It is described at Unfortunately synchronization step is not… Read more

Working with SQL Server through .NET Interop

The Upgrade Toolkit objects that shipped with Microsoft Dynamics NAV 2013 have a good example of code that works directly with SQL Server through the .NET Framework library. On the product media, navigate to this location: ..\UpgradeToolKit\Data Conversion Tools\601\ Import the Upgrade 601700.2.fob file. This contains codeunit 104050 Upgrade – SQL Mgt.: and codeunit 104049… Read more

Technical videos for Microsoft Dynamics NAV 2013

The Microsoft Dynamics NAV support team have posted videos on YouTube that illustrate various aspects of deployment and configuration of Microsoft Dynamics NAV 2013, including tips for how to extend the core product. You can share the videos with other partners, and with your customers – they are the same videos that our internal supporters… Read more

Manually restoring the NAV 2013 Demo Database

With the release of Microsoft Dynamics NAV 2013, there are some new procedures for restoring the demo database manually.  I have outlined the necessary steps below. 1)    From within the Microsoft SQL Server Management Studio, restore the Microsoft Dynamics NAV 2013 demo database from the installation media (..\SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\70\Database). 2)    To restore the database from… Read more

Example of How to use SQL Tracing Feature to Profile AL Code

Enabling Tracing in Microsoft Dynamics NAV 2013 Microsoft Dynamics NAV 2013 has a feature that allows you to see the AL call stack for a SQL commands. Here I am going to describe how it can be used to profile your application code. There are multiple steps required to start tracing. First, you need to start… Read more

Compatibility Update with Microsoft SQL Server 2012

Microsoft SQL Server 2012 was released in March with many new and interesting capabilities. For further information, please take a look at the product information at Microsoft SQL Server.   Over the last few months the Microsoft Dynamics NAV product team has been testing the compatibility and we are now proud to announce that Microsoft… Read more