Skip to content
SQLFolks
Menu
  • Tips & Tricks
  • Indexes
  • Query Hints
  • AI
  • Links
  • Contact

Category: AI

AI / Tips & Tricks

SQL Studio Generated by AI (Copilot & Claude)

A lightweight SSMS‑style SQL dashboard built in PowerShell and WPF. It loads multiple SQL files as tabs, executes queries across one or more servers, displays results in an embedded browser, …

AI / Query Hints / Tips & Tricks

Integrate Ollama AI with SQL Server 2025 for Parallel Execution

If you have already installed Ollama server, for example based on this article Setting Up Ollama for SQL Server 2025: A Guide – John Deardurff, then you need to register …

SEARCH:

Brent Ozar’s Blog

“But NOLOCK won’t hurt me if I’m using an index!”
“But NOLOCK won’t hurt me if I’m using an index!”

NOLOCK is bad and you probably shouldn’t use it, but every time I mention that publicly, the pushback just keeps coming. I don’t know why people so firmly believe that their [...]

[Video] Office Hours on Mount Charleston
[Video] Office Hours on Mount Charleston

For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the weekend at Mount Charleston. Let’s go through your top-voted questions from https://pollgab.com/room/brento. [...]

Database Animations: How SQL Server’s JSON Indexes Work
Database Animations: How SQL Server’s JSON Indexes Work

By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to store practically schema-less JSON blobs as part of each row, and have [...]

Set Your Application Names Before You Wish You Had.
Set Your Application Names Before You Wish You Had.

When you run monitoring queries like sp_BlitzWho and sp_WhoIsActive, you wanna see the program names that are running the queries. It’s super useful when you’ve got multiple apps running on [...]

Copyright © 2026 SQLFolks – OnePress theme by FameThemes