You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.
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.
What Can AI Really Do?
Steve asks you what you think AI can do for you today, with a few suggestions of what he sees.
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
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.
Improve Query Performance in the Fabric Warehouse with Clustering
Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.
We Are Eating Our Own Seed Corn
Last week I stood in front of a classroom at Washington State University and looked out at a room full of students who had done everything right. They had studied hard, were earning their degrees, built their portfolios, and showed up with genuine enthusiasm for careers in technology. They wanted to know what the industry […]
Designing SQL Server ETL Pipelines That Don't Break at Scale
A few lessons learned in building ETL pipelines and tricks to ensure you can easily maintain these over time.
Why I Don’t Like Shared Development Databases
Today, Kendra explains why she doesn't like shared development databases.
When, and when not, to use LLMs in your data pipeline
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.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers