Johan Bennink

My feedback

  1. 1 vote
    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 →

    Upvotes: 2

    <=-=Jul 4 2008 2:20AM=-=>

    The ANSI Standard defines a default on a column as a column attribute. For some reason MS have implemented this as a constraint – would be nice to support the ANSI Standard.. in fact from the ansi standard (SQL-92)..

    11.12

    Function Change a column and its definition. Format ::= ALTER [ COLUMN ] ::=

    Something that SQL Server does not support.

    <=-=Jul 10 2008 6:28PM=-=>

    Hello,

    Thank you for the suggestion on handling the default values. We will consider your feedback for the next release of SQL Server. This feedback item will remain open until the decision to implement (or to not implement) is made.

    Thank you,
    Boris.

    <=-=Jul 23 2008 5:46AM=-=>

    Hi Boris,

    Thank-you for the update.

    <=-=Aug 14 2008 1:37AM=-=>

    It would be good to get a consistant state between CE Edition, Enterprise/Dev etc. As CE Edition already supports the …

    Johan Bennink supported this idea  · 
  2. 634 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  25 comments  ·  API Management » API management experience  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  3. 33 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 →
    Johan Bennink commented  · 

    I'm out of votes but I support this. UTC just does not work for many realtime scenario's

  4. 67 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink commented  · 

    Isn't this something like Resource Governor for onpremise SQL Server?

  5. 100 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink commented  · 

    I'm out of votes but I like this idea.

  6. 137 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  6 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink commented  · 

    Could be made similar to Take offline for a database

  7. 19 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 →
    Johan Bennink commented  · 

    I'm out of Votes but I like this idea. Elastic should mean the pool takes care of spreading the wealth. Put 4 database in a pool with 50DTU and if all 4 go to town they automatically get a max of 50/4. If You set a max on 1 database (ie 10) it would get 10 and the rest (unrestricted) divide the remaining DTU's (40/3). If 1 database is hard at work and 3 do almost nothing proportional to their work they would divide the 50DTU (also taking care of the set limits per database both upper and lower DTU bounds. That's elastic for you...

  8. 41 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 →
    Johan Bennink supported this idea  · 
  9. 24 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 →
    Johan Bennink commented  · 

    What performance do you need? For tables that small you could get a basic single database (5DTU) for about EUR 4,21 (so 7 database would total EUR 29.46). Or if you don't need DTU's you could put all 200MB data in one database with schema separation. It makes it harder for the developer and blends apps/data together but consolidating every thing for EUR 4.21 a month :-)
    I would also ask whether you need an actual SQL Database.

    Also I like the optimistic answer @Guy gave on the second link you provide. This is what Microsoft wants. Yes we give you what you want...but don't ask what you will pay for it.
    You have to get creative if you don't want to spend the money.

    P.S. I'm trying to **** you around, I have the same problem but I do get why Microsoft is doing it. They are in it to make money and lot's of it.

  10. 13 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 →
    Johan Bennink commented  · 

    I noticed this UTC0 "issue" myself. It's funny that a simple thing like this was overlooked for sql-server. Would it be that hard to add a property on the Azure portal for Azure SQL Database to set a current timezone.

    Johan Bennink supported this idea  · 
  11. 31 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 →
    Johan Bennink supported this idea  · 
  12. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  API Management » Policies  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  13. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  API Management » Policies  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  14. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  API Management  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  15. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  API Management » Security  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  16. 7,230 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    192 comments  ·  Web Apps  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  17. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Networking » Virtual Networks (VNET)  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  18. 33 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Networking » Virtual Networks (VNET)  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  19. 24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Networking » Virtual Networks (VNET)  ·  Flag idea as inappropriate…  ·  Admin →
    Johan Bennink supported this idea  · 
  20. 954 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Johan Bennink supported this idea  · 
← Previous 1

Feedback and Knowledge Base