SQL Database

  1. Ability to export Azure SQL Performance Recommendations

    Our production Azure SQL does not allow developers to access (segregation of duties and security considerations). However, we want to share developers with Azure SQL performance recommendations so that they can improve the product logic.

    It seems Azure SQL Contributor permission is required for developers to review the details. If can allow export the recommendations, it could be performed automatically, then it will be very helpful.

    I guess other organizations could have similar challenges?

    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 →
  2. Restored DBs in elastic pool goes to standard

    Steps to reproduce.

    Delete a DB that in an elastic pool.
    Recover the DB from deleted DB and use the latest PITR backup available.
    The restored DB doesnt go back to the original elastic pool but rather gets created as "Standard S0: 10 DTUs"
    Is this the expected behaviour.

    https://github.com/MicrosoftDocs/azure-docs/issues/46243#issuecomment-574939813

    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 →
  3. Build SSDT Database Project for Azure SQL Database Fails with AAD Users

    When adding an AAD user to a database project of type Azure SQL Database, the build fails with incorrect syntax on "FROM EXTERNAL PROVIDER", even when trying to add the uses in a post deployment script. However if the type is changed to Azure SQL Database Managed Instance, the project builds correctly.

    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 →
  4. Can't change database when logged in with "Active Directory Universal with MFA Support"

    When logged in to Azure SQL db using AAD with MFA option, I am unable to change databases via the database drop-down Listbox, even though the list is populated with the databases. Also, the "Change Connection" button on the "SQL Editor" toolbar is disabled. The Error received is:

    "TITLE: An error occurred while changing the current database.
    USE statement is not supported to switch between databases. Use a new connection to connect to a different database."

    HOWEVER, when logging in to the same Azure SQL db using AAD-Password, I AM able to change database via the drop-down Listbox and the…

    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 →
  5. Gen5 effectively doubles the costs for some customers

    With the phasing out of Gen4, Microsoft is effectively forcing a 2x+ price increase on some SQL Azure customers.

    We heavily use EDPs with Gen4 vCore based pricing. Our typical config is 1.5TB pools with 3 Gen4 vCores at a cost of around $750/month. Our CPU usage is minimal, but our pools are fairly large in terms of storage requirements.

    The same 1.5TB storage allocation for a Gen5 pool requires 6 vCores and costs nearly $1400/month. As our pools have <10% CPU at any given time, this is effectively doubling our costs with no benefit.

    It's even worse when you…

    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 →
  6. Fee based or Free Notation on documentation pages of a service.

    Can you put on the documentation pages, up top preferably, if a service is free or fee based? I haven't found the costs for AzureSQL database tuning.

    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 →
  7. connecting to a serverless db using an alias should wake db

    currently if you connect to an azure sql serverless db using an alias, the db will not start no matter how many times you try to connect or what connection timeout is used. this works as expected if you use the real sql server name.

    2 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 →
  8. Resize HyperScale Storage

    HyperScale database storage is incrementing exponentially, after we transferred database to HyperScale, it first incremented 20GB, than it incremented 30GB, and now it incremented 50GB, there is no way to reduce size. Either it is a bug that is incrementing exponentially or we need ability to resize, right now 80% of database is unused.

    1 vote
    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. Gen4 vCore phased out? => less memory in Gen5

    Gen4 is being phased out.
    Gen4 has 2 GB memory more than Gen5.
    Memory is more important than CPU for a lot of DB's.
    Are there any plans to introduce a vCore with more memory again?

    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. Unable to view MAXSIZE of a user database from master

    Writing a TSQL script to make the appropriate change based on the current MAXSIZE, the current used size, the Edition, and the ServiceObjective is unexpectedly difficult because while most of that information can be obtained from the master database, I have only been able to find a way to get the current MAXSIZE when connected to the user database itself.

    That’s a problem because detecting a failure involves checking sys.dmoperationstatus which can only be done from a connection to master.

    Therefore it seems impossible to decide on the appropriate change (for example, set MAXSIZE to 20% larger than…

    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 →
  11. No parameter validation on ALTER DATABASE MAXSIZE values in DTU model

    In TSQL, if you give the command to change the MAXSIZE to an invalid value for a DTU model database, it says the statement completed successfully but the asynchronous completion of the command doesn't make the requested change. Even though the operation itself is asynchronous, I think there should be some parameter validation done and an exception raised if an invalid request is made, however that doesn’t happen.

    It is also an issue that the list of acceptable values is not documented in any obvious publicly accessible document.

    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 →
  12. Total backup storage amount of SQL Databases

    We need to have an option that it permits find the total amount of Azure backup storage used for all databases into the Azure SQL Server, when you have more that five DBs into an Azure SQL Server is too complicated have the total amount.

    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 →
  13. Azure SQL final backup before delete

    I see there is a warning and you have to explicitly type 'Yes' to delete the Azure SQL database. However, people still delete the database ignoring the backup retention and pricing tier. It will be very useful if a by-default enabled checkbox that triggers the final backup before the database is being deleted(with no auto retention policy- that means the user will still pay for that backup). Users can choose to unselect the checkbox if the final backup is not required.

    10 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. 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 →
  15. Why we don't have easy way for Azure Sql Autoscale ?

    Why we don't have easy way for Azure Sql Autoscale ?

    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. Database sizes for managed instance in portal

    It would be nice if the sizes of the databases for a managed instance were viewable in the portal or via Powershell

    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. Query threat detection event in log analytics

    Is there any way to Access Threat detection events/data from Log analytics ? Before it was in SecurityAlerts, but now it's empty ???

    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. Make the .NET ConnectionString’s ConnectionTimeout property apply when resuming an Azure SQL Serverless Database

    Currently, the only way to retry the initial connection to a paused Serverless database is to implement a custom retry policy. This seems like overkill, especially if you are using a .NET ConnectionString to configure your connection.

    The .NET ConnectionString property for ConnectionTimeout sets the time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. This property does not work with the Serverless Azure SQL database tier. I tested this with a 1000 second timeout and the connection always fails in about 40 seconds when trying to connect to a paused…

    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 →
  19. sync to another database - pull tables for schema despite errors for initial setup

    if there are errors in schema of member db on initial setup, it will not load tables and you have to run a separate powershell to find out what issues are.
    1. log messages don't cut and paste - log needs to be able to cut and paste for easy support and reading of errors.
    2. tables should just not return for the whole database. You should allow tables to show if they don't have errors and grey out or highlight tables with errors.

    Often tables with errors aren't even considered for sync and not needed anyway.

    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 →
  20. Vulnerability Assessment logs should contain the resource or subscription id inoformation to make it easy to indentify the exact resource

    Vulnerability Assessment logs do not contain the resource or subscription id, just server name and database name.
    Should the resource and subscription Id will be included in the Vulnerability Assessment in the near future ?we want the subscription ID and resource group name in Vulnerability Assessment log to make it easy to identify.

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

SQL Database

Categories

Feedback and Knowledge Base