9.0.10.4053 - February 15th 2018

Fixes

• SP-6800 : Fix alignment for chaining methods.
• SP-6806 : NullReference exception during execution of EI020/021.
• SP-6808 : Fix missing newline after ON while formatting filegroup indexes.
• SP-6826 : SET ANSI NULL ON removal has a huge impact on users performance, so we don't show this error.
• SP-6832 : Fixed issue with Redgate licensing client.

Note: Hotfixed original build 9.0.10.4036 released on February 14th 2018 due to licensing issues.

9.0.9.3951 - February 7th 2018

Fixes

• SP-6772 : Add support for UNPIVOT, fixes space being removed incorrectly.

• SP-6789 : Fix missing method (ScriptAndResultsEditorControl.get_ConnectionInfoList()) exception in SSMS 2016 13.0.15000.23.

• SP-6791 : Fix formatting CASE statements with a negative WHEN clause.

• SP-6803, SP-6804 : 'Encapsulate as New Stored Procedure' and 'Smart Rename' no longer complain about invalid or missing ActiproSoftware DLLs.

9.0.8.3873 - January 31st 2018

Features

• Code analysis now supports larger scripts without freezing the SSMS/VS UI.
  • Limitation: Only the first 50,000 issues of code analysis are shown.

Fixes

• SP-6731 : Do not show ST010 issue for CTE.
• SP-6748 : PE010 shouldn't be triggered on a SELECT INTO statement.
• SP-6761 : Don't detect BP014 issue on computed non persisted columns.
• SP-6766 : BP014 Shouldn't apply to identity columns.
• SP-6777 : "Place expressions on new line" under THEN expressions moves ELSE expression.

9.0.7.3692 - January 17th 2018

Fixes

• SP-6729 : Fix code analysis hover information hiding Prompt object definition tooltip.
• SP-6763 : Stop adding square brackets around CONCAT_WS/TRIM/TRANSLATE/STRING_AGG functions.
• SP-6751 : Prevent alias being reported as unqualified column name by rule MI003.
• SP-6790 : Could not load file or assembly 'ActiproSoftware.WinUICore.Net20'.

9.0.6.3580 - January 10th 2018

Features

• Code Analysis is now available when upgrading to SQL Prompt Pro from the Core Edition.

Fixes

• SP-6737 : Apply column alias style breaks script if using both old and new styles.
• SP-6774 : Fix incorrect message when user invokes 'find invalid objects' with code suggestions disabled.

9.0.5.3501 - January 3rd 2018

Features

• Snippet placeholders can now be cycled (Tab: next, Shift-Tab: previous) as well as moved forward but stopping after the last one (Enter). Esc cancels the session.
  • For example, for the built-in cuni snippet, if we have the second placeholder ($column$) selected, we can navigate as follows:
    
  • If we have the third and last one ($index_name$), our navigation options become:
    

Fixes

• Wrong border was being applied to the active placeholder when editing a snippet in the script window.

9.0.4.3408 - December 20th 2017

Fixes

• SP-6704 : Fix incorrect vertical alignment with 'SELECT DISTINCT' and column list.
• SP-6724 : BP017 and BP018 shouldn't consider inner join as an issue.
• SP-6736 : MI003 'Unqualified column name' shouldn't flag up for 'OUTPUT INTO'.
• SP-6738 : PE002 should not be shown for the creation of #indexes on #tables.
• SP-6752 : Fix SQL Prompt interference with SSDT builds.

9.0.3.3299 - December 13th 2017

Fixes

• SP-6558 : GROUP BY suggestion "All non-aggregate columns" breaks query.
• SP-6705 : All non-aggregated columns' misbehaving after 'Group By'.
• SP-6728 : Prevent showing code analysis BP006 (TOP without ORDER BY) for TOP 0.
• SP-6730 : Prevent wrong assembly loading.

9.0.2.3223 - December 6th 2017

Fixes

• SP-6721 : Fixed several hyperlinks to online documentation in SQL Prompt UI.
• SP-6692 : Insert semicolons before WITH clause.
• SP-6703 : Fix unqualified column name issue detection for the CONTAINSTABLE function.
• SP-6715 : Missing space in alias definition.
• SP-6708 : XML Data Type Method reported as UDF

9.0.1.3179 - November 29th 2017

Features

• Added 25 new code analysis rules, bringing the total to 88:
  • BP006, BP011, BP016, DEP002, DEP007, DEP009, DEP012, DEP014, DEP019, DEP026, EI003, EI024, EI029, MI001, MI006, PE001, PE006, PE011, PE016, PE019, PE021, SC005, ST001, ST003, ST007.

Fixes

• Fixed occasional crash when opening "Manage code analysis rules..." window.
• SP-6709 : Fixed OutOfMemory exceptions that could occur when processing large scripts.
• SP-6679 : Removed additional space after SELECT when using only tabs.

9.0.0.3116 - November 21st 2017

Features

• Added code analysis feature that provides fast and comprehensive static code analysis of T-Sql code and allows users to:
  
  
  • Discover 60+ code issues and hidden pitfalls as-you-type:
    
    
    
    
  • Have clear explanations and suggestions to improve the code:
    
    
    
    
  • Choose from a large selection of analysis rules: