We encountered this issue when moving the database from the old server to the new one. Everything looked fine, there was access to tables (select, insert, update, delete) but when…
Category: SQL
You may encounter this error in ColdFusion when working with MySQL. It is rather strange: First, let’s talk about the solution. This error occurs due to the MySQL Connector version…
If you still happen to use ColdFusion 2016 and you want to connect it to MySQL 8 (or MariaDB 10), you will receive the following error: It is not telling…
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…
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.…
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…
A few days ago, we created a new server instance with MS SQL Server 2019 installed. The main authorization method during the days of the server configuration and preparation was…
When you are managing multiple SQL servers, it is handy to have the ability to give access to the SQL Server databases by using Active Directory users or groups. Of…
What do I calculate the hash of multiple columns for? I’m working with API that is limiting the number of calls per hour. I don’t want to send the same…
Are you familiar with Common Table Expressions (CTE)? Common Table Expressions are widely used to simplify queries, make them more readable and maintainable. For instance, when I want to check…