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
Three gemstones fit their individual settings while loose stones remain apart

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
bdd-tdd

Dissecting BDD and TDD: An In-Depth Comparison

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

two approaches often surface as the prime navigators guiding us toward the shore of high-quality software – Behavior-Driven Development (BDD) and Test-Driven Development (TDD)

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
11tips

11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes

February 1, 2023
Pinal Dave
SQL Performance
Normalization, Software Development, SQL Backup and Restore, SQL Cursor, SQL Data Storage, SQL Datatype, SQL Index, SQL Server, SQL Server Security, SQL Statistics, Temp Table

This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.

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
Click Enter field for cell.

Google Drive Trick – Google Spreadsheet Formatting Dates to String

September 14, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, Software Development

Google Spreadsheet keeps turning the dates I type into mm/dd/yyyy. My team found a trick to keep dates as plain strings so nobody mixes up formats.

Read More
A man in a suit and red tie, drinking tea.

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

March 22, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, Professional Development, Software Development

I was reading Dr. W. Edwards Deming’s 14 principles of Total Quality Management. Here they are, with a few resources I collected on the subject.

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

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