AI SQL Tuner Studio 1.0.29.0 Adds Claude Sonnet 4.6 and Opus 4.6

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:

Model Provider Free Standard Pro Corporate
Claude Sonnet 4.6 Anthropic ✓ ✓ ✓ ✓
Claude Opus 4.6 Anthropic — — — ✓
GPT-5.4 OpenAI ✓ ✓ ✓ ✓

Claude Opus 4.6 is Corporate-only. That’s Anthropic’s most capable model, and AI SQL Tuner is reserving it for the top tier. Everyone else gets Claude Sonnet 4.6 and GPT-5.4.

Reasoning effort by edition

Alongside the model choice, the Studio exposes a reasoning effort setting. Higher effort means the model thinks longer and produces a more detailed report. Lower effort is faster and shorter.

Edition Low Medium High
Free ✓ — —
Standard ✓ ✓ ✓
Pro ✓ ✓ ✓
Corporate ✓ ✓ ✓

The Free edition is locked to low reasoning effort. That’s still enough for a usable Server Health Check or query recommendation — just a tighter, shorter write-up. Standard, Pro, and Corporate can switch to medium or high when they want a deeper review.

Why this matters if you build on Power BI

Most Power BI performance conversations start with DAX, data model design, and visuals. That’s fair — those are the levers with the biggest upside when you’re 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 SQL Server tuning tool that can tell you why queries are slow — the top wait types, the missing high-value indexes, the deadlocks, the configuration red flags — is useful to any team whose BI stack is anchored on SQL Server. AI assistance on top of that shortens the distance between “the refresh is slow” and “here’s the fix.”

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. Here’s a sample Server Health Check generated with Claude Opus 4.6 at low reasoning effort so you can see the format before you install:

View the sample Server Health Check report →

Quick facts

  • Version: 1.0.29.0
  • New models: Claude Sonnet 4.6 (all editions), Claude Opus 4.6 (Corporate only)
  • Existing model: GPT-5.4 (all editions)
  • Reasoning effort: Low for Free; Low/Medium/High for Standard, Pro, Corporate
  • Endpoint config: None required — Anthropic models are built in
  • 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

Try it

The Free edition supports SQL Server Developer Edition at no cost and now runs against Claude Sonnet 4.6 out of the box — a low-friction way to 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.6 for the deepest analysis.

You can grab 1.0.29.0 from the AI SQL Tuner downloads page.

Location: Commack, NY, USA

Comments

Post a Comment

Popular posts from this blog

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

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

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