Knowledge Base · 57 articles · since 2017

We build digital products with AI. And we write about what works.

Field notes from HAVIT — digital products, AI agents and the technology underneath. No marketing, real project examples.

Latest October 2018

8 Oct 2018

Redux: reducing boilerplate

There’s no doubt Redux is pretty verbose. Don’t get me wrong, I know there is a good reason for that, but the price is still quite high. Fortunately,…

26 Sep 2018

SQL: Index statistics update date

Simple query can help you get basic insights on when the index statistics where updated: [code lang=”sql” light=”true”] SELECT o.name AS TableName, i.name AS IndexName, STATS_DATE(i.object_id, i.index_id) AS…

4 Sep 2018

SQL LocalDB: Upgrade to 2017 (14.0.1000)

For me it was quite confusing to find the 2017 version of LocalDB and it is not a streamline process to upgrade your local default instance. The link…

3 Sep 2018

Word: Replace hyphens with non-breaking ones

Word has a non-breaking hyphen (Ctrl+Shift+-). If you use it in a word, it does not break the line (in opposite to the regular hyphen). If you want…

31 Jul 2018

Azure App Service scheduled restart

If you want to restart your App Service on a scheduled basis, you can do that using simple PowerShell: [code lang=”powershell” light=”true”] Stop-AzureRmWebApp -Name ‘_App Service Name_’ -ResourceGroupName…

25 Apr 2018

Office365/Exchange: Remote Server returned ‘532 5.3.2 STOREDRV.Deliver; Missing or bad mailbox Database property’

We have a mail-enabled public folder called Accounting which has an auto-generated e-mail address Accounting@havit.onmicrosoft.com. We use this folder to archive all the accounting-related communication (e.g. by Bcc/Cc-ing all e-mails to Accounting@havit.onmicrosoft.com). A…

26 Mar 2018

Managing your Microsoft Account-owned Azure Subscription with your Organizational Account (AAD)

There might be a situation where you have an existing Azure Subscription associated with your Microsoft Account, you want to manage the subscription using your Organizational Account(s) (Azure…

22 Mar 2018

iTunes – high CPU usage on Windows

My iTunes (currently 12.7.3.46) consumes ~25-30% CPU whenever I listen to any music. The only trick I found to resolve this is to switch it to the “Miniplayer…

17 Mar 2018 Talk

Cloud Application Development – 04 Azure Storage, Blobs, Queues [MFF UK NSWI152, LS 2018]

Recording from the fourth lesson (13/Mar 2018) of Cloud Applications Development course (NSWI152) for MMF UK (LS 2017/2018). It is published on our HAVIT YouTube Channel. Topics covered: Azure…

6 Mar 2018

How to change the password for your SendGrid account created from Azure

Short Story Currently the only way is to use the forgot password feature on the SendGrid login page. The reset-password link is delivered to the mailbox associated with your…