SQL – Page 3 – Pardaan.com

Using SQL Data Sync with Microsoft Dynamics NAV on-premise and Azure SQL Database

In many Microsoft Dynamics NAV implementations we have situations where the NAV database is often “coupled” with a second database for business intelligence processing or other data manipulations/analysis. Often we use this scenario for handling Power BI data warehouses in the cloud (Azure SQL) that work…

29 June 2018

Dynamics NAV & BC Tips & tricks

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): Bron : Dynamics NAV Team…

1 May 2018

Off-topic

Database Replication – Part II

This post is in continuation to my earlier post. Please check if you missed. Database Replication – Part I As committed in this post we will cover practical approach. Bron : KSD Consultancy Lees meer...

15 February 2018

Off-topic

Database Replication – Part I

One of my reader had requested to write post on this topic. I have gone through some posts and prepared a step by step process to demonstrate how we can configure Database Replication in SQL. Bron : KSD Consultancy Lees meer...

14 February 2018

Data & Analysis

Setting SQL Server Connection String Properties In Power BI and SSAS Tabular Modern Data Sources

It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern data source in Azure SSAS/SSAS Tabular 2017: Bron : Chris Webb's BI Blog…

31 January 2018

Dynamics NAV & BC Tips & tricks

SQL Back-up & Management Tips

In my previous posts, I explained the importance of the transaction log in SQL Server and essential concepts you should understand if you are managing SQL backups. In this final post in the series I’ll provide some essential SQL back-up and management tips. Bron : Fenwick…

22 January 2018

Dynamics NAV & BC Tips & tricks

SQL Server 2017 and Dynamics NAV

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 announce that the following Dynamics NAV versions are compatible with the SQL Server 2017 database engine: • Microsoft Dynamics NAV…

15 January 2018