Database deadlock detection and monitoring in Dynamics NAV 2017

Sometimes a programming error in C/AL can lead to users experiencing errors due to database deadlocks. A database deadlock can occur when two sessions try to update the same data, and are acquiring database locks in different orders. For example, let’s imagine two code units 10001 and 10002, which both do updates to records in…

4

SQL Server 2016 and Dynamics NAV

SQL Server 2016 released in June this year with many new and interesting capabilities. For further information, please take a look at the product information at this location: https://www.microsoft.com/en-us/cloud-platform/sql-server Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to…

4

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…

4

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…

9

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…

2

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: http://www.microsoft.com/en-us/server-cloud/products/sql-server/default.aspx. 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…

26

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 http://blogs.msdn.com/b/nav/archive/2014/03/27/table-synchronization-paradigm-in-microsoft-dynamics-nav-2013-r2.aspx Unfortunately synchronization step is not mentioned in…

6

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…

2

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…

0

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…