Category: Uncategorized

Introduction to “Azure with Dynamics NAV” Blog Post Series

Azure with Dynamics NAV blog post series will provide most of the steps, tips and tricks that you will require when work together with Dynamics NAV and Azure.  Azure with Dynamics NAV  blog post series will have following main topic (subjected to change and will update the links as for the progress) 1. Introduction to Azure2. …

Continue reading

How to Transfer Local Computer Files to Azure VMs

Azure is the latest technology trend that is going around in the technical community and many developers have already started and starting to work with Azure. Once the first VM (Virtual Machine) is created, many people start to look for a option to transfer locally stored data and application setups to newly created VM. You …

Continue reading

Cumulative Update 3 for Microsoft Dynamics NAV 2016 has been released (Build 44365)

Cumulative Update 3 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the …

Continue reading

Cumulative Update 34 for Microsoft Dynamics NAV 2013 has been released (Build 44364)

Cumulative Update 34 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the …

Continue reading

Cumulative Update 27 for Microsoft Dynamics NAV 2013 R2 has been released (Build 44366)

Cumulative Update 27 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with …

Continue reading

MVP Surprise Celebration at ZILLIONe

Thank you everyone (Ilamaran, Surath, Iyendra, Upeksha, Ashique,Danushka, Senera, Shehan, Kalpani Chanukah,Oshi Enrico) for organizing the surprise celebration. It was truly a surprise and never expected it! Thank you very much! Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara

TODAY vs WORKDATE

What is the different between TODAY vs WORKDATE ? To find out the difference between the two options I have written a small codeunit and it only contain following two lines. 1: MESSAGE(‘Work Date: %1’,WORKDATE); 2: MESSAGE(‘Today : %1’,TODAY); I first execute the codeunit and it gives me following values as output.  No difference in the values …

Continue reading

Awarded as Microsoft MVP – 2016

Yesterday (01/01/2016) I received an e-mail from Microsoft mentioning I was awarded as  Microsoft MVP for Business Solution Category  (Microsoft Dynamics NAV) It is one of the greatest achievement in my life and I want to thank all the people who helped me to achieve this dream. Thank you very much for all of my blog readers …

Continue reading

Season’s Greetings and Best Wishes for the New Year.

Peace on Earth.  Best wishes for a wonderful holiday season and a new year filled with peace and happiness Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara

Get all the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine

Have seen many of the forum users are posting question on how to find active user sessions in an instance of Microsoft SQL Database Engine.  In order to get the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine, we can use the “sp_who2” SQL stored procedure.  Following is the definition …

Continue reading