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
Plain parcels waiting above a chute while one parcel rests at the outlet

Database Mail Health Check: Unsent Items and the Event Log

September 11, 2019
Pinal Dave
SQL Tips and Tricks
Comprehensive Database Performance Health Check, Database Mail, System Database, Transaction Log

The alert job succeeded, yet nobody got the email. Here are three read-only checks that show whether Database Mail is really working.

Read More
A revolving punch making one specified round hole beside differently shaped test holes

Enforcing Formats With a REGEXP_LIKE Check Constraint

June 10, 2019
Pinal Dave
SQL Tips and Tricks
Comprehensive Database Performance Health Check, SQL Constraint and Keys, SQL Server

Stop badly shaped product codes before they reach a report. A short, tested walk-through of anchors, NULLs and adding the rule to old data.

Read More
An experienced hand passing a wooden mallet to an apprentice over a nearly finished boat hull

Consulting Wrap Up – What Next and How to Get Started

March 30, 2019
Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, DBA, SQL Server

Use this consulting wrap up to keep a practical engagement checklist, choose the right service, and prepare the first email to get started.

Read More
A hand pulling a dandelion from a lawn with its whole long root intact

Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem?

March 29, 2019
Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, SQL Performance, SQL Server

Learn to diagnose the same problem yourself, distinguish symptom relief from a root-cause fix, and know when a follow-up is useful.

Read More
Two hands passing a jar of sourdough starter across a counter, a loaf from it cooling behind

Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers?

March 28, 2019
Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, SQL Scripts, SQL Server

Keep performance tuning scripts with explanations, before-values, undo steps, and a configuration history your team can compare later.

Read More
An open first aid kit on a rock with its contents laid out in order, a hand reaching for the first

Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours?

March 27, 2019
Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, Consulting, SQL Performance, SQL Server, SQL Wait Stats

See how performance optimization in 4 hours follows focused triage, reviewed fixes, and a written action plan for the work that remains.

Read More
Two spirit levels on stone steps, one bubble centered on the new step, one off on the old

Consulting 102 – What Do I Promise in Every Engagement?

March 26, 2019
Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, Consulting, SQL DMV, SQL Server, SQL Wait Stats

Know what I promise in every engagement, define a useful baseline, and compare performance changes without trusting a speed claim.

Read More
Previous 1 2 3 Next
  • Books
  • Testimonials
  • Privacy Policy

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