How to get earlier versions of the Dynamics NAV development environment to work with TLS 1.2

Some of you have been struggling to get your version of Dynamics NAV to work with a SQL Server database that has implemented the latest version of Transport Layer Security. TLS 1.2 support on SQL Server is explained in more detail in this article. As stated there, several known vulnerabilities have been reported against Secure…

3

SQL Server 2017 and Dynamics NAV

SQL Server 2017 was released in October last year with many new and interesting capabilities. For further information, please take a look at the product information at this location: https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017. 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…


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…


Best practices for installing and configuring Microsoft SQL Server for Microsoft Dynamics NAV

The documentation on Installation Considerations for Microsoft SQL Server and Microsoft Dynamics NAV has been updated with information on recommended settings for SQL Server 2012, 2014, and 2016. The documentation contains recommendations on topics such as Storage and recommended disk block size Virus scanning Memory TempDB database configuration Auto-growth of database and/or transaction log files…


Moving a Dynamics NAV database with file groups to Azure

The short story: If you use SQL Server for your Dynamics NAV database, and if you are using multiple file groups (other than PRIMARY), as per SQL Server recommendations for better IO performance, and if you need to export the database to Azure, then you need to use the latest update (August 2016 update or…

0