SQL Database

  1. Active Geo replication to different subscription

    Customers are looking for this type of feature to replicate data from Prod in UAT/Test. Also to make the database available for third party to separate the costing. Currently custom coding or replication tools are needed, but would be great if the secondary replica can be in another subscription

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add confirmation requirements on actions which could damage the system

    Hi,

    Presently its possible to delete a db and scale down a db without a confirmation. This is very dangerous. While its possible to restore a db this will still result in down time (quite a bit if the db is large). The same goes for scaling down. Should by accident the wrong size be chosen the production environment can be severely hampered as has occurred to us today.

    Please add confirmations at least to these areas. Password protection requirement to deleting a db/server should also be implemented in my opinion.

    Thank you
    Ron

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Auto Scaling for Azure SQL

    Ability to create rules which enable automatically scaling up or down the DTUs on an Azure SQL Database based on usage.

    217 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. Add Log Reader functionality to SQL Server like ApexSQL Log

    It is nearly impossible to read db logs. The ApexSQL Log tool does this well. This functionality should be in SQL Server. It would be very useful for MS to purchase this product and incorporate it into SQL Server, or rewrite it as necessary for inclusion.

    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. New SQL Database pricing tiers P12, P13, P14

    Currently there are P11 and P15 SQL Database pricing option which 1.75k eDTU and 4k eDTU and price difference is x3 of P11. Can we add P12, P13 and P14 pricing tiers with 2.5k eDTU, 3k eDTU and 3.5k eDTU

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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 →
  7. Add Master Data Services (MDS) to Azure hosted MS SQL.

    Add Master Data Services (MDS) to Azure hosted MS SQL.

    989 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    48 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Show Database Pricing Tier on Azure Portal

    I've multiple Azure DBs to manage and desire a single view to tell all pricing tier at once on portal.

    4 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 →
  9. Implement Optimize for Ad Hoc Workloads Option for Azure Database

    Please consider implementing a feature to allow turning on the optimize for ad hoc workloads option on a per-database basis for Azure databases. Right now this option is only available in on-premises SQL Server on a server-wide basis, where it's a great help for managing plan cache memory when dealing with 3rd party applications where we have no control over the SQL that gets thrown at the database. It would be great to be able to enable this option on a per-database basis in Azure. If you decide to implement this feature, then it would seem logical that turning the…

    32 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 →
  10. Support native SQL backup/restore for SQL Database...like RDS....

    Bacpacs are cumbersome and difficult to work with. Things would be much simpler if SQL Database supported native SQL backup.restore...like RDS.

    5 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. Improve warning when enabling Sql Auding

    When enabling Sql Auditing downlevel clients will no longer will be able to connect to the database.

    There is currently an information icon and description that does not match the severity of the consequences.

    I strongly recommend to improve the warning. I've attached a suggestion.

    4 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. Automatic Fail-over to secondary region similar to Global DocumentDB

    Recently, Microsoft introduced a feature "Global DocumentDB database" along with "multi-homing APIs" which provides transparent & automatic fail-over to secondary database with no human intervention.

    It will be helpful to have a similar feature for Azure SQL Database where users can enable Geo-Replication and will not have to worry about manual fail-over to secondary in case when Primary / master is unavailable

    81 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. BUG in Azure SQL

    I got an issue while working with Azure SQL. Actually, SSMS does allow to connect with the Azure SQL Server with below mentioned name:

    For Example I gave server name as "abcd123.database.windows.net" with login name "demo@abcd" .SSMS through an error stating "Cannot open server abcd requested by login"

    But, Azure portal allow us to create server with this credential.The issue is with any server created with name in the above format . You can test creating a server with name "abcdeq123.database.windows.net" with admin login name"demo@abcdeq". It allows you to create a server with this name in azure portal but when…

    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. SQL Azure Import data from Local Excel (PowerBI) Instance

    Currently to use Azure with Excel and import data from Excel to MSSQL Azure you must install MSSQL on the local machine and import and pass the data to Azure which somewhat negates the benefit of Azure.

    Reference this superuser post for details on the workaround http://superuser.com/a/789290/76498 . Given that PowerQuery is now an awesome ETL tool and is in the flow from data to PowerBI being able to seemelessly backup your imported and related data from Excel and PowerPivot to Azure just makes sense, it then also follows the same could/would occur from PowerBI as it also has PowerQuery.

    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 →
  15. UID Property Not Needed in SQL Database - Database Connection Strings for new ODBC Azure AD Integrated Auth

    Hi there

    I see that in the Database Connection Strings page for an Azure SQL Database, you've added support for the new Azure AD Authentication types, which is great.

    However, I think there's an issue with the "Azure AD Integrated Auth" version (refer to the "PortalAzureInt_Auth.jpg" screenshot attached): it seems to include the "UID" key value pair:

    Driver={ODBC Driver 13 for SQL Server};Server=tcp:XXXXXXX.database.windows.net,1433;Database=XXXXX;Uid={yourusername};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;Authentication=ActiveDirectoryIntegrated

    As I understand it, the UID should not be supplied when connecting to the database with via this mechanism.

    When creating an ODBC connection via ODBC Data Source Administrator, the ODBC driver's…

    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 →
  16. Support for SQL Trace Log Configuration

    Support for SQL Trace Log Configuration.

    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 →

    Thanks for your feedback here.

    SQL Trace is one of our older SQL Server technologies that’s on the path for deprecation. XEvents is the modern replacement. I’d love to learn more about your scenario here. Please reach out to me. Query Store is another alternative.

    Thank you
    Guy.

  17. Provide us detail monitoring view in tables & graph views

    Provide us detail monitoring view in tables & graph views.

    2 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 →
  18. Support SQL Agent service or some Scheduling on Azure SQL Server/Databases

    Support SQL Agent service or some Scheduling on Azure SQL Server/Databases.

    7 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 →
  19. Support tempdb access/view and allow to extend the size on Azure SQL Database

    Support tempdb access/view and allow to extend the size on Azure SQL Database.

    14 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 →
  20. Support cross database copy and db objects access on Azure SQL Database under same subscription

    Support cross database copy and db objects access on Azure SQL Database under same subscription.

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

SQL Database

Categories

Feedback and Knowledge Base