I configured DNS on my Windows Server 2016 (takes some time, probably 15 minutes):
ipconfig /registerdns
Inegrating Oracle Database 18 with MS Active Directory
Creating Android application icons
There are the key links to the docs:
At the moment of writing this post application icons were of the following sizes:
(more…)Mining Monero (XMR) with RandomX on Windows 10
Enable huge pages by running gpedit.msc and adding the current user to Local Computer Policy->Computer Configuration->Windows Settings->Security Settings->Local Policies->User Rights Assignment->Lock pages in memory:
and logging out of current Windows session for changes take effect.
(more…)How to buy and sell crypto with RUB on Binance
Binance has Buy and Sell Cryptocurrency page:
and has Russian Ruble (RUB) Fiat Gateway Through Advcash.
(more…)Mining Raven Coin (RVN) with X16Rv2 on HiveOS and Windows 10
HiveOS Web UI has Setup Minder Config button where I selected X16Rv2 algorithm for T-Rex miner:
Accessing a service credentials on Windows 10
I worked on some Windows app that registers a Windows service with a C++ code like this:
SC_HANDLE hService = ::CreateService(
hSCM, m_szServiceName, _T(SERVICE_NAME),
SERVICE_ALL_ACCESS, SERVICE_WIN32_OWN_PROCESS,
SERVICE_AUTO_START, SERVICE_ERROR_NORMAL,
szFilePath, NULL, NULL, _T("RPCSS\0"), user_name, password);
where user_name and password are strings that are provided by the app user during the app install. Assuming the service name is MyService this creates a registry key HKEY_LOCAL_MACHINE\SECURITY\Policy\Secrets\_SC_MyService that is hidden by default and even administrator does not have a permission to read it and regedit does not show the content of HKEY_LOCAL_MACHINE\SECURITY key by default. But fortunately the access can be allowed by right clicking on HKEY_LOCAL_MACHINE\SECURITY and selecting Permissions or alternatively by running
Enable-TSDuplicateToken
in PowerShell. To list the content of the key I used the following command:
dir HKLM:\SECURITY\Policy\Secrets\_SC_MyService
My Android QT app crashes at qt_qFindChild_helper.
I have an Android QT app with more than has 14K active users at the moment of writing this post. The app is relatively stable, its crash rate is 0.34%:
Binding Docker container ports to the host on Ubuntu 18.04 inside Hyper-V on Windows 10
The binding did not work for me until I switched from Internal Virtual Switch to External Virtual Switch and while switching I were getting the following error:
[Window Title]
Virtual Switch Manager for MY-MACHINE
[Main Instruction]
Error applying Virtual Switch Properties changes
[Content]
Failed while adding virtual Ethernet switch connections.
[Expanded Information]
External Ethernet adapter 'Realtek PCIe GBE Family Controller' is already bound to the Microsoft Virtual Switch protocol.
until I switched Hyper-V Extensible Virtual Switch off on my network adapter properties page (after I created External Virtual Switch it switched on back):
(more…)Scanning the disk and testing the memory on Windows 10 PC.
My Windows 10 PC started to glitch a little bit and I scanned its disks with the following commands:
chkdsk C: /f /r /x
The type of the file system is NTFS.
Cannot lock current drive.
Chkdsk cannot run because the volume is in use by another
process. Would you like to schedule this volume to be
checked the next time the system restarts? (Y/N) y
This volume will be checked the next time the system restarts.
Measuring SQLite insertion performance with C++ code
I did a quick Google search on “SQLite performance” and found the following:
- What are the performance characteristics of sqlite with very large database files? (The performance degrades significantly when the database size riches 7GB).
- Some Russian article on habr.com. (To boost the insertion we insert by batches in a separate transactions, set synchronization mode to OFF or NORMAL and probably disable indices).
- Some old article on Database Speed Comparison.
- Appropriate Uses For SQLite (An SQLite database is limited in size to 140 terabytes)
- Faster bulk inserts in sqlite3? (You can also try tweaking a few parameters to get extra speed out of it. Specifically you probably want PRAGMA synchronous = OFF;)
- A trivial C++ example.
Then to benchmark SQLite performance by myself I used the following C++ code that inserts 1000 batches of 1000 000 rows to a single table with an integer primary key:
(more…)