SQL Database

How can we improve Azure SQL Database?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. to allow that synonyms in Azure SQL Database can reference other Azure SQL Databases (in order to use cross database joins from Azure SQL DB

    to allow that synonyms in Azure SQL Database can reference to other Azure SQL Databases (in order to use cross database joins from Azure SQL DB)

    50 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSRS

    SSRS PaaS offering

    49 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Ability to execute SQL statements in Resource Manager template

    Hello, here are few automation use cases

    1. Copy and overwrite existing database (or delete existing database). Database DB1 on server A is restored from database DB2 on server B. Currently we can copy databases using Resource Manager template but we cannot overwrite the existing database. We have to use powershell or connect using SQL Management studio to first delete the target database and then run an ARM template to copy a database.

    2. Create contained user for a database after it is copied. Just like in the previous use case. We copy database via ARM template but afterwards we…

    48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Invoke-sqlcmd with AD - Universal with MFS support

    Add support for Powershell sqlserver module to query SQL Database with "AD - Universal with MFS support". It appears that only SSMS has this capability.

    Is there a work around to connect to SQL DB via command line using AD?

    47 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Include improved & regressed query plan links in sys.dm_db_tuning_recommendations

    When you enable Automatic Index Tuning, and Azure adds indexes, the portal's validation screen shows a count of the number of improved and regressed queries. However, there's no easy way to tell which queries they were.

    To facilitate that, how about in the "details" JSON column of sys.dm_db_tuning_recommendations, you add something to help us join to Query Store or the plan cache to see which queries they were?

    45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Distributed / cross-database queries within an elastic pool

    We're familiar with elastic queries, but there's a class of cross-database query scenarios that they don't address.

    What we really need is the ability to perform a query across multiple databases. In SQL Server on-premises, this is done with a three- or four-part notation to reference the external database. That option doesn't exist in Azure and is required for a number of scenarios.

    For example, Dynamics GP uses multiple databases, so it simply can't run on Azure SQL. We have additional third-party systems that have the same requirement. So we literally have no way to move to Azure as a…

    45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add Azure SQL Database Memory Usage Metric In the Portal

    Azure SQL Database has ton of metrics available for monitoring in the portal.It would be complete if Microsoft could create a metric for monitoring Memory also.

    41 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. Increase the max database size

    Our clients frequently have multi-terabyte databases, which instantly removes SQL DB as an option. Having to scale to P11 and pay $7K/mo for only 1TB seems outrageous. Storage it cheap, even in high IOPS scenarios. We would use SQL DB more often if storage were increased significantly.

    40 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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!

    39 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add support for OLE DB connections to Azure SQL DB that support Azure Active Directory Authentication

    When working with a client recently they wanted to put data into Azure SQL DB using SSIS and the OLE DB destination component. They were unable to do this because they have a hard requirement to use Windows Authentication. Azure SQL DB supports Azure Active Directory Authentication now, however the OLE DB component does not support this.

    Please could support for this be added.

    39 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow connection from Power BI

    I'd like the option to allow connections from Power BI ONLY
    Current options allow me to

    1. Allow access to Azure services
    Not sufficient, will allow connection from all resources in Azure

    2. IP Whitelist
    As far as I understand it's not possible to whitelist Power BI without whitelisting an entire data center

    3. Virtual network
    This alternative allow me to install a VM with Gateway, however this results in unnecessary costs

    38 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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

    34 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Database

Feedback and Knowledge Base