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

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

Note: Starting this version 7.27.02.18, it's no longer required to install SQLSysClrTypes and ReportViewer Control. These come packaged with 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.02.18_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