Stop Prompting Your AI Agent. Give It a Playbook.
Learn about how you can better prompt your AI Assistant in solving problems and producing code.
2026-05-25
4,397 reads
Learn about how you can better prompt your AI Assistant in solving problems and producing code.
2026-05-25
4,397 reads
Learn how to efficiently run SQL Server using Amazon Elastic Container Service for a hassle-free Docker container experience.
2026-05-25
This article covers the basics of getting Database Mail setup in SQL Server.
2026-05-22
4,348 reads
Should you choose a local or remote MCP server? The best option depends on your security needs, performance goals, and deployment model. This guide explains the differences between local and remote Model Context Protocol (MCP) servers, including privacy, scalability, latency, and integration trade-offs.
2026-05-22
When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually executed. It’s easy to miss whole swaths of code that didn’t happen to execute one particular time.
2026-05-20
Built the index, but SQL Server still scans the whole table? Learn how to read execution plans and find exactly why your index is being ignored.
2026-05-18
3,387 reads
Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.
2026-05-18
A few lessons learned in building ETL pipelines and tricks to ensure you can easily maintain these over time.
2026-05-15
3,802 reads
LLMs should be used in data pipelines for unstructured text, semantic search, and natural language queries – but avoided for deterministic, high-volume, or regulated tasks. Drawing on my real-world experience building large-scale ML systems, in this guide I’ll explain exactly where LLMs belong in your data pipeline and, just as importantly, where they don’t.
2026-05-15
In theory, SQL Server performance monitoring is pretty simple: 1. Review the server’s top wait types, 2. Find the queries causing those wait types, 3. Fix those queries, or improve the way the server reacts to them (indexes, settings, etc.). But in practice, step 2 is awful because:
2026-05-13
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers