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.
Database
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.
“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.
Connect To Amazon RDS (Or Any Database) Using HeidiSQL Via 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.
Protect SQL Statements From Accidental Update/Delete
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…
Backup SQL Server Database To Dropbox in C#
SQL Server 2008 allows for the creation of local backups. However, these backups must really be “local” in the sense that they can only be created on the machine where the SQL Server instance is installed. The whole idea behind database backups is about keeping a copy of data in case of Server failure or some other problem. So storing the backed up data on the same machine is definitely not a good idea.