How can we help you today? How can we help you today?

NEW- Improving legacy code using SQL Prompt code analysis

Hi Friends,

Update: This feature is now available in SQL Prompt 9.2. You can download it here. 

A new feature is coming soon in SQL Prompt that will allow you to perform code reviews or analyze a legacy code base.

Currently, SQL Prompt performs static code analysis on your T-SQL code, as you type it into a query window in SSMS or Visual Studio by highlighting each 'code smell'. 

This approach is great for new code, but becomes a little cumbersome when dealing with legacy code and longer scripts, during code reviews and refactoring efforts, as you must scroll through the whole script, keeping an eye out for the each of the elusive green underlines. 

SQL Prompt 9.2, and later, will extend the code analysis feature to include a list of code analysis issues, designed to make it much easier to analyze and improve legacy code. It allows users to analyze an entire script, no matter how large, and see a list of all the issues contained within it. You will be able to group the issues by type - to focus on a particular category or export them and share with the team. 

This feature will be released very soon and we'd love to hear your feedback when you try it. 

Thanks,
Natali





NataliS
0

Comments

5 comments

Sort by
  • ben_b
    Hi Natali.  I just tried this feature and really like it.

    If I setup my panes as below, is there a way to get the 'Issue Details' tab to dynamically update as I click through the exceptions in the 'List of Code Analysis Issues' tab.  At the moment, I have to click back into the main query editor, hover over until I get the blue exclamation and click on that (or press control).  very minor issue but this is the first script I looked at there were 148 discovered issues so would be a nice to have to quickly review these.

    cheers
    Ben

    ben_b
    0
  • NataliS
    Hi Ben, thanks for your feedback. 

    This is a feature the team is currently looking into and hopefully should be implemented soon. I'll update you once that's available.

    Thanks,
    Natali
    NataliS
    0
  • NataliS
    Hi @ben_b, the above feature is now available in the latest version of SQL Prompt 

    Thanks,
    Natali
    NataliS
    0
  • ben_b
    Yep all working!!
    ben_b
    0
  • chrisleonard
    This sounds very interesting - I will check my SQL Prompt version tomorrow at work!
    chrisleonard
    0

Add comment

Please sign in to leave a comment.