Microsoft Fabric and Microsoft Data Platform News and Tips

AI SQL Tuner now incorporates GPT-5.2 as its primary model. GPT-5.2 is a strong match for AI SQL Tuner because it combines deeper reasoning with clearer, more structured output. Microsoft describes it as: GPT-5.2: The most advanced reasoning model that solves harder problems more effectively and with more polish. An example of this is information work, where great thinking is now complemented with better communication skills and improved formatting in spreadsheets and slideshow creation. In practice, those improvements translate well to database tuning: stronger analysis of complex indexing tradeoffs, better plan-cache interpretation, and cleaner recommendations that are easier to review and implement.  Testing using HammerDB running the TPCH benchmark showed AI SQL Tuner's recommendations improved performance by nearly 75%.  For more details, see the full post at https://aisqltuner.com/2025/12/13/ai-sql-tuner-gets-smarter-gpt-5-2/ .  If you are ready to try it you ...

For those that don’t know, Brent Ozar is one of the leading consultants focusing on SQL Server performance. He is well-known as the developer of the   SQL Server First Responder Kit , a great set of scripts for diagnosing SQL Server issues. In a recent post, “ Get ChatGPT’s Advice On Your Queries with sp_BlitzCache “, he shared the following:    I vividly remember one gig where a client had been struggling with memory starvation for  months , and on the call together, we identified the query with sp_BlitzCache, then pasted the query into ChatGPT. It found the query’s problem in minutes, rewrote the query to work around the problem, and then we got started testing the changes to make sure they worked the way we needed ’em to work. Bottom line is Brent is better at pretty much everyone else when it comes to SQL Server tuning and he is acknowledging that AI can be better and faster than him. Head over to  Even Brent likes AI now - AI SQL Tuner  to see the full...