microsoft/SqlNexus 7.24.10.10

SQL Nexus version 7.24.10.10

Repository: microsoft/SqlNexus

Tag: 7.24.10.10

Published: 2024-10-15T15:07:18Z

Prerelease: no

Release notes:

Prerequisites to run SQL Nexus

1. .NET framework 4.8 (runtime is sufficient). Windows 11 has version already. 1. Download and install RML Utilities (RMLSetup_AMD64.msi) 1. An instance of SQL Server (versions 2012 through 2022) to connect to and process data 1. 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. 1. Extract in a path location of your choice 1. 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 https://github.com/microsoft/SqlNexus/pull/312
• Update README.md by @asavioliMSFT in https://github.com/microsoft/SqlNexus/pull/316
• Add rowset for missing msi/msp files #336 by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/337
• fixed incorrect column data mapping in Tempdb Space usage report grid by @hacitandogan in https://github.com/microsoft/SqlNexus/pull/311
• Issue #353 upgrade MS libraries Azure.Identity and Microsoft.Identity.Client due to low/moderate vulnerabilities in them by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/354
• Adding new rowsets for FullText-search metadata by @asavioliMSFT in https://github.com/microsoft/SqlNexus/pull/359
• Add disk information rowset by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/357
• Add tcp and udp rowsets by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/363
• SQL Nexus Accessibility Remediation bug Fixes by @Das-Supriya in https://github.com/microsoft/SqlNexus/pull/365
• #367 add sysmail_server rowset by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/368
• Remove dependency on sql perf main.rdl replication report on msmerge_subscriptions by @JamesFerebee in https://github.com/microsoft/SqlNexus/pull/370
• Bump the nuget group across 8 directories with 2 updates by @dependabot in https://github.com/microsoft/SqlNexus/pull/360
• Add rowsets for replication enhancements in logscout. PR 340 by @JamesFerebee in https://github.com/microsoft/SqlNexus/pull/373
• Setup script update and MS Nuget Packages upgrade to latest by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/376

New Contributors

• @Das-Supriya made their first contribution in https://github.com/microsoft/SqlNexus/pull/365
• @dependabot made their first contribution in https://github.com/microsoft/SqlNexus/pull/360

Full Changelog: https://github.com/microsoft/SqlNexus/compare/7.24.02.18...7.24.10.10