Settings and activity

  1. 5 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 » User interface  ·  Flag idea as inappropriate…  ·  Admin →
    WesH shared this idea  · 
  2. 34 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  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    WesH supported this idea  · 
  3. 66 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  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    WesH supported this idea  · 
    An error occurred while saving the comment
    WesH commented  · 

    Could we have it auto-generate a name? I definitely agree we should not need to free-hand type the name every time.

    I would like to configure a naming sequence for each object in the pipeline. For example: if my last acknowledged Development drift was 1.2.1, I'd like the next one to be 1.2.2.

  4. 157 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →
    WesH supported this idea  · 
  5. 12 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 » Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    WesH commented  · 

    This would be handy, especially when used in conjunction with encapsulating as a CTE. As always, we would need a naming convention configuration screen to define how the aliases are created.

    My preference:
    Sum(ColA) as SumColA
    IsNull(ColA,'Something') as ColA
    IsNull(ColA,ColB) [no suggestion]

    WesH supported this idea  · 
  6. 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

    4 comments  ·  SQL Prompt » Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
  7. 158 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    WesH commented  · 

    @Jonathan
    I would like to align my TFS branches with the pipeline. I would hope to see these different states:
    1. databases matches source control and DLM,
    2. database does not match DLM or source control
    3. database matches DLM, but not source control
    4. database matches source control, but not DLM (configurable for auto acknowledge DLM)
    5. all three are different, database, DLM and source control

    If an un-acknowleged database drift matches the current version of the branch, automatically acknowledge the drift changes with the build date as comments.

    WesH supported this idea  · 
  8. 35 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  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    WesH commented  · 

    The DDL trigger needs a very quick destination or it will slow down activity on your servers. This sounds like you'd be trying to capture the DDL over a linked server. Having the RedGate database on the monitored server minimizes the impact to that server.

    However, maybe RedGate could implement a passive monitoring strategy that requires the monitoring server to retrieve all of the metadata for all of the objects in a database. Although that would be a massive result set to compare, if it only happened nightly, it might be feasible. However, on my servers, the performance impact during the compare would be far worse than the minimal impact of the DLD triggers.

  9. 141 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  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    WesH supported this idea  · 
  10. 12 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  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    WesH commented  · 

    As I understand it, the DDL triggers only fire when a DDL statement is run. That should be very minimal overhead especially since you mention you don't have a lot of changes. When that trigger fires, it inserts the RedGate database. That database is polled by the DLM Dashboard.

    It sounds to me like your suggestion would have every database polled for all object metadata each interval. Unless I'm misunderstanding your suggestion, I think that would be significantly more overhead.

  11. 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 →
    WesH supported this idea  · 
  12. 80 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 » Find unused variables  ·  Flag idea as inappropriate…  ·  Admin →
    WesH supported this idea  · 
  13. 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 →
    WesH supported this idea  ·