Category Archives: tech pit

everything related to technical stuff

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 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 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 »

HOWTO Set System Unattended Timeouts

I was in the need to change System Unattended Sleep Timeout. It’s the time the system shall wait before switching the sleep mode when it’s into login or locked page. According to this thread, it something we can do by the Advanced Power Options. The problem is that it’s hidden by default. Enabling System Unattended Sleep Timeout To switch it back to the light, we … Continue reading HOWTO Set System Unattended Timeouts »

Updating Drivers for WU Catalog manually

Starting with Windows 10 Cumulative Update 1904, my notebook started a quite alarming series of BSOD. One of the many activities to solve the problem was to update vital drivers to the latest working version. One good source is ‘Windows Update Catalog’ site. From here you can download any content distributed by Windows Update itself. One of these contents are latest registered device drivers. In … Continue reading Updating Drivers for WU Catalog manually »

HOWTO install Windows features on-demand

Start with Windows 10 1809, I discovered that RSAT (Remote Server Adminitration Toolkit) was inserted into Windows ‘Features on Demand’ and can be only install from there. To complete to the task: open a Command Prompt with administrative access rights type the following command line to get all features available: dism /online /get-capabitities select the needed ones (the ones starting with “rsat” in your case) … Continue reading HOWTO install Windows features on-demand »

Forcing Windows XP multicore detection

Recently I had to resume a Windows XP Virtualbox VM, to do some tests. I have added some RAM and CPUs (from 1 to 2) to the VM, but the added CPUs aren’t detected.   After some internet surfing, I found the solution. To force the detection, open the Command Prompt and type the following line: rundll32 syssetup,SetupInfObjectInstallAction ACPIAPIC_MP_HAL 128 %windir%\inf\hal.inf After a couple (in … Continue reading Forcing Windows XP multicore detection »