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…
Why such a code? I’m displaying the history of the database record – in a table, each row is a separate record of the history. The highest row contains current…
AWS CloudFront is a widely-used content delivery network service and as most of Amazon Web Services elements can be configured programmatically in many ways. For beginners, the easiest way leads…