IT Handyman

Because sometimes you need a little help…

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

Tag: databases

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
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

Recent Posts

  • Processing HTM and HTML files in ColdFusion 2016
  • ColdFusion on IIS: issues troubleshooting
  • GitHub password access deprecated – switching to Deploy Keys
  • Session not maintained in iFrame
  • Failed to execute ‘send’ on ‘XMLHttpRequest’ – Chrome iFrame ajax issue

Tags

3D printing administration Apache Arduino AWS batch processing ColdFusion databases development DNS EC2 ESP8266 Express FriendlyTracker FTP git gzip Handlebars IIS imageMagick inodes IoT Java Javascript Linux Machine Learning MS SQL Server NextGen Node OpenVPN PHP printing programming Python Security Selenium SQL SSL tar timelapse tips TLS web development Windows WordPress
© Copyright 2021 – IT Handyman
Bezel Theme by SimpleFreeThemes ⋅ Powered by WordPress