AI SQL Tuner Studio Is Now in the Microsoft Store

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 direct download?

Studio is still available as a direct download from aisqltuner.com. Here is how the two compare:

Microsoft StoreDirect download
Windows 10 and 11 (x64 and ARM64)YesYes
Windows ServerNoYes
UpdatesThrough the StoreCheck for Updates downloads the new installer
LicensingYour Microsoft Store accountA license key
30-day money-back guaranteeNoYes

Install from one place only. Windows treats the two as separate apps, so installing one does not update or replace the other. If you switch, uninstall the one you no longer use.

Why this matters if you build on Power BI

Once the DAX and the model are tidy, the next layer of slowdowns usually lives in the SQL that Power BI sends to the source. DirectQuery reports hit the database on every interaction, and Import refreshes pull their data through SQL queries, so a bad plan or a missing index shows up as slow visuals or long refresh windows.

If you build reports but do not administer the database, a Store install is a simple way to try Studio on your own PC. The six tuning goals (Server Health Check, Fix Deadlocks, Index Tuning, Locking and Blocking Analysis, Code Review, and Query Tuner) are in every edition, and Export SQL writes the recommended scripts to a file you can hand to whoever runs the server.

All editions, including Free, work with every version of SQL Server, Azure SQL Database, Azure SQL Managed Instance and Fabric SQL Database.

Get it

Install AI SQL Tuner Studio from the Microsoft Store, or download the Free edition directly. The current version is 3.5.2. For setup details, see the user guide.

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

Power BI Licensing Basics

Microsoft Power BI Licensing Basics Introduction Microsoft Power BI's licensing has evolved over time and can be a bit confusing.  The goal of this post is to clear up the confusion. Power BI Publishers vs. Consumers Within your organization there will typically be two categories of Power BI users: publishers and consumers.  Publishers are creating reports using Power BI Desktop and publishing them to the Power BI Service.  Consumers are viewing the reports and dashboards on the Power BI Service and interacting with them. Licensing Requirements Each publisher will need a Power BI Pro license.  The licensing for consumers is where it gets more interesting.  Each consumer also needs a Power BI Pro license, unless the report is in Power BI Premium capacity.  In that case, consumers just need to be assigned a Power BI Free license. Power BI Premium When you purchase Power BI Premium, you are buying capacity in the Microsoft Azure cloud, not a l...
Read more