SQL Database

  1. quality

    Data Quality capabilities allow the user to profile and cleanse their data in Azure based on commonly used Data Quality Standards (dimensions) such as Completeness, Uniqueness, Consistency, Conformity, Validity, and Accuracy.

    19 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. 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…

    19 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. Send maintenance notification in advance

    Recently we have got maintenance notification one day before maintenance starts.
    It's very useful for me, however, I'd like to get it earlier, e.g. 3 business days before the maintenance.

    19 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. Allow database specific alerts to be set up at elastic pool level

    At present, you can set up alerts for elastic pool resources and alerts for individual database resources. However, if you have say 100 databases in your elastic pool, setting alerts per database is a real pain.

    It would be good to set up database specific alerts at elastic pool level so it can be managed easily.

    For example, we'd like to set up an alert when the number of database sessions reaches 80% but doing this across all of the databases in an elastic pool isn't easy.

    18 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 →
  5. Provide a way to force "transient" SQL errors for testing.

    When using Azure SQL, transient errors due to throttling, load balancing etc become a fact of life quickly. There are methods to deal with this, but testing that the methods actually work in your server is very tricky or impossible.
    It would be great if there were a way in the portal, or Powershell APIs, to force transient errors in some way. For example, "for the next N minutes return a throttling error for every second operation".
    For examples of the lengths developers go to in order to test this:
    https://github.com/robdmoore/SQLAzureTransientDemo
    http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/connection-resiliency-and-command-interception-with-the-entity-framework-in-an-asp-net-mvc-application

    this is a great deal of tricky code…

    18 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. Bring back T-SQL debugger (and make it work with MI)

    The T-SQL debugger, while not perfect, was a very useful tool for me. We've recently migrated a large database with some complex SPs from MySQL to an Azure Managed Instance, and while the debugger did not work with the MI, it did work with our on-prem dev server. Using the debugger has made it so much easier to track down where something has gone awry. I was very disappointed to learn that it's being removed completely in SSMS 18.

    18 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. restore only 1 or few tables from all database

    restore 1 table from big database can take few hours and only what we mostly need to restore 1 table.
    can save lot of time when we need the table immedietly !

    18 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 →
  8. Deploy SSDT database project with external tables fails

    During the deployment of a SSDT Database Project with external tables on Azure, deployment fails with this error message:
    2018-07-10T17:23:00.8539155Z Dropping [EDS]...
    2018-07-10T17:23:01.7970626Z An error occurred while the batch was being executed.
    2018-07-10T17:23:01.8200128Z Updating database (Failed)
    2018-07-10T17:23:02.1289225Z ##[error]*** Could not deploy package.
    Error SQL72014: .Net SqlClient Data Provider: Msg 33165, Level 16, State 1, Line 1 Cannot drop the external data source 'EDS' because it is used by an external table.
    Error SQL72045: Script execution error. The executed script:
    DROP EXTERNAL DATA SOURCE [EDS];

    - The Target of SQL Project is target platform 'Microsoft Azure SQL Database V12'.
    - A…

    18 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 →
  9. SSRS must be like a Service again

    After 30 minutes write with Azure support they sugest me post my feedbacks, but the point is I think #microsoft make a mistake disable SSRS like service from Azure.

    you can provide a general VM with SSRS for every body with this option you will protect Azure performance and will provide the services again.

    18 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 →
  10. SQL Export progress not updating

    Start export of a sql-database
    A progress window appears at the bottom wich updates every 30secs.

    But the percentage stays at 0%

    17 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 →
  11. Elastic query without opening firewall to all of Azure

    From the documentation at
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-vertical-partitioning#best-practices

    It says "Ensure that the elastic query endpoint database has been given access to the remote database by enabling access for Azure Services in its SQL DB firewall configuration"

    There should be a way to enable elastic query without allowing anything in Azure to connect by setting "Allow access to Azure services" to ON.

    17 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 →
  12. 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

    17 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 →
  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.

    16 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. Allow SPN's to create AAD Users

    As we follow best practices and fully automate Azure using SPN's while leveraging AAD for users, we wish to create AAD users in SQL DB using our SPN's.

    When attempting to create AAD users in a database using an SPN, we received this error:
    "Principal 'xxxxxx' could not be created. Only connections established with Active Directory accounts can create other Active Directory users."

    We were told by support that "At this time, the statement CREATE USER [] FROM EXTERNAL PROVIDER; is not supported for SPN."

    Request we make this possible...

    16 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. SQL Database in Azure does not allow changing UTC to our default, setting UTC 0, considering this, how to migrate an on-premise database fro

    SQL Database in Azure does not allow changing UTC to our default, setting UTC 0, considering this, how to migrate an on-premise database from an existing system? Unable to change all code, so it is not possible to use a SQL Database in Azure for this? Is Azure not prepared for my country? Even AWS (Amazon) lets you change UTC, as Microsoft does not allow ???

    16 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. Allow to query analysis services directly from sql database

    Right now there is no way to combine results from sql and azure analysis services without additional layer of code that would query analysis services and insert results to sql database.

    Before azure we had something called OPENQUERY, that would allow us to query on the specified linked server using syntax that makes sense for that linked server (for example MDX).

    Current implementation of azure elastic query doesn't really help in this situation.

    16 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. Support semantic search

    Make the semantic search capability of SQL Server available in Azure SQL Database.

    16 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. Adding Azure AD groups to Azure SQL Database with Special charecters like '&'. Currently it is not alowing.

    Adding Azure AD groups to Azure SQL Database with Special characters like '&'. Currently it is not allowing. Corporate AD groups have special characters and we need this feature should be available for successful client satisfaction. It is critical for enterprise applications.

    16 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 →
  19. 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.

    16 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. Fix quality of daily cost data visibility

    On various days / weeks there are gaps in cost data for various resources. This tends to self-heal after up to 1 week (incl. history correction). All custom control / alerting which looks on anomalies in cost trends fail due to this; we also loose opportunity to act quickly on unexpected cost raises due to changes, testing activity or unplanned activity on prod - it's critical to see this data at least with daily delay, ideally near real-time.

    Examples of incidents: on Dec 8-9 we stopped getting cost data for any of our SQL DWs, SQL DBs or PostgreSQL DBs…

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

SQL Database

Categories

Feedback and Knowledge Base