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
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
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
The Night Shift.

The Strange Emotional Shift of Working Alongside a Machine That “Thinks”

February 23, 2026
Pinal Dave
AI
AI, SQL Index, SQL Performance

Let us talk about The Strange Emotional Shift of Working Alongside a Machine That “Thinks”. The Night a Query Finished Before I Did

Read More
MCP SQL Server.

Local AI Models for SQL Server – A Complete Guide

November 3, 2025
Pinal Dave
SQL Tips and Tricks
AI, SQL Performance

Let us learn about Local AI Models for SQL Server – A Complete Guide. What if you could bring the power of AI into SQL Server?

Read More
tempdb spills

Performance and TempDB Spills – SQL in Sixty Seconds 208

January 10, 2025
Pinal Dave
SQL Video
SQL Performance, SQL TempDB

Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills.

Read More
Deadlock and Profiler - SQL in Sixty Seconds 207

Deadlock and Profiler – SQL in Sixty Seconds 207

January 8, 2025
Pinal Dave
SQL Video
Deadlock, SQL Performance, SQL Profiler

In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.

Read More
ChatGPT Tricks

3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203

June 24, 2024
Pinal Dave
SQL Video
AI, SQL Performance

Here are 3 ChatGPT tricks to tune SQL Server: quick, practical methods to optimize your queries, with a SQL in Sixty Seconds video.

Read More
Previous 1 2 3 4 5 … 50 Next
  • Books
  • Testimonials
  • Privacy Policy

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