IT Handyman

Because sometimes you need a little help…

Menu
Skip to content
  • Home
  • About / Contact information
  • Dulare uses…

Tag: databases

Fuzzy search testing – using PostgreSQL compared to Qdrant vector database
  • Database

Fuzzy search testing – using PostgreSQL compared to Qdrant vector database

  • Posted on 2023-05-262023-05-26
  • by dulare

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…

Read More
AWS RDS unable to modify Storage Type
  • AWS

AWS RDS unable to modify Storage Type

  • Posted on 2022-11-092022-11-10
  • by dulare

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…

Read More
SQL Server: unable to log in as a newly created user
  • Database

SQL Server: unable to log in as a newly created user

  • Posted on 2021-11-032021-11-10
  • by dulare

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…

Read More
Access to SQL Server for Active Directory users and groups
  • Database

Access to SQL Server for Active Directory users and groups

  • Posted on 2021-10-272021-11-04
  • by dulare

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…

Read More
Closing all connections to the database
  • Database

Closing all connections to the database

  • Posted on 2021-09-012021-10-21
  • by dulare

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…

Read More
Check SQL Server backup and restore progress
  • Database

Check SQL Server backup and restore progress

  • Posted on 2021-06-092021-06-29
  • by dulare

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…

Read More
SQL Server string truncation on Convert and Cast
  • Database

SQL Server string truncation on Convert and Cast

  • Posted on 2021-04-282021-05-12
  • by dulare

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…

Read More
Create a URL-safe string in MySQL
  • Database

Create a URL-safe string in MySQL

  • Posted on 2020-12-022020-12-26
  • by dulare

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…

Read More
Why not use AWS RDS to create SQL Server Development
  • AWS

Why not use AWS RDS to create SQL Server Development

  • Posted on 2020-11-112020-12-07
  • by dulare

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…

Read More
Deleting a large amount of data from the MS SQL table
  • Database

Deleting a large amount of data from the MS SQL table

  • Posted on 2020-10-142020-11-04
  • by dulare

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…

Read More

Posts pagination

Page 1 Page 2 Next Page

Recent Posts

  • Sending emails from Docker using Postfix installed on the Host
  • Fuzzy search testing – using PostgreSQL compared to Qdrant vector database
  • OpenAI models fine-tuning considerations
  • Oxygen upgrade issue: Download failed. Unauthorized
  • OxyMade update failed – how to pull the license key from the database

Tags

3D printing administration Apache Arduino AWS ColdFusion databases development EC2 ESP8266 Express FriendlyTracker FTP git Handlebars IIS Infusionsoft IoT Java Javascript Linux Lucee Machine Learning MS SQL Server MySQL Node OpenAI OpenVPN programming Python Qdrant Security Selenium SQL SSL TestBox threads timelapse tips TLS Ubuntu vector database web development Windows WordPress
© Copyright 2025 – IT Handyman
Bezel Theme by SimpleFreeThemes ⋅ Powered by WordPress