SQL Nexus 7.21.07.07
Development Environment:
- Visual Studio 2015/2017
- Report Builder 2016
Prerequisites to run SQL Nexus
- .NET framework 4.6.2. Windows 10 anniversary update has version already.
- Download and install SQLSysClrTypes
- Download and install ReportViewer control (ReportViewer.msi)
- Download and install RML Utilities (RMLSetup_AMD64.msi)
- An instance of SQL Server (2012 or above) 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
How to Use
- Download the SQLNexus_v_7_21_07_07.EXE (this is a digitally signed self-extracting zip file by Microsoft)
- Double-click on it to allow files to be extracted in a path location of your choice
- You will now see a SQLNexus_v_7_21_03_26.zip file which you can extract into a subfolder, e.g. \SQLNexus_v_7_21_03_26
- Go to the new subfolder and execute sqlnexus.exe
Fix List:
- Fixing exception when a DLL component missing
- Fixing issue where not all rowset rows were importing succesfully
- Fixed issues with backslashes in command line parameters for SQL Nexus
- Added a new rowset tbl_Query_Execution_Memory_MemScript
- Added the ability to import SQL LogScout-collected traces
- Adding a new rowset definition for tbl_server_times
- Fixing issue where DataReader remained open/not properly disposed
- Fixing Perfstatsanalysis.sql where scheduler table was incorrect
- Cleaning up and improving performance for Batch parser logic for "GO" separator