SQL Database

  1. Enable Query Data Store in Secondary Geo Replicated Databases

    We use Geo Replicated Secondaries to distribute query load among the secondaries. Right now, QDS is only available for the Primary. It would be really nice if we could use all the power of QDS on the secondaries to diagnose issues.

    44 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 →
  2. Enable GZip/Deflate Compression of SQL Azure OData Response

    OData's AtomPub protocol is very verbose. My calculations indicate that AtomPub multiplies Data Transfer Out bytes by a factor of 8.75. (See Querying OData.org’s SQL Azure Northwind Sample Data Service: http://oakleafblog.blogspot.com/2010/03/odataorgs-sql-azure-northwind-sample.html).

    Despite the Accept-Encoding: gzip, deflate header, SQL Azure OData responses aren''t compressed. I agree with this comment by Scott Hanselman - failure to compress OData responses is LAME.

    41 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 →
  3. Enable to control the timing of LTR backup

    Our customers would like to configure the timing of LTR backups or manually create a LTR backup to restore the several databases from the exact same time.

    41 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 →
  4. Database Swap

    Hey team,

    It would be a very nice feature to be able to swap a staging database to production without renaming or downtiming.

    Cheers!

    40 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 →
  5. Enable In-Memory OLTP for SQL Azure Standard tier

    Upgrade Azure SQL Database in Standard tier from 12.0.2000.8 to 14.0.1000.169 and enable memory-optimized tables and natively compiled stored procedures.

    40 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 →
  6. Thesaurus support in SQL Azure

    SQL Azure do support Full Text Search but thesaurus is not included. I know few partners requesting for this feature because for their ecommerce portal they are using SQL Azure and User Search is an integral part in any ecommerce portal. They are finding it hard to design an appropriate search functionality without out of the box thesaurus support.

    Incase SQL Azure team can take-up this feature that would be great.

    Regards,
    Zainu

    39 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 →
  7. Allow firewall rules on Azure SQL DB to be removed via ARM templates

    Currently it seems that because the firewall rules for an Azure SQL DB are just proxy resources in an ARM template that you can not remove them via this mechanism. If you remove them from the ARM template, they are not removed from the Azure SQL DB resource. This means that it is not possible to properly source control the configuration as the source controlled configuration can differ from reality. I think it is vital to allow people to properly manage the Azure SQL DB as code that you work allow the rules to be removed via the ARM template.

    39 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 →
  8. Cancel Updating database pricing tier on Azure Portal

    Sometimes it would be good to cancel a scale event instead of letting it finish, then re-scaling back.

    Examples include:
    - Human error when creating scale event (Wrong DB, Wrong Size, etc).
    - Scale event taking too long
    - Changed mind

    37 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 →
  9. Make SQL Azure a database option for SharePoint farms running in Azure IaaS

    We have our SharePoint 2013 on Azure IaaS and we would like to use Azure SQL for our databases instead of running SQL Server VMs.

    We'd also like to use SQL Azure for our Access Services databases. Office 365 does this already.

    37 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 →
  10. Support for migrating existing SSIS ETL packages

    Migrate SSIS ETL packages, which load data to my SQL Azure staging database, to a new ETL service in Windows Azure

    36 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Support sending database/server audit logs to OMS Log Analytics

    SQL Server/Database currently supports writing audit logs to Blob storage. Then something like https://github.com/Microsoft/Azure-SQL-DB-auditing-OMS-integration needs to be used to process audit log files into OMS Log Analytics. It would be really nice if Azure SQL Server/Database audit logging supported sending audit logs directly to an OMS Log Analytics workspace.

    36 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Alphanumeric ORDER BY

    Please add support of alpha numeric ORDER BY of text values. A good sample you will find here: http://www.davekoelle.com/alphanum.html
    Without this feature is impossible to made a paging (skip, take) of for example file names.

    36 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. 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.

    35 votes
    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 →
  14. Add Java API for Azure SQL Database Elastic Scale

    For Java shops, we need an API for Azure SQL Database Elastic Scale. We already have too much code and want to minimize the amount of refactoring to move up to Azure SQL Database. We're very interested in Elastic Scale. Without a Java API, this a non-starter for us.

    35 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 →
  15. Force user to read replica Azure SQL Database where Read Scale-Out has been Enabled and user only has readonly access,

    Is there any way to force a user to read from a read only replica where that user has only been granted readonly access to a database? It seems that we're relying on any external application to be a good citizen and provide the ApplicationIntent in the connection string.

    35 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 →
  16. elastic pool, ability to configure max eDTUs per database

    Ability to configure max eDTUs per database on Standard and premium elastic pool.

    34 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 →
  17. Mapping of Azure services to the vNet

    Company security restrictions do not allow to open port 80, 443, 1433, ... (or other) from a vNet / VPN to the Internet.
    Mapping Azure services with a public IP to a vNet should become a general feature (not only for SQL as requested in the following request).
    See also https://feedback.azure.com/forums/217321-sql-database/suggestions/5537689-allow-sql-database-to-join-virtual-network-vpn

    vNet internal dynamic or static IP / name + port -- mapping -> Public dynamic IP / name + port

    34 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. Add ability to rename SQL Azure database

    Would be useful to right-click and rename a SQL Azure database. I tried renaming it in the VS SQL Server Object Explorer, but that broke the portal -- it always hung when trying to navigate to the database.

    34 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Set the time zone for each database at the database level instead of OS level.

    I have clients across the country that I want to encourage to use Azure. Without changing a lot of code in the program I need to set the time zone on each database.

    33 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. Azure SQL DB Gateway IP address change notifications

    Since the IP addresses listed in the documentation below are subject to change, proactive notifications should be provided to ensure users can make necessary updates to their environment before changes occur. This could be an email to affected resource owners, or a notification within the Portal such as through Service Health or Resource Health.
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture

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

SQL Database

Categories

Feedback and Knowledge Base