Knowledge Base · 57 articles · since 2017
Field notes from HAVIT — digital products, AI agents and the technology underneath. No marketing, real project examples.
You might find a better way, but how about: [code language=”sql” light=”true”] = REPLACE(STR(15, 5, 0), ‘ ‘, ‘0’) [/code] STR(num, length, decimals) function converts the number to…
SOSEX is one of the few existing Windows Debugger extensions for managed code (.NET). It adds a few useful commands to the basic SOS, but its command reference…
Database Management Views and their usage in SQL performance tuning scenarios are well known. There are plenty posts with many different versions of the Most Expensive Queries query.…
By default, your AppServices run in UTC. There is an almost undocumented (or at least very little known) feature of KUDU which allows you forcing a specific time…
In unit-tests you sometimes find yourself in a situation that you need to mock a configuration section. The ConfigurationSection class (or your inherited class) encapsulates nicely and there…
Having only a storage account (CloudBlobClient) and a blob URI makes it a little bit tricky to check if the blob actually exists. To be able to use…
In Resharper there is a well known keyboard shortcut to navigate to next (Alt+Down) or previous (Alt+Up) member in code. In plain Visual Studio (at least in VS2017+)…