SQL Database

  1. Restore SQL MI database to SQL on VM

    Require feature to restore the SQL MI database to SQL on VM. The database size of 5 Gigs takes 30 minutes using the BACPAC method.

    4 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 →
  2. Azure SQL PIM Access

    The idea is to have an on-demand access to Azure SQL and will revert the access after the duration. This will help securing and auditing of the database and db server.
    Refer to https://docs.microsoft.com/en-us/answers/questions/40014/azure-sql-pim-like-access.html

    9 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 →
  3. Use Elastic query with Private Endpoint

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

    Currently the elastic query only works with deny public network access set to NO and allowing all azure services to access the database, there should be a way to get the elastic query working with private endpoint.

    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. Query Store or Audit Log for read scaleout database

    We have facing timeout issue in read scale out database (Read only) for particular 2-3 minutes. We are not able to find anything from the read only database.
    If Azure provide Query store or Audit log in read only database then we can find what was going running for particular time.

    Even we can't create the extended event on read only Server

    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 →
  5. Case insensitive issue with aA on collation Danish_Norwegian_CI_AS


    • Create a database with collation "Danish_Norwegian_CI_AS"

    • Create a table "TestaA" with columns

      • Id (int)

      • Name (varchar(max))



    • Create a table "Test2aa" with the same columns

    • Run the attached queries

    • Repeat steps over with collation "Norwegian_100_CI_AS"

    Expected result:
    In a case insensitive collation I would expect a lowercase-a followed by an uppercase-A "aA" to match two uppercase-A's "AA".

    Actual result:
    When using collation "Danish_Norwegian_CI_AS" "AA" will not match "aA". This goes both for table name, column name and even string/text data stored in the database.

    Queries:

    --Run these on a database with collation Danish_Norwegian_CI_AS
    select * from TestaA -- OK
    select *…

    3 votes
    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 →
  6. Add SQL Management Studio to the Windows Store

    Why isn't it in the Windows Store ?
    It makes installing and patching a lot easier and safer.

    4 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 →
  7. Add SQL Management Studio to the Windows Store

    Why isn't it in the Windows Store ?
    It makes installing and patching a lot easier and safer.

    0 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. Improve handling and prevention of unhealthy SQL gateway cluster

    It seems that if a gateway, front-end, node in the SQL gateway cluster, that provide the directory lookup services and rerouting of incoming connections to the intended back-end probes, turns unhealthy it can result in "connection terminated unexpectedly" or "Communication link error" errors when a login to the database is attempted, this recently happened to a client of mine that is using Azure SQL Database / SQL Data Warehouse in the West Europe region. There are several nodes in one region in the gateway cluster, but it seems that an ARM deployment resulted in an ACL rule being removed in…

    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. I would like the creation date and username for each resource be available

    I would like the availability of data on the creation date and the user who created the resource available for each and every resource. The creation date would be nice in the resource listing too.

    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 →
  10. Allow STRING_AGG with DISTINCT

    Currently it is not possible to use the DISTINCT keyword.

    I would like to be able to write:

    SELECT STRING_AGG (DISTINCT expression, separator)
    FROM ...

    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 →
  11. Allow STRING_AGG with DISTINCT

    Currently it is not possible to use the DISTINCT keyword.

    I would like to be able to write:

    SELECT STRING_AGG (DISTINCT expression, separator)
    FROM ...

    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 →
  12. Allow STRING_AGG with OVER clause

    Currently it is not possible to have an OVER clause with the STRING_AGG aggregation function.

    4 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 →
  13. Make Autopause feature compatible with Flow triggers

    Power Automate Flows that begin with a SQL trigger ping the SQL database target every few minutes to see if the trigger condition has been met, which would then trigger the flow to execute. However, Azure SQL interprets these checks as a new logon attempt and so it never allows the database to pause.

    Azure SQL should recognize the difference between a user logon, system scan, or other action that should legitimately resume the database, separate and distinct from a Power Automate Trigger that should not resume it. Otherwise, anyone who relies on the auto-pause feature cannot use Power Automate…

    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. Transient login failures due to load balancing and updates, or unplanned occurrences

    We are experiencing the issue with Transient login failures due to load balancing and updates, or unplanned occurrences. It's not acceptable for our business.

    Is there any way to fix these problems as its impacting to our business transactions.

    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 →
  15. SQL Elastic Job Agent

    As a SQL DBA, I would like SQL Elastic Job Agent to send email or webhook alert when a job fails, retries, starts, or finished. Alternatively, I would like diagnostics logging or metrics for failed jobs.

    Integration with Azure Monitor would be preferred.

    Thank you!

    9 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 →
  16. Database Auditing setup

    Database Auditing setup by a specific group. Currently by default are BATCHCOMPLETEDGROUP, SUCCESSFULDATABASEAUTHENTICATIONGROUP AND FAILEDDATABASEAUTHENTICATIONGROUP. I want only the SUCCESSFULDATABASEAUTHENTICATIONGROUP AND FAILEDDATABASEAUTHENTICATIONGROUP.

    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. 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 →
  18. No maximum value for MAX_STORAGE_SIZE_MB is documented

    No maximum value for MAXSTORAGESIZEMB is documented.
    In Azure SQL Database, any attempt to set the value of MAX
    STORAGESIZEMB higher than 10240 results in the following error message: "Cannot set Query Store maxstoragesize_mb to nnnnn. The maximum allowed limit is 10240 MB." This limit does not appear to be documented.

    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 →
  19. Proide to change Cost Threshold For Perallelism

    We are not able to update cost threshold for parallelism. This setting must be configurable.

    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 →
  20. Ability to track all the execution without affecting DB performance

    Please provide the execution details for check DB performance

    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 →
← Previous 1 3 4 5 39 40
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base