Microsoft Fabric and Microsoft Data Platform News and Tips

Big news for the data and analytics community: AI SQL Tuner Studio just launched on Product Hunt.  If you work with SQL Server—Power BI models, ETL pipelines, or enterprise workloads—this tool gives you instant, AI‑guided tuning insights without digging through execution plans.  To mark the launch, enjoy 30% off Standard and Pro Editions using code PH30 through 31-May-2026.  Check out the launch and join the conversation at Product Hunt .

If your Power BI models sit on top of SQL Server — DirectQuery, Import from relational sources, composite models, or a dedicated warehouse — the speed of your reports is tied to the speed of the database underneath. AI SQL Tuner Studio 1.0.29.0 is out, and the headline change is AI model support. The product now offers Claude Sonnet 4.6 and Claude Opus 4.6 from Anthropic, alongside the existing GPT-5.4 from OpenAI. What’s actually new Version 1.0.29.0 adds two Anthropic models to the AI Model dropdown inside the Studio. You can use them for any of the product’s tuning goals — Server Health Check, Query Tuner, Index Insights, Deadlock Analysis, and Code Review. The Anthropic models are built in . No separate Anthropic API key, no Bedrock account, no Azure endpoint to configure. Pick the model, run the analysis, get the report. Model availability by edition The Anthropic rollout isn’t uniform across editions. Here’s the matrix: ...

AI SQL Tuner Studio 1.0.28 is now available, and it introduces a significant new capability: Query Tuner . This release also rolls up Index Tuning improvements that shipped in 1.0.27 but were never formally announced. Query Tuner: AI-Powered Execution Plan Analysis Query Tuner is a new tuning goal that analyzes a single SQL query in depth. Point it at any stored procedure, ad-hoc query, or batch, and it captures the estimated execution plan via SET SHOWPLAN_XML ON , then parses the plan XML to identify referenced tables, operators, warnings, and missing index hints. From there it collects targeted metadata — index usage stats, DMV missing indexes, table sizes, foreign keys, column cardinality, and statistics settings — scoped only to the tables your query actually touches. Everything is sent to the AI model, which returns prioritized, evidence-based recommendations specific to that query. What You Get in the Report The Query Tuner report is structured around actionable secti...

AI SQL Tuner Studio We’re excited to announce the launch of AI SQL Tuner Studio, a modern Windows desktop application that brings all four of our tuning goals into one fast, intuitive experience: 🔹 Server Health Check Get a full diagnostic snapshot of CPU, memory, IO, TempDB, waits, and configuration issues — with clear, actionable recommendations. 🔹 Index Tuning Identify missing, unused, and overlapping indexes with ready‑to‑run scripts and estimated performance gains. 🔹 Code Review Analyze SQL for implicit conversions, non‑SARGable predicates, parameter sniffing risks, inefficient joins, and more. 🔹 Deadlock Analysis Analyze deadlock XML and associated code and quickly see the root cause and recommended fixes. All four tuning goals now run inside a clean, native WinUI 3 desktop app — built for speed, clarity, and real‑world SQL Server workloads. ✨ What’s new in AI SQL Tuner Studio Modern Windows UI Professional HTML reports Support for SQL Server 2016–2022, Managed Instance, ...

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...

  A recent post on  https://aisqltuner.com/  provides  4 Tips for Using AI with SQL Server Databases : Choose the Right Data Select the Best AI Model Use an appropriate prompt Pick the right options for your LLM If you would prefer to use a program that already has these built-in, give AI SQL Tuner a try. You can start with the Free edition that works with SQL Server Developer Edition. The paid versions come with a 30-day money-back guarantee so you can try any of them a risk-free.

Introduction AI SQL Tuner is a next-generation database tuning solution that leverages artificial intelligence and GPT-5 on Azure to dramatically reduce the time required for SQL Server performance optimization. Whether you’re a DBA, developer, or IT manager, AI SQL Tuner provides actionable insights in seconds that would normally take hours of manual analysis. What does AI SQL Tuner do? AI SQL Tuner offers four core features designed to improve SQL Server performance and reliability: Index Recommendations – Automatically suggests indexes based on workload patterns to improve query speed. Deadlock Analysis – Reviews recent deadlocks, identifies root causes, and provides clear solutions. Code Review – Analyzes stored procedures, triggers, and user-defined functions to reduce locking, improve maintainability, and boost performance. SQL Server Health Check - Provides a comprehensive analysis of your SQL Server instance to identify performance bottlenecks, configuration issues, se...