IT Handyman

Because sometimes you need a little help…

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

Category: SQL

“Access denied for user” on views only – after MySQL database restore
  • SQL

“Access denied for user” on views only – after MySQL database restore

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

We encountered this issue when moving the database from the old server to the new one. Everything looked fine, there was access to tables (select, insert, update, delete) but when…

Read More
The value class java.time.LocalDateTime cannot be converted to a date
  • ColdFusion

The value class java.time.LocalDateTime cannot be converted to a date

  • Posted on 2022-03-022022-03-03
  • by dulare

You may encounter this error in ColdFusion when working with MySQL. It is rather strange: First, let’s talk about the solution. This error occurs due to the MySQL Connector version…

Read More
Connecting ColdFusion 2016 to MySQL 8
  • ColdFusion

Connecting ColdFusion 2016 to MySQL 8

  • Posted on 2022-02-232022-02-23
  • by dulare

If you still happen to use ColdFusion 2016 and you want to connect it to MySQL 8 (or MariaDB 10), you will receive the following error: It is not telling…

Read More
Still on SQL Server 2000? A couple of handy queries
  • SQL

Still on SQL Server 2000? A couple of handy queries

  • Posted on 2022-01-262022-01-27
  • by dulare

Recently, I published a short list of handy queries I’m using on Microsoft SQL Server when performing simple housekeeping tasks. Unfortunately, they are not working on old versions of SQL…

Read More
A few handy SQL scripts for SQL Server users
  • SQL

A few handy SQL scripts for SQL Server users

  • Posted on 2022-01-122022-01-27
  • by dulare

From time to time, I have to take a look at the Microsoft SQL Server to check if everything is fine. In some cases, I have some housekeeping to do.…

Read More
Don’t use “CALL StoredProcedure()” in Python :)
  • Python

Don’t use “CALL StoredProcedure()” in Python :)

  • Posted on 2021-12-152022-01-19
  • by dulare

This issue is related to MySQL (I’m using mysql-connector-python). Surprisingly, when I was changed my query to a stored procedure, my code stopped working. It looked like this: And 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
Calculate hash of multiple columns in MySQL
  • SQL

Calculate hash of multiple columns in MySQL

  • Posted on 2021-08-042021-09-10
  • by dulare

What do I calculate the hash of multiple columns for? I’m working with API that is limiting the number of calls per hour. I don’t want to send the same…

Read More
Complex updates using CTE in SQL Server
  • SQL

Complex updates using CTE in SQL Server

  • Posted on 2021-07-282021-09-10
  • by dulare

Are you familiar with Common Table Expressions (CTE)? Common Table Expressions are widely used to simplify queries, make them more readable and maintainable. For instance, when I want to check…

Read More

Recent Posts

  • ColdFusion XMLParse: The prefix “” for element “” is not bound.
  • Unable to start AWS Linux instance after instance type change – “a start job is running for…”
  • Disable TLS 1.0, TLS 1.1 and weak certificates on IIS
  • “Access denied for user” on views only – after MySQL database restore
  • The value class java.time.LocalDateTime cannot be converted to a date

Tags

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