• Skip to main content
  • Skip to primary sidebar

Technical Notes Of
Ehi Kioya

Technical Notes Of Ehi Kioya

  • Blog
  • Shop
  • Forums
  • Subscribe
  • About
  • Contact
MENUMENU
  • Blog Home
  • AWS, Azure, Cloud
  • Backend (Server-Side)
  • Frontend (Client-Side)
  • SharePoint
  • Tools & Resources
    • CM/IN Ruler
    • URL Decoder
    • Text Hasher
  • Linux & Servers
  • Zero Code Tech
  • WordPress
  • Musings
  • More
    Categories
    • Cloud
    • Server-Side
    • Front-End
    • SharePoint
    • Tools
    • Linux
    • Zero Code
    • WordPress
    • Musings

Database

 

Weird Characters In WordPress? Here’s How To Clean Them Up

May 23, 2019 by Ehi Kioya 1 Comment

Weird Characters In WordPress

If you do WordPress site migrations often, you will at some point encounter the problem of weird characters (like “ and ”) appearing in your WordPress content. This article explains why this may happen and how to fix the problem.

Filed Under: Backend (Server-Side), Database, Web Development, WordPress Tagged With: Database, SQL, Web Development, WordPress

Different Ways To Change The WordPress “siteurl” And “home” Links

April 5, 2019 by Ehi Kioya Leave a Comment

Different Ways To Change The WordPress siteurl And home Links

Once in a while, you may need to manually change your WordPress siteurl and home links (e.g. when you’re migrating your entire website to a new domain). If not done right, your site may malfunction. Here are the different proper ways to do this.

Filed Under: Backend (Server-Side), Database, PHP, Programming, Web Development, WordPress Tagged With: Database, PHP, SQL, WordPress

 

Understanding Conceptual, Logical, and Physical Database Modeling

March 3, 2019 by Ehi Kioya Leave a Comment

Understanding Conceptual, Logical, And Physical Database Modeling

Database Modeling is an important part of the software development process. What is a Database Model? What are Conceptual, Logical and Physical Database Models, and how do they differ? I provide a detailed but high-level overview in this article.

Filed Under: Database, Musings, Zero Code Tech Tagged With: Data Modeling, Database, Database Modeling, Modeling

“Hacking” A WordPress Password

September 6, 2018 by Ehi Kioya Leave a Comment

Hacking A WordPress Password

Locked out of your WordPress website? No worries. This article explains how a server administrator can either force reset a user’s WordPress password or create a new WordPress admin user with a brand new password. Database and FTP methods are described.

Filed Under: Backend (Server-Side), Database, Programming, WordPress Tagged With: Database, MySQL, Password, PHP, Programming, WordPress

 

Connect To Amazon RDS (Or Any Database) Using HeidiSQL Via SSH Tunneling

July 15, 2018 by Ehi Kioya 2 Comments

HeidiSQL SSH Tunneling

Connecting to databases via SSH Tunneling is something developers and IT professionals often need to do. And HeidiSQL is one of the more popular open-source database tools. While HeidiSQL fully supports SSH tunneling, there doesn’t seem to be any documentation about how to accomplish this. So, after struggling with this for a few hours and figuring it out, I put these instructions together to help others.

Filed Under: AWS, Azure, Cloud, Cloud Computing, Database, Linux & Servers Tagged With: Amazon RDS, Cloud Computing, Database, HeidiSQL, Linux, SSH Tunneling

Protect SQL Statements From Accidental Update/Delete

March 11, 2013 by Ehi Kioya 4 Comments

Protect SQL Statements

The designers of SQL for some reason did not require a keyword (like “ALL”) to protect SQL statements from accidental updates or deletes. Especially when the UPDATE or DELETE statement doesn’t contain a WHERE clause. I wonder if this was deliberate or if it was an oversight. In any case, the programmer becomes “all-powerful”. The significance of this problem will be better appreciated with an example…

Filed Under: Backend (Server-Side), Database Tagged With: Database, SQL

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

426,009
Followers
Follow
30,000
Connections
Connect
15,217
Page Fans
Like

FROM   THE   SHOP

  • Retro Brick Cell Phone

    Retro Brick Cell Phone
    Rate this product:

    “Upgrade” to this Retro Brick Cell Phone and quit having to worry about battery life. Inspired by old school brick phones, this fully functional device features a massive 9800mAh battery that can last for one whole month before needing a recharge!

    $61.95 (as of Dec 5, 2019 - 3:50 pm) Check it out
  • Recently   Popular   Posts   &   Pages
  • Allowing Multiple RDP Sessions In Windows 10 Using The RDP Wrapper Library Allowing Multiple RDP Sessions In Windows 10 Using The RDP Wrapper Library
    This article explains how to bypass the single user remote desktop connection restriction on Windows 10 by using the RDP wrapper library.
  • Actual Size Online Ruler Actual Size Online Ruler
    I created this page to measure your screen resolution and produce an online ruler of actual size. It's powered with JavaScript and HTML5.
  • Get XML Document Nodes Recursively with C# Get XML Document Nodes Recursively with C#
    Here are two methods to get XML document nodes, child nodes and so on. The first method uses DOM. The second method uses LINQ to XML.
  • WordPress Password Hash Generator WordPress Password Hash Generator
    With this WordPress Password Hash Generator, you can convert a password to its hash, and then set a new password directly in the database.
  • How To Shrink Amazon EBS Volumes (Root Or Non-Root) How To Shrink Amazon EBS Volumes (Root Or Non-Root)
    In this article, I describe a technique to shrink Amazon EBS volumes. This is very useful if you ever mistakenly over-allocate your EBS.

FROM   BLOG   READERS…

  • Dominic Desbiens on How To Shrink Amazon EBS Volumes (Root Or Non-Root)Hi, I'm new on self web hosting (learning more about Linux and self hosting on Amazon). I have created too big volume on my first real « production »…
  • Charles on How to Set Up Goals in Google AnalyticsI should consider using it. Thanks.
  • Alan Bombria on Forcefully Clear Jobs from the Print Queue or SpoolerMy batch file: net stop spooler del /F /Q %systemroot%System32spoolPRINTERS* net start spooler
  • Jesse Alama on Sorting Date And Time In XSLNice! It is indeed frustrating at times to work just with XSLT 1.0. Even if one has XSLT 2.0 or 3.0 available, one might have to use this kind of solu…
  • Howard Bash on Setting up a SharePoint 2016 dev farm in Azure – Part 4: SharePoint 2016 InstallationYes. I appreciate your help on this. Thanks! I'll double check. I connected to the sqlVM using SP. I'll try the other two now.
  • Alexey on Backup SQL Server Database To Dropbox in C#Hi Ehikioya, It's a really nice offer. Thank you for the info! Regards, Alexey.
  • Chinoms on 5 Old Web Development Trends That You Should Remove from Your SiteFlash is dead! I wanted to learn it, but after reading up Job's Notes on Flash, I decided to never think of learning flash. HTML5, JavaScript and CSS3…
  • Go to page 1
  • Go to page 2
  • Go to Next Page »
  • Blog
  • Shop
  • Forums
  • Subscribe
  • About
  • Contact

© 2019   ·   Ehi Kioya   ·   All Rights Reserved
Privacy Policy