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

  • Screen Dimming After 30 Seconds on Ubuntu 24.04 – Debugging and Fix
  • 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

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

Recent Posts

  • Screen Dimming After 30 Seconds on Ubuntu 24.04 – Debugging and Fix
  • 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

Archives

  • May 2026
  • May 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • July 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • July 2019
  • June 2019
  • April 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018

Categories

  • 3D printing
  • AWS
  • ColdFusion
  • Database
  • ESP8266
  • Javascript
  • Linux
  • Machine Learning
  • nodejs
  • Programming
  • Python
  • SQL
  • Tips
  • Web Development
  • Wordpress
© Copyright 2026 – IT Handyman
Bezel Theme by SimpleFreeThemes ⋅ Powered by WordPress