Skip to content
Dynamics 365 Blog

Using SQL Server Transparent Data Encryption (TDE) with Dynamics NAV 

Over the last few months, the Dynamics NAV team has been testing compatibility with SQL Server Transparent Data Encryption (TDE), and we are now proud to announce that the following Dynamics NAV versions all support SQL Server Transparent Data Encryption (TDE): Microsoft Dynamics NAV 2018 Microsoft Dynamics NAV 2017 Microsoft Dynamics NAV 2016 Microsoft Dynamics...

Read more

Troubleshooting SQL Queries Generated by Dynamics NAV 

The documentation on Optimizing SQL Server Performance with Microsoft Dynamics NAV has been updated with information about: Troubleshooting long running SQL queries involving FlowFields by disabling SmartSQL. Using SQL Server 2016 Query Store to monitor query performance in Dynamics NAV.   Read more at https://msdn.microsoft.com/en-us/dynamics-nav/optimizing-sql-server-performance-with-microsoft-dynamics-nav   Please get back to us if you miss documentation around...

Read more

How to export a Dynamics NAV database on SQL Server 2016 

If you use SQL Server 2016 for your Dynamics NAV database, and you need to export a database to the .bacpac format, then please make sure that you are running the latest update (August 2016 update or later) of the Microsoft SQL Server Data-Tier Application Framework (DacFx) or SQL Server Management Studio (SSMS). If you...

Read more

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...

Read more

Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0 

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,...

Read more

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...

Read more

How to proactively avoid parameter sniffing step-by-step 

In the following blog post the so called „parameter sniffing“ is explained: http://blogs.msdn.com/b/axinthefield/archive/2014/01/09/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil.aspx The purpose of this blog post is to explain the fix implementation steps a little more in detail: Notes: The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I’d...

Read more

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