I had to duplicate the DynamoDB table a few times recently. Here is the quick way to do this using CLI (AWS Console). I assumed that you have your AWS…
I have to prepare several Raspberry Pi boards for some of our small projects. We have a bunch of SD cards we can use. I want to determine which one…
Recently, I published a short list of handy queries I’m using on Microsoft SQL Server when performing simple housekeeping tasks. Unfortunately, they are not working on old versions of SQL…
Recently, one of the readers, Derrick, asked such questions in the comments: I have done client/server stuff before but am new to WebSockets, hopefully, I can ask some questions –1)…
From time to time, I have to take a look at the Microsoft SQL Server to check if everything is fine. In some cases, I have some housekeeping to do.…
Consider the following piece of code: The code above produces the following output: Strange, isn’t it? The values which end with “5” should be rounded up! This is a common…
In my previous post, I wrote about the quick way to generate Excel export from the database using Python. This was a simple report, but in fact, I had to…
If you are thinking of a quick way to prepare an Excel report from the data you have in your database, you can use Python. In order to achieve this,…
This issue is related to MySQL (I’m using mysql-connector-python). Surprisingly, when I was changed my query to a stored procedure, my code stopped working. It looked like this: And it…
I’m working on the old code right now and I try to perform some performance adjustments. The majority of work now relies on the identification of weak points and places…