Organizing photo collection – 20 years research

TL;DR If you just want to jump to the solution I found without reading all my 20 years struggles, see the following list. You will need all software from it PhotoStructure AntiDupl.NET Adobe Lightroom Classic CC plugins jb Video Metadata Any Tag Intro Hi folks I would like to tell you about the problem that …

Efficiently debug stored procedure in SSMS

Hi folks. There is question that bothers me for years. Debugging SQL is so tools-unfriendly and time-consuming. I raised a question hoping maybe I am just unaware of some modern techniques. Let’s see what community says. https://stackoverflow.com/questions/59042367/efficiently-debug-stored-procedure-in-ssms Stay tuned.

Windows case-insensitive file names = nightmares with Node.JS

Hi folks! I’ve recently discovered a weird bug when I was trying to test some Node.JS project on Windows It took me hours to figure out the problem. And I would like to share my findings. I will simplify the code avoiding all the unnecessary details. $ cd e:\dev\foo $ .\build.cmd … TypeError: myModule2.myFunction is …

cmd.exe AutoRun feature = evil feature

Hi folks Today I was debugging some issues for hours. Some command-line tools from Node.JS, or C++ compiler just complained with weird errors such as File does not exist when the file clearly existed. I was pulling my hair off and then eventually I found it! cmd.exe has an AutoRun feature. You can add some …

Post SQL output to bug tracker details – Mr. Data Converter

Hi folks Sometimes, you need to copy some output from the SQL query to some bug tracker such as Redmine. I found a neat way to do that using a very neat website https://www.joecullin.com/data_converter/ 1. Execute query in SQL Server Management Studio 2. Click on result grid, Ctrl+A, Ctrl+Shift+C to copy the whole grid details …

Debug .NET IIS Application on Production – dnSpy!

Hi folks! I’ve been recently working on some weird bug that not reproducible locally and had to debug it on Production. Obviously, it does not have Visual Studio installed and I needed something lightweight. I found a very cool tool dnSpy . Latest dnSpy requires .NET Framework 4.7.2 which the production server did not have, …

Open Regedit on a specific key

Hi folks. Sometimes you need to jump to a specific key and it is pretty annoying to navigate to it manually. Related question https://superuser.com/questions/115854/open-registry-directly-to-a-given-key They added an address bar to Windows 10 but for previous versions we need to use a regjump tool I’ve installed it via Chocolatey choco install regjump -y And now I …

Download all of your data from Facebook. I mean ALL OF IT

Hi folks I am going to describe step-by-step how I’ve managed to download all my data from Facebook regardless of what Facebook team wanted… I have zillions of posts, reposts, comments, etc. That’s what I consider to be MY content and I would like to have the easiest access to it possible Chapter 1. Activity …

Integrate Facebook event and Google Calendar

Hi folks I am using Google Calendar to track what I am doing and about to do to avoid collisions. It is pretty annoying to synchronize facebook events with Google Calendar manually but there is a way to automate that However the built-in way is far away from being perfect. Normally you would like to …

Download Google Drive file via AJAX ignoring CORS

Hi folks I have a csv file in Google Drive which I wanted to use from my JavaScript site. If you copy share link from Google Drive you’ll get something like https://drive.google.com/file/d/1_cG2NrtGfuHv_aQGOHWOAZx7wapBlEah/view Which is interactive url. So we need to get a download link It can be done via https://sites.google.com/site/gdocs2direct/ And then we get a …