Ian Bennett

My feedback

  1. 265 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 8

    <=-=Mar 5 2017 2:42PM=-=>

    Thanks for this idea. This is a valid requirement and I hope that it will get more votes. Currently we cannot confirm when it will be added, but it is in our backlog.

    <=-=May 22 2017 5:03AM=-=>

    would like it very much, particularly since you already have the CONCAT / GREATEST() a variable number of paramenters and does something with it…

    <=-=Jun 5 2017 12:31PM=-=>

    GREATEST / LEAST functions would be fantastic addition.

    <=-=Nov 14 2017 3:42PM=-=>

    The workarounds using CROSS APPLY or CASE expressions are difficult to manage and read. I’d love to see these implemented.

    Ian Bennett supported this idea  · 
  2. 37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  API Management » Policies  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett supported this idea  · 
  3. 125 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  4 comments  ·  API Management » Security  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett supported this idea  · 
  4. 47 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  5 comments  ·  API Management » Pricing  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett commented  · 

    @Andrew, OAuth is fine if you don't want to provide any user functionality such as per API security, self-service, per user monitoring etc. To do that, you have to either pay a fortune or get your internal users to sign up with personal microsoft accounts which is a bit tacky.

    Ian Bennett shared this idea  · 
  5. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Azure IoT  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett supported this idea  · 
  6. 49 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett commented  · 

    In regards to the Lambda Architecture, that is sort of what I have done but more simply and cheaper by just creating a second Cosmos collection with a TTL setting of a few days only. I write to this and the long term collection simultaneously. Using database level RU allocation I can efficiently utilise RU between the short term collection which is mainly queried adhoc during the day and the long term collection which is mainly queried in batch overnight.

    Ian Bennett commented  · 

    My partition keys are GUIDs in order to evenly distribute eclectic data over the partitions. I therefore do not know the keys upfront and "DISTINCT partitionKey" is of no use.

    Ian Bennett commented  · 

    Also, it looks like the node.js SDK does not support passing of partition keys when executing a stored procedure.

    Ian Bennett shared this idea  · 
  7. 89 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Web Apps  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Ibrahim,

    What issue are you trying to solve? What use case would this be used for?

    It seems to me that placing a restart option on the plan level might do more harm than good, by resetting the memory on all the apps under the plan. Depending on your scenario, auto-heal would be a great solution to solve individual machine issues. See a video by my colleagues here for more details: https://channel9.msdn.com/Series/Windows-Azure-Web-Sites-Tutorials/Auto-Healing-an-Azure-App-Service

    Placing this idea under review for now until I understand what’s at the base of the request here.

    Thanks!
    Oded

    Ian Bennett supported this idea  · 
    Ian Bennett commented  · 

    There are some services that appear to be App Service Plan based and if broken, cannot be resolved by restarting at the App Service level. For example, MSI (Identity) which was apparently a VM plugin (there appears to have been major changes to MSI so not sure if this is still the case). Also I am having problems with Always On across all of my App Services (i.e. it has stopped working) so I suspect this may be another case.

  8. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Logic Apps » Management  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett commented  · 

    Agree that there needs to be some way to organise related Logic Apps. I have to use 3 Logic Apps just for overnight scheduling of lights at one site (1 to turn lights on, 1 to dim at a later time, 1 to turn off). If I am to roll this out in ernest I would likely end up with thousands of Logic Apps which will be a nightmare to manage, so am having to look at other solutions.

    Ian Bennett supported this idea  · 
  9. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Time Series Insights » General  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett shared this idea  · 
  10. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Web Apps  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett shared this idea  · 
  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Active Directory » Licensing  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett shared this idea  · 
  12. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Web Apps » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett shared this idea  · 
  13. 7,845 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    201 comments  ·  Web Apps  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett supported this idea  · 
  14. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Web Apps » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett shared this idea  · 
  15. 638 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    30 comments  ·  Azure Cosmos DB » Gremlin API  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett supported this idea  · 
  16. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Azure Cosmos DB » Other  ·  Flag idea as inappropriate…  ·  Admin →

    @Ian.

    With regards to secondary regions having different RU/s we do not have this on our road map at this time. There is another User Voice items which have this suggestion, Please feel free to vote that item up.

    @Nick.

    For scenario 1. Same answer.

    For scenario 2. Typically, just putting the front-end closer to users is not something we see help with application latency where they are backed by a database as the app still needs to call the database which is still separated by some distance.

    With regards to knowing which region to point to I would suggest conducting tests to see which regions provide the best latency and include this as the preferred regions for each regional deployment.

    Thank you both for your suggestion and comments.

    Ian Bennett commented  · 

    The replica is setup more for DR purposes but there is no option to run the secondary at reduced RUs so that is potentially a lot of wasted resource and money. If I am using something like Power BI Service then I don't get a lot of say in where the application runs from. You are assuming a 3 Tier Architecture but Cosmos is not just being used for apps and websites. Data Analytics applications are often 2 Tier and more taxing on the database.

    Ian Bennett shared this idea  · 
  17. 14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Azure Cosmos DB » Portal  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett commented  · 

    By "monitor" I mean individual queries and the focus on this suggestion was actually meant to be on the "killing" part. Its not hard to end up with rogue queries chewing up the RUs.

    Ian Bennett shared this idea  · 
  18. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Storage » Storage Explorer  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett shared this idea  · 
  19. 22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Logic Apps » Connectors  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett commented  · 

    A trigger based on "Number of requests exceeded capacity" metric would be useful too. Logic flow might look something like if number of requests exceeds capacity > n then increase RU throughput by 10% with a maximum of x RUs.

    Ian Bennett shared this idea  · 
  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure IoT  ·  Flag idea as inappropriate…  ·  Admin →
    Ian Bennett shared this idea  · 
← Previous 1 3

Feedback and Knowledge Base