Dynamics NAV RTC – Page Slow to Load – Flowfields

With Microsoft Dynamics Nav, it is possible to add a “FlowField” to a table. This flow field is then calculates an aggregate of an underlying table. Typical uses are to perform the following calculations: Sum Average Min Max Count Additionally, the following non-aggregate functions are available: Lookup Exists Typical values…

Magento Order Status Flow

With Magento, the order status flow can be quite confusing. The following diagram from MBS is useful in understanding the status flow: It’s worth noting the following too: An order can be “held” from any state/status in Magento When “Unholded”, it goes back to the previous state/status Once an order…

Estimate Completion Time For Long Running SQL Query

With Microsoft SQL Server, sometimes there can be long running SQL Queries which you would like to get an estimated ETA from. Tim Ford has wrote a brilliant article which will provide an ETA for the following types of queries: Database Backup BACKUP Database Restore RESTORE Index Reorganisation DBREINDEX DBCC…

Using STUN with Aastra SIP Phones on 3CX Phone System

The 3CX phone system no longer supports Aastra Phones. Luckily templates are still available which allow connection over the local network, but unfortunately these do not work for remote networks which need to utilise STUN. Details on Aastra support for 3CX is available here. STUN is a technology which is…

Azure AD Connect – Force Sync Via Command Line

Azure AD connect is a new tool which replaces DirSync for syncing Active Directory information to Azure from the local active directory. Synchronisation automatically works in the background, but sometimes you want to push through a synchronisation for some reason or another (rather than waiting for the next time it…