SQL – Pardaan.com

ELI5 Filters in AL are very different from SQL

Quite often, I get questions about “filters” in AL, enough different questions to warrant an ELI5 video on filters. Check it out if you’re still learning about filters in AL. Source : Hougaard.com Read more...

10 July 2024

Dynamics NAV & BC Tips & tricks

Business Central Onpremise – Create SQL Missing Indexes from AL

Through the page 9521 Database Missing Indexes it is possible to see the missing indexes suggested by SQL Server for Business Central (in fact, an SQL function is called which returns the missing indexes). In this case the same function has been recreated on SQL (stored…

16 August 2023

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: Get the amount of SQL rows read and the amount of SQL statements executed on the session via AL – SessionInformation Data Type

Today I want to share a mini tip about Business Central. How to get the amount of SQL rows read and the amount of SQL statements executed on the session via AL. As you might, As of Business Central April 2019, the AL debugger also offers…

1 March 2023

Off-topic

SQL – Search for special characters

Sometimes it may happen that by importing data from external sources (even with Web Services), some special characters are written and then uploaded to NAV \ Business Central. These characters (even if accepted) could then give problems to searches, XML exports, blocking the sending of documents.…

4 October 2022

Dynamics NAV & BC Tips & tricks

Use a Query Object if you have an urge for SQL in Business Central

The Query Object is often overlooked in Business Central, but it does give SQL’ish access to creating queries, check it out: Source : Hougaard.com Read more...

25 August 2022

Off-topic

Export SQL data to CSV or XML File via Powershell

Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands…

3 May 2022

Dynamics NAV & BC Tips & tricks

AL is not SQL (and Business Central is not a “SQL Application”)

Recently I have had several conversations about SQL vs AL. Lots of new talent is coming into the channel, often with SQL knowledge, but how to apply that in an AL-driven world? In this video, I discuss AL vs SQL: Source : Hougaard.com Read more...

17 December 2021