IT Handyman

Because sometimes you need a little help…

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

Tag: SQL

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 replication status alerts with bash script
  • Linux

MySQL replication status alerts with bash script

  • Posted on 2018-10-052019-12-24
  • by dulare

In theory, MySQL replication should work without problems even if the servers are restarted, databases created and removed, data flowing in and out… Sometimes, however, there are errors that are…

Read More
SQL Server on Amazon RDS – unable to bring database online
  • Programming

SQL Server on Amazon RDS – unable to bring database online

  • Posted on 2018-09-072019-12-24
  • by dulare

This article will be short. Recently we had an issue trying to restore the database to the Amazon RDS version of the SQL Server. Long story short, we ended up…

Read More
Counting unique domains from email address field
  • Programming

Counting unique domains from email address field

  • Posted on 2018-03-272019-12-24
  • by dulare

I would like to perform some basic checks for email addresses my users are entering. Sometimes they are simply making a typo in the domain part of the email. Typically…

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