Microsoft Fabric and Microsoft Data Platform News and Tips

If your Power BI models sit on top of SQL Server, whether that is DirectQuery, Import from relational sources, or composite models, the speed of your reports is tied to the speed of the database underneath. AI SQL Tuner Studio helps you find and fix what is slowing that database down, and you can now install it from the Microsoft Store . What the Store version takes care of The Store handles the parts of installing and licensing a desktop tool that used to need attention: Updates come through the Store. Help, then Check for Updates, asks the Store, and the update installs through it. No license key. Studio activates from the Microsoft Store account signed in on the PC, including the Free edition. Subscribe from inside the app. Manage license lists Pro, Team and Enterprise with the price for your market. You manage or cancel the subscription in your Microsoft account. Native on ARM64. The Store installs the x64 or ARM64 package that matches your PC, on Windows 10 and 11. Store or di...

If your Power BI models sit on top of SQL Server, whether that is 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.40 is out, and the headline change is the interface. The product now has a reworked UI, a new Paper and Teal color palette, full Dark Mode, one-click Export SQL, and an upgraded Help menu. What's actually new Version 1.0.40 is a user experience release. The tuning engine and the AI models are unchanged from the previous version. What changed is how the Studio looks and how it feels to work in. The six tuning goals (Server Health Check, Fix Deadlocks, Index Tuning, Locking and Blocking Analysis, Code Review, and Query Tuner) are now tappable cards instead of a list. The console moved into a collapsible drawer at the bottom of the window, which gives the HTML report a lot more room. The tuning goal panel collapses as well, and the...

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