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
A pair of brass scales on a counter with a coin resting in each pan, perfectly level

What Is a Transaction in SQL Server?

June 12, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

A transaction in SQL Server is a group of changes that all happen or none do. A rollback that undid 16,440 rows, what ACID means in four short words, and the open transaction that quietly fills a drive.

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 wooden card box full of blank index cards with a pencil, one card standing up in a vermilion clip.

Blog Ideas: What to Do When You Run Out of Things to Write

May 24, 2013
Pinal Dave
Personal
Best Practices, Blogging, Professional Development

Every blogger hits the day when the list of blog ideas is empty. This post shows where new topics come from: your own questions, reader comments, mistakes you fixed and old posts that deserve a better answer, plus a simple way to keep an idea list.

Read More
Gouache painting of an artist table with an open sketchbook and a framed painting carrying a blank tag tied with vermilion string.

Blogging Ethics: Credit, Copyright and Images

May 23, 2013
Pinal Dave
Personal
Best Practices, Blogging, Professional Development

Blogging ethics comes down to saying where things came from. This post covers quoting versus copying, crediting and linking sources, the images you can use, including AI-generated ones, sponsor disclosure, public corrections and comments.

Read More
Gouache painting of stepping stones winding through a garden to a bench with an open book, one stone painted vermilion.

Writing an Interesting Blog Post People Finish Reading

May 22, 2013
Pinal Dave
Personal
Best Practices, Blogging, Professional Development

Writing an interesting blog post is mostly a matter of habits. This post covers starting with the reader’s problem, keeping one idea per post, using a real example, writing a title that promises something and ending when the point is made.

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
Previous 1 … 16 17 18 19 20 21 22 … 54 Next
  • Books
  • Testimonials
  • Privacy Policy

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