SQL – Page 5 – Pardaan.com

Use docker-compose to create a NAV and SQL environment with one command

As I wrote in the previous post thanks to Jakub Vaňák it is now possible to create a new Windows/Docker container image with just one command. Jakub kept working on it and now it is also possible to create (or start) a full environment with 1…

9 March 2017

Dynamics NAV & BC Tips & tricks

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. Bron : Dynamics NAV Team Blog Lees meer...

8 March 2017

Dynamics NAV & BC Tips & tricks

Jet Reports and SQL Azure

Get more insights out of your reporting by connecting Jet Reports to SQL Azure. Bron : ArcherPoint Lees meer...

27 February 2017

Dynamics NAV & BC Tips & tricks

Dynamics NAV: Get SQL Server Name for current installation

I recently wrote a little blog on how to determine, if the current installation is a multitenant installation. There are a few more useful things that you can do with the DLLS that are shipped with Dynamics NAV. Bron : Peter's Blog/a> Lees meer...

24 February 2017

Data & Analysis

Power BI reports in SQL Server Reporting Services

Somewhere in mid 2017 Microsoft will release a new version of SQL Server in which we will have an integration with Power BI. This means we will (I hope) be able to use SSRS as an on premise solution to host Power BI reports, as you…

3 January 2017

Dynamics NAV & BC Tips & tricks

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…

20 December 2016

Dynamics NAV & BC Tips & tricks

SQL view – NAV

I just experienced a case where Client want to see a common list Page in NAV where he can see a data which is basically a combination of multiple Tables. Though it’s achievable in NAV but you need to write a bulky code on the page…

7 December 2016