IT Handyman

Because sometimes you need a little help…

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

Tag: databases

Getting rid of SQL Server long-running queries
  • Database

Getting rid of SQL Server long-running queries

  • Posted on 2020-10-072020-10-30
  • by dulare

There are situations when the SQL server is getting wild – mostly because of our own actions or poorly written queries. From time to time we notice that the SQL…

Read More
Property Owner is not available for Database
  • Database

Property Owner is not available for Database

  • Posted on 2020-09-022020-09-29
  • by dulare

I noticed a strange error recently. When trying to access the properties of the MS SQL database using the Microsoft SQL Server Management Studio, I received this error: “Cannot show…

Read More
MySQL date and time shift on a query
  • ColdFusion

MySQL date and time shift on a query

  • Posted on 2020-02-112020-02-11
  • by dulare

We noticed a strange issue when working with MySQL in ColdFusion. The date and time in the database field were set to ‘2020-01-10 00:38’ but when it reached our web…

Read More
How to truncate table in SQLite and shrink the database
  • Programming

How to truncate table in SQLite and shrink the database

  • Posted on 2020-02-052020-02-05
  • by dulare

For my pet projects, I’m using SQLite a lot. The database engine is fast, small and serves well for small amounts of data. What is most important for me –…

Read More

Posts pagination

Previous Page Page 1 Page 2

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