SQL – Page 9 – Pardaan.com

What SQL permissions do you need to upload a Dynamics NAV license file?

Whenever you get a new license file from your partner, in order to activate the new license file, you need to upload the license file to your server. However, sometimes, you may get an error when uploading the license file. So far, I have seen two…

21 August 2015

Dynamics NAV & BC Tips & tricks

How to Back Up and Restore a Dynamics NAV 2015 Database Using SQL and PowerShell

Several weeks before our customer’s go-live of Microsoft Dynamics NAV 2015, users were vigorously testing NAV as we were ironing out the specifics of the customer’s desired configurations. During this process, we wanted to start with a clean testing environment (where we wanted to use the…

17 August 2015

Dynamics NAV & BC Tips & tricks

Script Search for a string in “all tables” of SQL Server Database

Good & Fast Script to search for a string in “all tables” of SQL Server Database, very useful with NAV Databases too (to find data FAST in each database\company, no C/AL Code or powershell commands required ) Bron : Roberto Stefanetti NAV Blog Lees meer...

11 August 2015

Dynamics NAV & BC Tips & tricks

Deploying NAV 2016 on Azure SQL on NAVTechDays

I have already wrote about NAV TechDays 2015. By my opinion, this is the best global NAV technical conference. I didn’t introduce you in my session, because in this moment this topic was still by NDA. But now, we heard about it on WPC in Atlanta…

21 July 2015

Dynamics NAV & BC Tips & tricks

SQL Sever reporting services (SSRS) links and NAV demo reports

SQL Sever reporting services (SSRS) links and NAV demo reports: Bron : Roberto Stefanetti NAV Blog Lees meer...

8 July 2015

Dynamics NAV & BC Tips & tricks

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

12 June 2015

Dynamics NAV & BC Tips & tricks

How Do I: Backup Microsoft Dynamics NAV Using the ‘SQL Server Backup to Microsoft Azure’ Tool

This video demonstrates how to backup Microsoft Dynamics NAV using the SQL server backup to Microsoft Azure tool. Bron : Microsoft Dynamics NAV Lees meer...

19 May 2015