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: 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
SQL Server Maintenance Techniques

SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly

October 6, 2023
Pinal Dave
SQL Tips and Tricks
Hardware, Maintenance Plan, SQL Audit, SQL Backup and Restore, SQL Error Messages, SQL Index, SQL Log, SQL Server Security, SQL Statistics, SQL Upgrade, Testing

This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.

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
A tennis ball machine sending every ball to the same spot on a clay court, the marks clustered in one place.

Repeatable Test Data With a Fixed Random Seed

September 15, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Random, SQL Server, Testing

Generate repeatable test data with a fixed RAND seed or row-number hashes, then verify identical names and amounts across runs.

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
Two makers compare a finished leaf inlay sample with a matching piece and recess

Unveiling Behavior-Driven Development (BDD): Bridging the Gap Between Business and Testing

June 9, 2023
Pinal Dave
SQL Tips and Tricks
Testing

Behavior-Driven Development connects shared examples with tests. Compare BDD and TDD, and see how a banking scenario makes outcomes observable.

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

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