How can we improve Azure SQL Database?

Allow data compression (to improve size/performance)

Allowing data compression would make it easier to fit within a 1GB/10GB limit and help improve I/O performance on large datasets, not to mention it helps with T-SQL/SQL Server compatibility.

84 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    anonymousanonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Ryan LamanskyRyan Lamansky commented  ·   ·  Flag as inappropriate

        In the older storage-centric pricing model, I can see why this would be blocked (to conserve CPU time), but with new model which limits our CPU usage, reckless use of DATA_COMPRESSION (and other features) isn't going to hurt other users. Savvy developers have who have a low CPU % database can save a lot of space and potentially reduce I/O load.

      • Anonymous commented  ·   ·  Flag as inappropriate

        in addition this will help schema migration: no need to use a tool or syntax to strip ou tthe syntax related to compression

      Feedback and Knowledge Base