HOWTO limit MS SQL Server memory usage

Go to Microsoft web site and download MS SQL Server Management Studio (SSMS for ‘friends’), about 0.5Gb to download and 1Gb of disk space. It is working with almost any MS SQL Server version and edition. Once installed you have to: start the program with administrative access rights elevation connect to the service right click on root item into Object Explorer, select Properties select Memory … Continue reading HOWTO limit MS SQL Server memory usage »

HOWTO add encrypted disks to your PC

Imagine to be a contractor, and you want a secure blackbox to keep your customer data on your PC. This will come very useful, for example, in case of loss or theft of your notebook. A common approach is to encrypt the whole hard disk, but it has two main drawbacks: the whole system is slowed down by the disk encryption. usually it’s almost impossible … Continue reading HOWTO add encrypted disks to your PC »

HOWTO enforce WindowsXP security

There are dozens of reasons to abandon Windows XP (security, technical, …), but if you have no option, at least you can mitigate them by enabling the PosReady option and install all MS published security updates. Open Registry Editor and go to: HKLM\System\WPA\PosReady the add/edit the value ‘Install‘ as DWORD and set it to 1. Reboot, and run Windows Update by the following command line: … Continue reading HOWTO enforce WindowsXP security »

HOWTO quickly set Safe Mode into Windows 10

Setting safe mode to the next reboot has become quite tricky. Usually you have to navigate among one-way system options (reset, restore, …). Recently I discovered that you can easily trigger it from Command Prompt with administrator access rights. Type the following command: bcdedit /set safeboot minimal and reboot. The system will reboot in safe mode as requested this time only. If it will not … Continue reading HOWTO quickly set Safe Mode into Windows 10 »

HOWTO Make Windows SlimRW Lock More Confortable

Recently I tripped into SlimRW Lock API. It’s a Windows synchronization object very similar to critical section, with the support of two different type of lock: shared and exclusive. Essentially you should get shared lock for all read-only activities, while the exclusive lock shall be used for all the other cases. The Basic Implementation I wrote this simple class to include them in my program: … Continue reading HOWTO Make Windows SlimRW Lock More Confortable »

HOWTO Setup Hyper-V 2019 Server Outside a Domain

Hyper-V 2019 Server might be a great and free opportunity to host Hyper-V VMs. The main problem is that it’s quite unfriendly & raw environment not set to live outside a network domain. Setting up a domains server for small labs, or similar realities can be quite expensive and not advantageous. Surfing the web, I found several sources to use it into a private network … Continue reading HOWTO Setup Hyper-V 2019 Server Outside a Domain »

HOWTO Automatically Catch Problems While Debugging

Suppose to have the ability to add dozens of breakpoints into your program main error detection points, whenever you start a debugging session. This should allow you to easily track down some hidden/unnoticed problem. For example, suppose to have a C function like the below one: __MYOBJECTDATA * WINAPI MYOBJGetPtr (HANDLE hMyObject) { __MYOBJECTDATA *pObj; pObj = (__MYOBJECTDATA *) hMyObject; __try { if ((pObj != … Continue reading HOWTO Automatically Catch Problems While Debugging »

HOWTO fix Event 455 ESENT

Into my new Windows 10 1903, I noticed several instances of the following error: Event 455, ESENT with the following description: svchost (3124,R,98) TILEREPOSITORYS-1-5-18: Error -1023 (0xfffffc01) occurred while opening logfile C:\WINDOWS\system32\config\systemprofile\AppData\Local\TileDataLayer\Database\EDB.log. The solution The problem here seems to be that a couple of folders are missing int this path. To fix them, you have to: open Explorer go to: C:\Windows\System32\config\systemprofile\AppData\Local create ‘TileDataLayer‘ folder (if … Continue reading HOWTO fix Event 455 ESENT »