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 [...]

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 [...]

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 [...]