SQL Database

  1. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Fix shema issue recommendation for 'invalid_column' is useless without the column. Please fix.

    Right now the 'invalid_column' recommendation doesn't show the table or the column that's at issue making it virtually impossible to tell what's actually wrong especially when deploying to production environments correctly with batched SQL changes in tools like entity framework or Red Gate etc.

    Please fix this to add the table and column that's the issue.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. Shared query store for elastic scale

    We use elastic scale to shard our database. It works in multi-tenancy model and each database share the same data schema, views. We noticed than when we move some tenants to newly created shard, azure sql uses inefficient execution plans. It takes some time till statistics are gathered. That'd be great if all shard used same store for statistics so same query executed on each shard uses same execution plan.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. Increase 'Request limit' for P1 databases

    We are constantly hitting the the 200 'request limit' for our P1 database - due to a very chatty workload, that we don't have much control over.

    Even though database utilisation is normally quite low - 30%.

    There is no easy workaround for this limit - and upgrading to a P2 seems massively over-spec as the database would likely be sitting at just 15% utilisation or less.

    We'd even be willing to pay a little bit more to increase the request limit.

    We really feel backed into a corner here - with no option other than doubling our costs to…

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow OPENJSON to match to property names while ignoring case

    Some json serializers change the case of property names from pascal case to camel case while others don't. Some have options to do one or the other. When passing in json data from outside sources, it would be nice if we didn't have worry about matching the case.

    If this syntax or similar worked without having to match case, it would be very helpful:

    -- image this was passed in through a proc parameter
    DECLARE @json VARCHAR(MAX) = N'[
    { "id": 1, "name": "Bob" },
    { "id": 2, "name": "Carl" } ]';

    SELECT ID,
    [Name]
    FROM OPENJSON(@json)
    WITH (
    ID…

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. New Pricing Tiers - X Small Databases

    I think current Basic Elastic 50 and Single Database are still expensive for small databases, currently I have got 7 databases, size together 200MB. How can be the Basic for ~$74.40/mo and pool 5GB good for this?

    Currently I am paying them as Single Databases but it is also expensive as my databases will never get 2GB.

    You could create additional Tiers for Single Databases of max size 100MB and 500MB and Elastic Pool could be indeed also 1GB or 2 GB.

    Similar requests were closed as Completed

    https://feedback.azure.com/forums/217321-sql-database/suggestions/4908333-sql-azure-more-scalable-pricing-for-multiple-smal

    https://feedback.azure.com/forums/217321-sql-database/suggestions/9908991-add-extra-small-elastic-database-pool

    I can see the advantage of Basic 50 Elastic Pool…

    23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Need to be able to see % complete of a COPY

    We had a COPY take an unusually long time during a go-live ( of course ). It was frustrating that we had no way to tell how the copy was proceeding. The view sys.dmoperationstatus is only good for seeing that there is a copy in progress, but it does not provide any other useful information.

    Therefore, we need this view to be more useful AND/OR be able to see 'in progress COPY info' in the portal. The activity log is useless for this - it only shows the start.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. API to check remaining DTU limit of a server

    Can we have an API to get remaining DTU limit of a server? This will be useful to know if a given logical server has hit the limit of 45000 DTUs.

    15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. SQL Database, Overview blade, Monitoring Graph - provide option so Y-axis can be fixed from 0-100% DTU Percentage!

    The Azure Portal was changed over the last weekend of May 2017, to make the Y-axis of the Monitoring graph only go as high as needed to show the maximum DTU Percentage used during the displayed period.

    Prior to that weekend, the Y-axis of the Monitoring graph was always scaled from 0 to 100% DTU Percentage.
    This allowed us to see how busy our DBs were with just a glance.
    With the change mentioned above, we have to look much more closely now at the scale of the Y-axis, in order to determine the real DB load.
    This would seem…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. reduce the lag when connect to the database

    reduce the lag when connect to the database, it is very slow when using management studio to connect to database,i need to take 10 seconds to expand the database table, moreover, when i use my visual studio and debug , it always have underlying on open error when trying to use entities to connect

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Proper CSV import/export support (and NO, it doesn't currently exist)

    Importing from CSV is a royal PITA, as SQL Server doesn't support quoted and escaped columns. Good luck importing data if it has commas in it. Any delimiter you choose will likely be included in some column and ***** things up. Importing data into MySql, Postgres, Redshift etc etc is soooooo much easier

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. Implement FILESTREAM for blobs into Azure Blob Store

    Storing blobs in the database is fairly pointless when you have a dedicated blob store. Implement the FILESTREAM protocol to store blobs in a user's azure storage

    927 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    19 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. bacpac

    Restoring BAK instead of BACPAC file by mistake does not error out and takes hours. Suggest to add file format validation logic at the SQL DB import layer.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. Renaming stored procedure bug

    When renaming a Stored Procedure from "spFoo1" to "spFoo2" via SSMS Object Explorer, I've noticed that the name of the
    stored procedure name is still "spFoo1" in the [sys].[sp_helptext] 'spFoo2'. I haven't tested this for functions, etc. This causes big confusion if multiple people are going through the code with tools such as RedGate and aren't aware of the change or issue and are just going with the name. It may be good to have the option to validate that the stored proc code compiles and rollback the rename if it can't.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. Make target service objective for scaling operation available via SQL tables/views

    Target service objective was available in slodatabaseobjectives in V11, but it not available in V12.
    This makes admin tasks harder.

    30 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. create free sql database

    I have some little projects, demos to show during my speeches. I saw on the past an option to create a free database on SQL limited by 20MB. Where is it? It will be great if you allow us as developers to use sql, mysql, postgresql with a free option!

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. Simple Calculator DTU

    Please provide a scenario DTU calculator.

    I know that it is very difficult to tell the amount of DTU needed for each one, but it would be possible for azure to offer a calculator that allows you to calculate based on a scenario already experienced by the azure team.

    Example:
    A scenario where only the employees of the company will use, with X specifications and not very complex queries etc. Being on average Y simultaneous employees on average, and other features, if they want to leave well specified.

    Based on an entire scenario mounted by azure, we would know how…

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Deleting an Azure SQL Database incorrectly indicates that it is irreversible

    Recently, the Azure Portal was updated to ask for the database name when deleting a database, instead of just asking for a Yes/No confirmation. This is a good move, but the text on the dialog indicates that "Deleting <database name> is irreversible. The action you're about to take can't be undone. Going further will delete it and all the items in it permanently."
    While that's technically true, Azure SQL Database can be restored after they are deleted from their server's Deleted databases pane.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base