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
Vertical technical decision flow for validating an AI-generated SQL Server index recommendation through evidence, design review, workload testing, deployment, monitoring, and rollback.

Validating AI-Generated Index Recommendations

August 12, 2026
Pinal Dave
SQL Tips and Tricks
Idera

Validating AI-generated index recommendations is the step between a persuasive script and a change you can defend in production.

Read More
A male database consultant stands between a green falling cost graph and a red service failure indicator

Cost Optimization That Never Reaches the Invoice

August 11, 2026
Pinal Dave
SQL Tips and Tricks
SQL Performance

SQL Server cost optimization has a problem nobody puts on the slide. The savings are real, and none of it reaches the invoice.

Read More
Visible incident response attracts alerts and recognition while quiet prevention keeps the system healthy

A Better Fire Alarm Is Still a Fire

August 10, 2026
Pinal Dave
AI
Developer

A better fire alarm is still a fire, and many SQL Server incidents I get called for were preventable. Here is the T-SQL audit I wish had run before the pager rang.

Read More
A seated person photographed against a bright window so that they are a complete silhouette with no features visible, with a second empty chair facing them

They Finished the AI Training. Eleven Days Later, the Job Was Gone

August 7, 2026
Pinal Dave
AI
Career Advice, Developer

An anonymous interview with a database professional who finished the AI training their employer assigned. Eleven days later, the job was gone.

Read More
A dense grid of small tiles representing hundreds of SQL Agent jobs, colour coded into four categories, with most tiles grey for dead and a small cluster in red for failing silently

Nine Unusual Ways My Clients Use AI With SQL Server

August 6, 2026
Pinal Dave
AI
Oracle, SQL Index, SQL NULL, SQL Performance

Everyone writes about AI generating queries. Here are nine unusual ways my clients use AI with SQL Server, and I helped build every one.

Read More
A printed internal email pinned to a cubicle wall reading EFFECTIVE IMMEDIATELY DO NOT USE with a coffee ring on the corner

AI Training at Work: Nobody Is Coming

August 5, 2026
Pinal Dave
AI
Developer

Everyone is waiting for AI training at work. It took me a hundred conversations to understand what they are actually waiting for, and it is not a course.

Read More
SQL Server Deadlock: Build One With Your Own Hands

SQL Server Deadlock: Build One With Your Own Hands

August 4, 2026
Pinal Dave
SQL Performance
Deadlock, SQL Server

A SQL Server deadlock occurs when sessions form a cycle of dependencies and none can continue. This example lets you create the cycle, inspect it, and remove it.

Read More
Previous 1 … 7 8 9 10 11 12 13 … 843 Next
  • Books
  • Testimonials
  • Privacy Policy

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