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
Cutaway illustration of a factory line from IN to OUT, a dozen small hand cranked stations, and one station carrying an enormous chrome motor lettered NEW MOTOR.

AI Productivity Gains Went Up and Nothing Shipped Faster

October 13, 2026
Pinal Dave
AI
AI, Best Practices, Developer, DevOps, Software Development

AI productivity gains went up on every dashboard, and the release notes are the same length as last year’s. Writing code was never the constraint. Speed up one station and you get a taller pile in front of the station that is. Here is how to time your own line.

Read More
Gouache painting: three identical recipe cards side by side on a wooden table, each covered in plain wavy lines instead of writing, one vermilion ribbon laid across all three, and a small jar of gherkins beside them

Gherkin Language Beyond English: Keywords in Other Languages

October 10, 2023
Pinal Dave
SQL Tips and Tricks
Developer, Software Development, Testing, Unicode

The Gherkin language is not limited to English. This post shows the language header, the same scenario in English, French and Hindi, a keyword table, why a team gains from writing in its own language, and the limits found when the keywords are mixed.

Read More
Gouache painting: a pantry shelf with three neat, well-filled jars of pickled gherkins on the left and six cluttered, overfilled jars on the right; one jar lid is vermilion

Gherkin Scenarios: 3 Examples to Follow and 6 to Avoid

September 20, 2023
Pinal Dave
Personal
Developer, Software Development, Testing

Write Gherkin scenarios that specify behavior clearly. Compare three examples to follow with six to avoid, and make outcomes testable.

Read More
Gouache painting: a tea shop counter where one small wooden crate is checked twice: once close up under a magnifying lens, and once from across the room on a wide shelf; the crate's tag is vermilion

BDD vs TDD: One Small Feature, Two Ways to Test It

August 31, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, Developer, Software Development, Testing

BDD vs TDD is easy to mix up until you test the same feature both ways. This post checks one delivery rule with a unit test and then with a plain-language scenario, runs the unit test, and explains when each approach fits.

Read More
A lawn bowls green with the jack in place, a bowl rolling toward it and a hand holding a measuring string.

Given-When-Then for Database Tests

July 24, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, Software Development, SQL Server, SQL Stored Procedure, Testing

Use Given-When-Then for readable database tests with known input, explicit THROW checks, and transaction rollback after each case.

Read More
A community garden of separate raised beds, each with its own tools, a red trowel in one

Giving Every Developer a Dedicated Development Database

January 18, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, Developer, Software Development

Set up a dedicated development database from approved schema scripts and clean seed data, with repeatable rebuilds and drift checks.

Read More
Illustration for this post

Personal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device

November 17, 2013
Pinal Dave
SQL Tips and Tricks
Software Development

Finding a box of old floppy disks made me nostalgic. A quick look at the personal storage device, from 1.44 MB floppies to CD, DVD and USB drives.

Read More
1 2 3 4 … 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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