BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ
News Articles Presentations Podcasts Guides

Topics

Choose your language

QCon New York

Find real-world practical inspiration from the world’s most innovative software leaders. Attend in-person.
QCon San Francisco

Learn what's next in software from world-class leaders pushing the boundaries. Attend in-person or get video-only pass to recordings.
The Software Architects' Newsletter

Your monthly guide to all the topics, technologies and techniques that every professional needs to know about. Subscribe for free.

InfoQ Homepage News SQL Enlight T-SQL Analyzer

Building an Efficient Cloud Application Architecture (Live Webinar June 22, 2023) - Save Your Seat

SQL Enlight T-SQL Analyzer

This item in japanese

Bookmarks

Apr 29, 2009 1 min read

Write for InfoQ

Join a community of experts. Increase your visibility.
Grow your career.Learn more

Ubitsoft has released a new version of SQL Enlight, their tool designed to expedite and facilitate T-SQL development. SQL Enlight provides code convention verification and coding standards enforcement similar to tools like StyleCop/FxCop; it also provides design-time analysis and templating similar to ReSharper or CodeRush. SQL Enlight integrates into MS Visual Studio and SQL Management Studio, and SQL Englight also provides a command line interface and MSBuild tasks to generate XML reports of analysis rule violations.

SQL Enlight has following features:

  • Reformat T-SQL code with set of customizable rules
    • Formatting rules can be grouped into layout templates that can be switched between as desired.
  • Analyze T-SQL code using set of static analysis rules
    • The Analysis Script feature can be used to identify common performance and database objects naming problems in the T-SQL code.
  • Summarize T-SQL script
    • Similar to the Class Viewer, Transact-SQL Script Summary can help the developers and database administrators to identify components of long SQL scripts. The Script Summary provides a hierarchically structured summary of all batches and statements in the current T-SQL script.
  • Refactoring - Encapsulate T-SQL script as stored procedure or function
  • Transact-SQL statements outlining
    • The statements outlining feature surrounds each statement in the T-SQL script with outlining rectangle, similar to regions in .NET code.
  • Validate T-SQL syntax
    • Code editor highlighting of T-SQL syntax errors.

Rate this Article

Adoption
Style

This content is in the Microsoft topic

Related Topics:

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

BT