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
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
vibecoding

Vibecoding: What Is It and Why I Think It Will Change Everything

February 19, 2026
Pinal Dave
AI
AI, Developer

And he built it by simply talking to an AI. That is vibecoding. And trust me, once you understand it, you will not look at software development the same way again.

Read More
A heavy book chained to a wooden library lectern, a reader's hands resting on its closed cover.

Letting an LLM Query SQL Server Safely: A Read-Only Login and Guardrails

January 1, 2024
Pinal Dave
AI
AI, SQL Login, SQL Server, SQL Server Security, SQL View

Let an LLM query SQL Server through a restricted login, approved views, enforced row filtering, execution limits, and query auditing.

Read More
Gouache painting of beach pebbles in loose clusters, two similar round pebbles close together, one vermilion, and a jagged stone far away.

VECTOR_SEARCH in SQL Server 2025: Finding Similar Rows With a Vector Index

September 5, 2012
Pinal Dave
AI
AI, SQL Index, SQL Scripts

VECTOR_SEARCH returns the rows whose vectors sit closest to a vector you give it, and a vector index makes that search approximate and fast. This post builds a six-row test with hand-made numbers on SQL Server 2025, with no AI model, and lists the limits the test showed.

Read More
Gouache painting of a long loaf sliced into even pieces on a cutting board, one slice set apart on a vermilion napkin.

AI_GENERATE_CHUNKS in SQL Server 2025: Splitting Long Text Into Pieces

August 16, 2011
Pinal Dave
AI
AI, SQL Function, SQL Scripts, SQL String

AI_GENERATE_CHUNKS cuts one long piece of text into smaller pieces inside a query. This post tests the preview function on SQL Server 2025, shows what its columns hold and how overlap works, and explains how chunk size changes the number of pieces.

Read More
Previous 1 … 5 6 7 8
  • Books
  • Testimonials
  • Privacy Policy

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