Prerequisites to run SQL Nexus
- .NET framework 4.8 (runtime is sufficient). Windows 11 has version already.
- Download and install RML Utilities (RMLSetup_AMD64.msi)
- An instance of SQL Server (versions 2012 through 2022) to connect to and process data
- 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
- 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.
- Extract in a path location of your choice
- 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
- 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