AI SQL Tuner Studio 1.0.40 Adds Dark Mode, a New UI, and Export SQL

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 there is a new always-on status bar that shows what the analysis is doing.

There is a new Paper and Teal color palette in place of the old blue theme, and a proper Dark Mode. A new View menu lets you set the app to Follow System, Light, or Dark.

The change most worth your attention, if you build Power BI on SQL Server but do not administer the database yourself, is Export SQL. When the analysis produces index or query recommendations, one click writes that SQL out to a file. That file is what you hand to whoever runs the server. No retyping a script out of a screenshot, no trying to describe an index in an email. Saved files also get a sensible default name in the format tuning-goal-report-model-server-database-yyyy-mm-dd.sql, so the script does not get lost on your desktop.

What's new in 1.0.40

FeatureDescriptionEditions
Redesigned UITappable goal cards, collapsible console drawer, always-on status barAll
Paper and Teal paletteNew color theme replaces the previous blue theme for readabilityAll
Dark ModeView menu with Follow System, Light, or Dark on a graphite baseAll
Export SQLOne-click export of recommended SQL to a file with a smart default nameAll
Help menuRelease Notes link added alongside the updated User GuideAll

One caveat. The HTML report uses the new color palette, but it currently renders in light mode only. Dark Mode for the report itself is on the roadmap for a later release.

Why this matters if you build on Power BI

Most Power BI performance conversations start with DAX, data model design, and visuals. That is fair, those are the levers with the biggest upside when you are in report design. But once the model is tidy, the next layer of slow-downs usually lives in the SQL that Power BI sends to the source:

  • DirectQuery reports hit the database on every interaction. Slow SQL means slow visuals, end of story.
  • Import mode refreshes pull data through SQL queries. A bad plan or a missing index makes refresh windows balloon.
  • Composite models mix DirectQuery and Import, so both sets of pains apply.
  • Paginated reports (RDL) and SQL Server Reporting Services are even more SQL-sensitive.

A redesigned interface does not make your queries faster on its own. It just streamlines the process between "the refresh is slow" and "here is the fix in the right person's hands." Export SQL is the clearest example. The analysis finds the missing index, and you can pass the exact statement to your DBA without anything getting lost in translation.

Sample report

AI SQL Tuner Studio produces its recommendations as a formatted HTML report with an executive summary, prioritized findings, and a confidence level on each one. Two samples generated with 1.0.40, so you can see the format before you install:

Quick facts

  • Version: 1.0.40.0
  • Release type: user experience update, tuning engine unchanged
  • New UI: tappable goal cards, collapsible console drawer, always-on status bar
  • New theme: Paper and Teal palette, with Light, Dark, and Follow System modes
  • Export SQL: one-click save of recommended SQL to a file
  • Default file name format: tuning-goal-report-model-server-database-yyyy-mm-dd.html or .sql
  • Availability: every feature in every edition (Free, Standard, Pro, Corporate)
  • SQL Server permissions required: VIEW SERVER STATE and VIEW DATABASE STATE (read-only)
  • Trial: paid editions include a 14-day free trial and a 30-day money-back guarantee
  • Discount: code PH30 takes 30 percent off Standard and Pro through May 31, 2026

Try it

The Free edition runs at no cost and supports SQL Server Developer Edition, so it is an easy way to point the new interface at the database behind your slowest report and see whether the recommendations match what your DBA would tell you. If the report style fits how your team works, the paid editions unlock higher reasoning effort and broader SQL Server edition coverage, and Corporate unlocks Claude Opus 4.7 for the deepest analysis.

Use code PH30 for 30 percent off Standard and Pro through May 31, 2026. You can grab 1.0.40 from the AI SQL Tuner downloads page, and the full 1.0.40 release notes have the rest of the detail.

Location: Commack, NY, USA

Comments

Post a Comment

Popular posts from this blog

Getting Started with SQL Server 2017 - Installation

Image
Introduction SQL Server 2017 has not been officially released yet, but you can start evaluating it with the Community Technical Preview (CTP).  This post will describe how to download and install it. Download Before starting the SQL Server installation process it is a good idea to close any other programs, so the install is not competing with other programs.  Also, you will likely need to reboot at the end of the installation anyway. To get started, head over to https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2017-ctp/ .  You will then need sign in with your Windows Live account.  Once you are signed in, you will also need to register and set your communications preferences. Once you've registered, you will be given a choice of ISO or CAB file type.  I'll go with ISO. The next choice is Product Language, and I will choose English.  Your browser will then let you download a 1.68 GB file, SQLServerVnextCTP2.0-x64-ENU.iso.  I...
Read more

Jumping into Azure Data Lake

Image
Introduction You may have heard of Data Lakes and are wondering if it is the next big thing.   This post will provide an overview of Azure Data Lake, how to use it and some of its pros and cons. History of Data Lakes and Azure Data Lake The Data Lake term was coined by Pentaho in October 2010 to address limitations of a data mart, which typically has a subset of attributes and is aggregated.   Per Jamie Dixon’b Blog, the lake terminology was chosen since “the contents of the data lake stream in from a source to fill a lake, and various users of the lake can come to examine, dive in, or take samples.” Microsoft’s Azure Data Lake became generally available in November 2016, as described in this post: https://azure.microsoft.com/en-us/blog/the-intelligent-data-lake/ .   There are really three services that make up the data lake as shown in the diagram below.   The underlying technology for the data lake is based on Hadoop, but as an end user that is...
Read more

Identifying Possible Price Fixing in the market of Ethacrynic Acid 25 MG tablets

  Executive Summary Ethacrynic Acid 25 MG tablets is the generic form of Edecrin, a loop diuretic that was originally approved by the FDA in 1967.   Ethacrynic Acid is the only loop diuretic that does not contain sulfa, so there are no substitutes for patients that need a loop diuretic but are sensitive to sulfa. There are multiple generic manufacturers of Ethacrynic Acid 25 MG tablets.   However, data from the National Average Drug Acquisition Cost provided by the Centers for Medicare and Medicaid Services show that the prices fluctuate over time but consistently move in lockstep.   Given the significant fluctuation in prices, the only rational conclusion is that the generic drug makers are colluding to fix the price at an artificially high level.   Background Etacrynic acid (INN) or ethacrynic acid (USAN), trade name Edecrin, is a loop diuretic used to treat high blood pressure and the swelling caused by diseases like congestive heart failure, liver ...
Read more