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
Figure showing an agent given a visitor badge: open doors to read, a person at the door to change anything.

AI Agents and Security: Keys to the Building

November 12, 2026
Pinal Dave
AI
AI, AI Book, Best Practices, SQL Server Security
Part seven of ten. An AI agent is a new kind of user in your systems. It reads, runs queries and takes actions, all at machine speed. These are the questions a security-minded interviewer asks before handing it any keys. Try this first, it takes a minute Paste this into…
Read More
Gouache painting of a thick glass observation window in a slate-blue wall, a quiet sage workshop visible inside, a wooden rail in front and one vermilion lantern hanging from the frame

Claude on SQL Server: Read, Prove, Then Change

October 29, 2026
Pinal Dave
AI
AI, Query Store, SQL Performance, SQL Server Security, SQL Wait Stats

Claude on SQL Server is safe when production gives it eyes and nothing else. This post splits the loop into three stages: start this week with a read-only login, make it a daily habit with a past cases library, then run it on a schedule with a second opinion. I tested the login on SQL Server 2025.

Read More
Cardinal Rules, a three panel cartoon by SQLAuthority. The VP suggests letting the AI run straight into production. The red bird is already typing DELETE FROM and Sam pulls the cable out of the wall. The bird says the WHERE clause was coming eventually.

AI in Production Without a WHERE Clause

October 17, 2026
Pinal Dave
AI
AI, DBA, SQL Delete, SQL Server Security

AI in production without a second pair of eyes is a quick way to lose a table. Cardinal was going to add the WHERE clause. Eventually.

Read More
Row-Level Security

SQL SERVER – Implementing Row-Level Security (RLS)

November 12, 2024
Pinal Dave
SQL Tips and Tricks
SQL Server Security

Row-Level Security (RLS) in SQL Server enables fine-grained control over data access, ensuring users can only view or modify rows pertinent to their roles or responsibilities.

Read More
ddmsql

SQL SERVER – Dynamic Data Masking (DDM) Introduction

November 11, 2024
Pinal Dave
SQL Tips and Tricks
SQL Server Security

Dynamic Data Masking (DDM) in SQL Server is a feature that helps protect sensitive data by masking it from unauthorized users.

Read More
SQL Server Ledger

SQL Server Ledger – Are You Really Using This Feature?

October 31, 2024
Pinal Dave
SQL Tips and Tricks
SQL Server Security

SQL Server Ledger – has taken data integrity to the next level, integrating blockchain-style data verification directly into the database.

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
1 2 3 4 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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