Settings and activity

  1. 108 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    28 comments  ·  SQL Prompt » Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    With SQL Code Guard no longer a viable product, and its functionality re rules is now within SQL Prompt, isn't this a compelling argument for BOTH "Format all Files" AND " Run Code Analysis using <this> set of Rules". For compliance, we will have to do this, and we are now, FOUR YEARS ON from my original post, at 6,792 SQL Modules. Utterly untenable as a manual task. Please, BUMP THIS UP THE FEATURE STACK A.S.A.P., with thanks.

    Stephen supported this idea  · 
    Stephen shared this idea  · 
  2. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Prompt » Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen shared this idea  · 
  3. 13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Prompt » Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen supported this idea  · 
  4. 21 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Prompt » Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen supported this idea  · 
  5. 13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Prompt » Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen supported this idea  · 
  6. 30 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  SQL Prompt » Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    If the generated definition could include NOT NULL as appropriate, as against the SELECT INTO making every column NULL, that would help a lot.

    Stephen supported this idea  · 
  7. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Prompt  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    Thanks for the query, Daniel. Very helpful in detecting objects with now-non-existent object references, and inefficient scalar-function usages. Worth the 42 seconds it takes to run.

    Cheers!

  8. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Prompt » Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen supported this idea  · 
  9. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    I'd appreciate the RECOMPARE, too. Wouldn't necessarily always want source AND static data recompared, so if that could be an option, please.

    Stephen supported this idea  · 
  10. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    Drop down would be a good start. It would also help if we could swap servers, too. I have three distinct products with servers located in three distant states, each with their own SVN repository, so changing to a connected server AND database attracts my remaining 1 vote.

    I TOTALLY agree with Ludvig's comment about preventing interference with multitasking. SQL Search, SC, SSMS query editors, et al, should all be, as it were, in their own protected environment, if MS makes that possible, of course...

    Stephen supported this idea  · 
  11. 41 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Prompt  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    Long wanted this simple Diff capability. Have to, like Ludvig, save to files and use Notepad++'s Compare Add-in. There's a Diff detector in SQL Compare and Source Control - how hard could it be to port as an add-in, especially now you have the framework in place in SSMS...?

    Stephen supported this idea  · 
  12. 146 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  SQL Search  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen supported this idea  · 
  13. 50 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL Search » Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen supported this idea  · 
    An error occurred while saving the comment
    Stephen commented  · 

    Another scenario, possibly: SQL Multi Script enables definition of a set of servers in a "family". I have three different sets defined for each nigh on completely distinct application. Would you consider extending "defined server groups" into SQL Search so that when we have selected particular databases for our search and switch to another server in the same group, DON'T swap to the default database, DO perform the same search on the same set of selected databases, bypassing any databases(s) not yet on, for example, QA or Production. I frequently want to see a Search on databases A and B on Dev, then compare that against either QA or Production for the same databases, but as my default is always master, must go about selecting db's again. Any chance you'd consider this, RG? You very kindly whacked the advert banner for paying customers, so you could probably make this a paid-customer-only feature... Thanks for any consideration.

  14. 17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL Source Control » History/Log  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    This is also VERY applicable to the OnTime integration with SVN where at checkin, an additional ticket-search control is added to the standard TortoiseSVN UI.

    We are prevented from adopting OnTime due to the lack of any ability to inform OnTime of a commit or be able to look up ticket numbers via some SSC integration.

  15. 45 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Prompt » Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    Does this VS Gallery replacement fit the bill for the untabify need? http://visualstudiogallery.msdn.microsoft.com/f5d2ff29-cf19-4762-b4cc-01cefbbbb471

  16. 128 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  20 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    +1 for UDFs and triggers, not just SPs, please.

  17. 45 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Stephen supported this idea  · 
  18. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    For those with huge numbers of either databases or objects, please consider this an OPTION, RG. Thanks.

  19. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Prompt  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    Up to SQL2008R2 use the free http://www.ssmstoolspack.com/ and you can script a resultset to INSERTs and search it, too. SQL2012 = $$$

  20. 102 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    25 comments  ·  SQL Prompt  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen commented  · 

    With SSMS Tools package migrated to a pay-to-use item for SQL2012, perhaps there's more impetus behind Red Gate adding this feature. Please...

← Previous 1