Development Environment:

1. Visual Studio 2015/2017
2. Report Builder 2016

Prerequisites to run SQL Nexus

1. .NET framework 4.6.2. Windows 10 anniversary update has version already.
2. Download and install SQLSysClrTypes
3. Download and install ReportViewer control (ReportViewer.msi)
4. Download and install RML Utilities (RMLSetup_AMD64.msi)
5. An instance of SQL Server (2012 or above) to connect to and process data
6. 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

1. Download the SQLNexus_v_7_21_07_07.EXE (this is a digitally signed self-extracting zip file by Microsoft)
2. Double-click on it to allow files to be extracted in a path location of your choice
3. 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
4. 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