This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of a closed wooden box with a red wax seal beside an open basket on a wrapping table

Move a WordPress Site from HTTP to HTTPS: A Complete Tutorial

March 16, 2017
Pinal Dave
Personal
Blogging, Personal Technology, WordPress

Moving a WordPress site from HTTP to HTTPS is seven steps. This tutorial covers the backup, the certificate, the two WordPress addresses, the link replacement, mixed content, the 301 redirect and the follow-up in Search Console and Analytics.

Read More
Title card: WordPress Error: Duplicate Entry for Key PRIMARY

MySQL – Fix Error – WordPress Database Error Duplicate Entry for key PRIMARY for Query INSERT INTO wp_options

September 12, 2016
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Constraint and Keys, SQL Error Messages, WordPress

My blog was slow and scheduled posts failed. The cause was a Wordpress Database Error: duplicate entry for key PRIMARY in wp_options. Here is how I fixed it.

Read More
Gouache painting of a tidy wooden workshop after spring cleaning, with closed boxes by the door, one vermilion, and a broom.

Blog Clean-Up: What a 20-Year-Old Blog Removed in 2026

May 31, 2013
Pinal Dave
Personal
Best Practices, Blogging, WordPress

A blog clean-up is the work nobody sees and every reader feels. This post lists what a 20-year-old blog removed and fixed in 2026: plugins, unused images, thin tags and dead announcements. Each step comes with a lesson for any blogger.

Read More
Gouache painting of a small sailboat at a dock with gear laid out in a row, rope, sail, lantern, bucket and a vermilion life ring.

Blog Launch Checklist: What to Set Up Before Your First Post

May 26, 2013
Pinal Dave
Personal
Best Practices, Blogging, WordPress

A blog launch checklist saves you from mistakes that are hard to fix later. This post walks through domain and HTTPS, a phone-friendly theme, the About page, search, categories, ways to follow, analytics, tested backups and the first three posts.

Read More
Gouache painting of a small cottage with its own garden gate, brass keys on the latch and a vermilion mailbox.

Starting a Blog: Own the Domain From Day One

May 21, 2013
Pinal Dave
Personal
Best Practices, Blogging, WordPress

Starting a blog takes an afternoon, but where it lives is the hardest choice to undo. This post compares hosted platforms with self-hosted WordPress, explains why your own domain keeps your links and readers safe, and lists what to set up first and what to skip.

Read More
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com