Writing Window Functions with an AI Partner
AI agents write complex window functions faster than you can look up the frame clause syntax.
Converting Implicit Joins to ANSI Syntax with AI
Use an AI agent to convert legacy implicit joins to ANSI JOIN syntax safely.
Writing T-SQL with an AI Partner
Use AI to write T-SQL faster generating functions, complex JOINs, window functions, and optimization suggestions. Practical prompts for real DBA work.
CROSS APPLY as an alternative to UNPIVOT
This morning, I was listening to the inimitable SQL Server Radio podcast, with Matan Yungman and Guy Glantser. They mentioned how Itzik Ben-Gan had documented a great way to turn CROSS APPLY into an extensible…