SQL Code Guard

Want new features or analysis rules? Add them and vote them up here!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. When opening database object (e.g. View, Proc...) from the tool, please change "CREATE " TO "ALTER " as we always want to alter it.

    When opening database object (e.g. View, Proc...) from the tool, please change "CREATE " TO "ALTER " as we always want to alter it.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Export all results to csv file or txt file.

      Export all results to csv file or txt file.

      2 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Support for Visual Studio Database Projects

        I would love to see support for SQL Server Data Tools (SSDT) Database Projects so that developers can check and correct while building locally either through triggering a local build and perhaps also manually through the menu.

        I'm thinking about functionality like the StyleCop extension in visual studio for example.

        3 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • SQL Code Guard and Sonarqube Plugin

          Can you please provide us a plugin to integrate SQL Code Guard and Sonarqube for static code analysis.
          There is a plugin in the market (http://www.techcognia.com/TSQL.aspx), but we faced some challenges. So it would be great if it could come perfectly tested and approved via RedGate.

          3 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Table Check and Naming conventions

            1. Tables missing Primary Keys.
            2. Tables missing Primary Index.
            3. Naming conventions standards like
            a. SP to being with usp_.
            b. Function to begin with fn_.
            c. All reserved Keywords to be uppercased.
            d. Index names.
            4. Procedure, function or Trigger without SET NOCOUNT ON.

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • New rule for checking BULK INSERT

              Make sure BULK INSERT statements always have the MAXERRORS = 0 option set; the default being 10 errors which we obviously don’t want!

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • New rule for checking cursors

                Make sure cursor runs over a temporary table/table-valued variable only and not a normal table; primarily to prevent schema-stability locks that in turn block partition operations.

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Run Individual Test

                  I would like the option to run the tests via something like Pester, and have the option to run a sub set of test when needed.

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • I would like SQL Code Guard to work with Sonarqube

                    I would like it so that the rules in code guard can be called by Sonarqube so we can analyse our app code as well as our database code.

                    4 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                    • Make SQL Code Guard work on SSMS 17

                      I would like to use SQL Code Guard on SQL Server Management Studio v17.

                      7 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Don't see your idea?

                      SQL Code Guard

                      Feedback and Knowledge Base