SQL Database

  1. Defect: Server name is already used

    Defect:

    I created a new server and new database in Azure SQL. I had to delete that server and now I am trying to create server with same name. But it says that server name is already used. I could also reproduce same scenario.

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. sp_msforeachdb for Azure Database

    SQL Server 2008 through 2016 had this undocumented stored procedure which allowed the DBA's to execute a certain task/script on multiple database at one shot but with Azure database/logical server this stored procedure is no more available.

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Enable simple OData endpoints for SQL Azure Database

    Something like this used to exist as part of SQL Azure Labs (https://azure.microsoft.com/en-us/blog/introduction-to-open-data-protocol-odata-and-sql-azure/) but was not taken to GA, and has been discontinued.
    I'm looking for the ability to:
    * single-checkbox "enable" a SQL Azure Database as an OData service
    * additionally checkbox "enable" it's contents by schema, table, and/or view for read, write, update and/or delete access
    * possibly configure the above access per user, or tie it into existing access control per object

    Since this capability does not exist, I am researching creating my own endpoint (which requires coding and a separate VM to run a…

    27 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. Allow storage account with vnet and behind firewall to be used for SQL's advanced threat protection.

    As described in Microsoft documentation https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing#subheading-1 a storage account behind firewall and a storage account with vnet is currently not supported for SQL's advanced threat protection.
    This possess a high security risk where the logs will visible to anyone with access to the subscription, sas uri or storage account key.
    We expect this to be fixed and enhanced so that a storage account with vnet and behind firewall can be used for SQL's advanced threat protection.

    25 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 →
  5. Azure database export fails when split_string is involved

    Database compatabilty level 130.

    Repro steps:

    alter function dbo.tt
    (@id varchar(max))
    returns table
    return
    select
    * from
    dbo.string_split(@id,',') t
    inner join
    dbo.numbers n
    on n.id=t.value

    Export dacpac fails stating unresolved reference split_string,while the function itself works

    25 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. Keep Azure SQL Premium RS

    Microsoft should reconsider retiring the Premium RS tier of Azure SQL. It provides a service for companies like ours that want to host their QA/Staging environments in Azure but don't need the full reliability of the Premium tier. None of your other offerings will work for us. We make use of In-Memory tables (OLTP). This option is only available in the Premium/Business Critical tiers. Both of which are too expensive for QA/Staging environments. To retire this option without providing anything of comparable value is a mistake. How can customers feel confident in moving their applications to the cloud if Microsoft…

    25 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. Allow SQL Database to be a subscriber in transactional push sql replication

    Now it is virtually impossible to keep an on-premise database and an Sql Database in sync. E.g. With Microsoft Sync Framework, which is batch based and not transactional, tables can be out of sync when syncing.

    24 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 →

    Thanks for your feedback here. We are always thinking about how we can improve the integration between SQL Server and Azure SQL Database. There are a number of investments that we are working on.

    We’d love to learn more about your specific scenario. Can you please email me at guyhay at Microsoft.com.
    Thanks Guy

  8. About using special symbol such as # in Database name

    Currently, creating with Database name # does not work properly on Azure Portal.
    We will seek urgent measures.
    There are many requests for this content.

    24 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 →
  9. [bug] SQL Azure Database Information Not Available in Preview Portal

    Experiencing a repeated bug in the preview portal with Azure SQL Database. Occasionally after altering the service level tier of an existing database that database no longer appears in the Portal UI. The server will still appear, and you can drill down to the database name, but you are never able to access the database details or monitoring metrics via the preview portal. The standard portal works correctly and displays the correct database information.

    24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. Faster scaling between service tiers/performance levels

    Current database scaling can be slow..
    Azure SQL Data Warehouse features the ability to scale between performance levels within seconds. It should also be an aim of Azure SQL DB to also offer scaling within seconds/small number of minutes. Key to this is presumably eliminating the data copying that goes on during scaling.

    24 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 →
  11. Transparent Data Encryption Support for ARM template

    Currently, we still cannot enable Transparent Data Encryption Through ARM Template. Please implement this feature, because it would be really helpful for users.

    24 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 →
  12. No DTU metrics can choose in Azure Monitor Alert

    One of our customer is concerned about the retirement of Classic Alert next year.
    They want to use DTU metircs as criteria but there's no DTU related metircs in Azure Monitor Alert.

    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 →
  13. Add ability in Azure SQL DB to have use minimal logging

    Would like the ability in Azure SQL DB to use minimal logging just an an om premise SQL Server would do. For example, doing an insert into an empty table with only a clustered index and specifying WITH (TABLOCK) should do minimal logging.

    23 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 →
  14. Bug: DDL Triggers are NOT disabled during Bacpac import

    During the import of a Bacpac DDL triggers are not disabled and therefore are fired on each trigger defined DDL operation as they are carried out during the import process.

    An example of this is a trigger firing on ALTER TABLE actions, where the import process is recorded by the trigger in an audit table. However when the contents of the audit table itself is attempted to be imported a duplicate primary key error is thrown as the import process has already written rows to the table.

    As an example:
    Create a DDL trigger using the attached text file on…

    23 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 →
  15. 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 →
  16. Round-robin read replicas and provide performance metrics of replicas in portal

    There is more than one read-replica and it would be a huge performance benefit to be able to round-robin the connection to them. Would also be great to get visibility into the replicas via the Azure portal.

    22 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. Granular data masking management on rule-level

    Provide more granular management of Dynamic Data Masking.

    This would allow admins to exclude SQL users for a specific masking rule instead of excluding them for the complete masking rule set.

    22 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. Azure SQL Managed Instance DNS alias

    Just like DNS alias is supported for Azure SQL database https://docs.microsoft.com/en-us/azure/sql-database/dns-alias-overview,
    we need same functionality supported for Azure SQL managed instance, abstraction layer to redirect traffic during upgrades, massive data maintenance etc.

    22 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. Elastic pools, ability to configure minimum eDTU per database singularly

    My request is to have the possibility to setup for each database, singularly, the minimum eDTU available.

    At the moment it's possible to set a maximum and a minimum for all databases.

    I think, for the nature of this kind of services, it's crucial to allow to maybe setup 0 as minimum for databases you do not care (eg: testing-staging instances, new projects) and a higher minimum to the more significant ones.

    Maximum will be interesting as well, but minimum i think is more important to guarantee a quality of service.

    In little elastic pools, it's easy be over the…

    22 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 →
  20. 21 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 →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base