I was tasked with the research on fuzzy search possibilities. The goal is to find “similar names” when Customer Service enters a new client into the CRM. Sometimes they misheard…
Category: Database
This small issue occurred during our maintenance of RDS servers recently. I noticed that one of them still uses GP2 General Purpose SSD storage, so I wanted to change 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…
Have you tried to restore the development database when suddenly such an error occurred? In the MS SQL Server with a connection to ColdFusion, this is a common problem. ColdFusion…
Sometimes when I run backup or restore operations on an MS SQL server using a maintenance plan or a simple script, I have no information about the progress. In order…
This one will also be short. We came on this issue today: our code is decrypting some fields in the SQL Server database and as a part of decryption we…
Given that my native language uses some funny chars like ‘ą’ or ‘ć’ and there are multiple chars that are not safe when placed in the URL, from time to…
The Microsoft SQL Server development machine is something that I’m using daily. The operations I perform are much different from the things that I did on the production server. The…
From time to time there is a need to remove a large amount of data from the MS SQL table. By large amounts, I mean that the table contains a…