SQL Nexus version 7.24.10.10

Prerequisites to run SQL Nexus

1. .NET framework 4.8 (runtime is sufficient). Windows 11 has version already.
2. Download and install RML Utilities (RMLSetup_AMD64.msi)
3. An instance of SQL Server (versions 2012 through 2022) to connect to and process data
4. Optional: PowerBI Desktop

Note: Starting with version 7.24.02.18, it's no longer required to install SQLSysClrTypes and ReportViewer Control. These come packaged with SQL Nexus

Automate Prerequisites Installation

You can use the following PowerShell file (https://github.com/microsoft/SqlNexus/blob/master/Setup-Related/SetupSQLNexusPrereq.ps1) to install the three required and one optional prerequisites for SQL Nexus

How to Download and Use

1. Download the SQLNexus_7.24.10.10_Signed.zip from Assets below. This is a zip file that contains Microsoft digitally-signed binaries for SQL Nexus.
2. Extract in a path location of your choice
3. Go to the path and run sqlnexus.exe

Verify downloaded file:

You can verify the download by computing the hash of the SQLNexus_7.24.10.10_Signed.zip file, using this command:

certutil -hashfile SQLNexus_7.24.10.10_Signed.zip SHA512

Compare to this:

51ab14d37b813e8e0ec4a4b6c09d9bc4baee83851a6c97f33b4e1bd9df6cc5fbbbfd41d2c86226fd881a466eb50701417de09e5afa67631fc412186e0014b90c

List of fixes and enhancements:

• Upgrade .NET and system assemblies to ensure secure platform security - #372
• [Keyboard Navigation-SQL Pref Main]: 'Import' button present in the Tasks Dropdown is not keyboard accessible - #371
• Add rowset for sysmail_server - #367
• Add new XML rowsets to SQL Nexus for
  • importing the TCP and UDP connection info from SQL LogScout - #362
  • The new Full-Text Search log collection from Log Scout - #358
  • New disk information collection from SQL logscout - #356
  • Columns QDS modifications - #315
  • Missign MSI/MSP packagesa pluse add a new Report - #336
• Replication Report Not Showing on Main Report Listing when tbl_repl_msmerge_subscriptions table is empty - Remove Unneeded Dependency - #364
• Upgrade Azure.Identity and Microsoft.Identity.Client libraries (see dependabot PRs) - #353
• Luminosity contrast ratio of 'Edit fields' with background fails to meet the required ratio of 3:1 - #347
• Narrator/JAWS are not narrating name for 'Browse for folder' button present in the Data Import Dialog, while navigating using Tab/Down arrow key - #344
• Name property is not defined for multiple controls in the header section - #343
• Screen readers are not narrating role (as dialog) once the dialog is displayed on invoking 'help' control - #342
• Narrator/JAWS are not narrating label mapped information for multiple controls in the dialog, while navigating in scan off mode - #341
• Narrator is narrating incorrect role and not narrating state for dropdowns present in the 'SQL Pref Main' page, while navigating using focus/scan mode - #340
• Keyboard focus is not sequential order in the 'Left navigation' in the 'SQL Pref Main' page, while navigating using 'Tab' key - #339
• Tempdb Space usage report shows incorrect data when large result sets are returned - #310
• Loaded_modules report is empty - need to update report query - #313
• Update Prerequisites installation PS file to only install .NET Fx and RML and remove RVC and SQLSystem components- #308
• Upgrade all MS Nuget packages to get them all upto the latest and address potential vulnerabilities - #375

Development Environment:

Visual Studio 2015/2017/2019/2022

What's Changed

• QueryStore_Additional_Data sys.dm_db_tuning_recommendations by @jagriffin5 in #312
• Update README.md by @asavioliMSFT in #316
• Add rowset for missing msi/msp files #336 by @PiJoCoder in #337
• fixed incorrect column data mapping in Tempdb Space usage report grid by @hacitandogan in #311
• Issue #353 upgrade MS libraries Azure.Identity and Microsoft.Identity.Client due to low/moderate vulnerabilities in them by @PiJoCoder in #354
• Adding new rowsets for FullText-search metadata by @asavioliMSFT in #359
• Add disk information rowset by @PiJoCoder in #357
• Add tcp and udp rowsets by @PiJoCoder in #363
• SQL Nexus Accessibility Remediation bug Fixes by @Das-Supriya in #365
• #367 add sysmail_server rowset by @PiJoCoder in #368
• Remove dependency on sql perf main.rdl replication report on msmerge_subscriptions by @JamesFerebee in #370
• Bump the nuget group across 8 directories with 2 updates by @dependabot in #360
• Add rowsets for replication enhancements in logscout. PR 340 by @JamesFerebee in #373
• Setup script update and MS Nuget Packages upgrade to latest by @PiJoCoder in #376

New Contributors

• @Das-Supriya made their first contribution in #365
• @dependabot made their first contribution in #360

Full Changelog: 7.24.02.18...7.24.10.10