SQL Database

  1. Allow acces to Azure services by region

    On the SQL Firewall page have an option that says Allow access from Azure Services in Region where each azure region is listed and you select which ones to whitelist. The reason for this in my case is that I have functions on a function app that is on a consumption plan and so I had to get the azure data center up range for Canada central, Convert them to IPv4 start and end IPs and then manually enter them into the whitelist. And I’d expect they change over time. The Boolean allow access to azure services option currently available…

    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 →
  2. List Microsoft Applications which can make of Azure SQL Databases

    Please consider creating and maintaining a page which lists all Microsoft products which support use of Azure SQL Databases as opposed to an IaaS or Managed Instance solution.

    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 →
  3. Native support to translate between different Coordinate reference systems

    Native support to translate between different Coordinate reference systems. Even if this was down to the user to define a CRS with, say, OGC WKT or a PRJ file

    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 →
  4. No parameter validation on ALTER DATABASE MAXSIZE values in DTU model

    In TSQL, if you give the command to change the MAXSIZE to an invalid value for a DTU model database, it says the statement completed successfully but the asynchronous completion of the command doesn't make the requested change. Even though the operation itself is asynchronous, I think there should be some parameter validation done and an exception raised if an invalid request is made, however that doesn’t happen.

    It is also an issue that the list of acceptable values is not documented in any obvious publicly accessible document.

    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 →
  5. Monitoring for database number amount in the pool

    I would like to have the option to setup an alert when the number of databases in the pool reaches a threshold. This is useful to scale up and down the total DTU.

    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 →
  6. Inconsistent pricing in SQL database and SQL reservation blades

    Azure Portal contains the following relevant blades:
    * 'Configure' blade for SQL database (or SQL database pool)
    * 'Create SQL Reserved vCore' blade for purchasing SQL reservations

    SQL reservation blade
    The SQL reservation blade contains an annotation next to quoted reservation cost, which indicates a discount off the PAYG rate.
    For example, the blade might display something like 'Reservation cost AUD 1,416; Estimated savings 35%'.
    It is noted that the Reservation Price is expressed on a 1-year or 3-year basis. This value can be easily converted to a monthly equivalent rate by dividing by 12 or 36, as the case…

    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 →
  7. Need to apply proper UI and proper SQL management studio. The SQL management studio needs to be like locally

    Need to apply proper UI and proper SQL management studio. The SQL management studio needs to be like locally

    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 →
  8. Fine tune backup retention

    We have a customer that cannot use SQL Azure because they have a requirement that they cannot keep data held in their database for longer than 48 hours.

    The minimum retention period is 7 days for SQL Azure, so we have to use a VM with SQL installed....

    Can we have an option to be able to fine tune the retention periods of the backups.

    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. How To Delta Airlines Customer Service Book Flight Ticket?

    The Delta Airlines Customer Service has an accessible official with whom you can interact with and learn all about your issues. The Airlines Phone Number is there to support all users and provide them with an insight of the airlines. They will offer steps for the completion of all procedure. If you need on-time support and reliable information, Delta Airlines Customer Service Number is the best option.
    For More Information Visit Here: https://delta.airlinescustomerservice.org/

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SQL Management Studio functionality in the Azure portal to manage the SQL Databases

    Instead of connecting your local installation of SQL Management studio to the Azure platform. It would be great to have a way of exploring the Azure SQL databases and passing commands via the portal itself. This would make managing databases on the go much easier.

    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 →
  11. support in-memory technology in basic service tier.

    Hi

    I need to run perf test first with In-memory techonlogy for my website.

    so I have to run migration in basic service tier for table,sp,function and view or else but I did not want to pay during development or migration.

    if we can do it, i can easy to transfer my code to other servie tier when my website has a lot of requests in the future.

    I hope use In-Memory technology in basic service tier.

    Thanks

    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 →
  12. Increase the SQL pool size to 4TB in 500eDTU

    We have less number of customers and they want to keep 10 years of data. So we need more storage space than the performance. Please give an option to increase the storage to 4TB in 500 eDTU in premium tier

    Thank you.

    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 →
  13. Provide notifications when restoring an Azure SQL database

    I've been using the portal this morning to restore a Azure SQL database and there's no indication of progress. I'd expect something to pop up in the notification area saying when it's started and completed, ideally with an estimated time.

    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 →
  14. make harder to delete resources on azure portal

    Clicking "Delete" on pinned SQL Database in the Azure Portal Dashboard doesn't ask for confirmation. This should be fixed. Also, two-factor authentication for delete actions would be perfect.

    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 →
  15. Allow tags to be added as part of copy database

    When using Azure Policy to enforce mandatory tags, copy database fails. Please update the UI to allow users to input tags as part of the copy process, or use the tags that the source database has by default.

    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 →
  16. Typo in security group rule

    See attached picture. Choosing MS SQL as service gets port "1443" instead of "1433".

    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 →
  17. Site Update about ATP

    A customer Found an issue on https://azure.microsoft.com/en-us/pricing/details/sql-database/elastic/

    Advanced Threat Protection SQL Advanced Threat Protection (ATP) – Please see Azure Security Center pricing page for details.
    the ATP has been replaced by ADS already

    Please update the site if its correct. Thank you

    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 →
  18. Suggestions for Azure SQL DB

    Azure SQL should support SMX compression on NIC's HW level, so that it can reduce the traffic over network and reduce latency. also it should support table partition feature

    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 →
  19. Provide the ability to block unencrypted databases (Transparent Data Encryption = disabled) with ARM policies.

    Provide the ability to block unencrypted databases (Transparent Data Encryption = disabled) with ARM policies.

    This is currently not possible and I have been advised by the product team to request the feature here.

    The reason this will be helpful is so secure environments where data encryption is a requirement.

    Thank you.

    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. Replicate the logins to secondary replica in failover group in Azure SQL Database.

    We used to have sphelprevlogins script in onpremises which used to help us in migrating the logins and passwords of SQL server to another instance. Coming to Azure SQL Database, where we have N number of logins we are unable to create the sphelprevlogins stored procedure in master database in order to fetch the logins data. As it is the logical master and not the actual master. Hence, we do not have the write permissions to it. It would be great it this logins and user migration can enabled which would help us to configure failover…

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

SQL Database

Categories

Feedback and Knowledge Base