Mark Freemn

My feedback

  1. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
  2. 61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn supported this idea  · 
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Freemn commented  · 

    Yes, we have can't/won't fix queries that cause the scaling of the bars for every other query in a chart to be smashed down into a sliver at the bottom of the chart.

    Of course there are also "fix is in progress in dev" queries that I want to filter out temporarily. So having the ability to toggle between full and filtered view would be great, with the ability to add a query to a black list much like the list of watched queries.

  4. 6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn supported this idea  · 
  5. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Freemn commented  · 

    If you right-click on the query plan and select Properties, you can find the query_hash there. You can then look up the query_hash using sys.query_store_query joined to sys.query_store_query_text) to get the full SQL statement instead of the truncated version stored with the plan.

    Query Store could do that itself when you edit query, but then it would need to have Edit query do something different when viewing a plan in the Query Store UI than when looking at any other plan. Still, they could try that everywhere if Query Store is enabled and only show the truncated plan if no plan is found in Query Store.

  6. 7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn supported this idea  · 
  7. 253 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn supported this idea  · 
  8. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Freemn commented  · 

    It also seems weird that we can set the MAXSIZE for a user database from master (using an ALTER DATABASE statement), but cannot see the current value from there.

    Mark Freemn shared this idea  · 
  9. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn shared this idea  · 
  10. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn supported this idea  · 
  11. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Freemn commented  · 

    The notification feature was completely removed. Now you have to create your own process (documented at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning-email-notifications) using PowerShell, an Azure Automation Runbook, and Microsoft Flow. This is unacceptably complex.

  12. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn shared this idea  · 
  13. 72 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn supported this idea  · 
  14. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Freemn commented  · 

    Be sure to incorporate this into "SQL Server Managed Backup" as well.

    Mark Freemn supported this idea  · 
  15. 60 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Freemn commented  · 

    Kalen Delaney found that Microsoft just needs to add a few system functions (that are in SQL Server but not in Azure SQL Database) and remove the code that generates that exception for Azure SQL Database. If it's really that easy, why can't Microsoft just do this?

    Mark Freemn supported this idea  · 
  16. 153 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freemn supported this idea  · 

Feedback and Knowledge Base