SQL Database

  1. A syntax error occurs when you execute an elastic query on Azure SQL Database.

    A syntax error occurs when you execute the elastic query where 'default' string is set to search condition as below on Azure SQL Database.

    Query :
    select * from tab1 where col1= 'default';

    Error :
    Error retrieving data from xxxx.database.windows.net.xxxx.
    The underlying error message received was: 'Incorrect syntax near the keyword 'DEFAULT'.'.

    As long as I looked into this, I found that this elastic query was converted in internal logic on Azure SQL Database Engine before execution and 'default' string was changed to DEFAULT keyword. That's why the syntax error occurred.

    SELECT [T11].[col1] AS [col1]
    FROM (SELECT [T21].[col1] AS [col1]

    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 →
  2. 6 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. Disable Point-In-Time-Retention (PITR)

    Allow the user the ability to completely disable PITR for database/pools. This would allow users to prevent having additional storage costs for database that don't have a PITR need (i.e. QA database)

    26 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 →
  4. Single & Elastic Databases - Support for "pausing" active geo-replication

    Let's say I have a SQL server w/ a single database. I can setup a corresponding geo-replicated database in a different region quite easily. My question is about "pausing" geo-replication for a while. As of today, I can stop the replication using the ALTER statement. But I cannot add the replication back w/ an ALTER statement, unless I drop the database altogether. So it would be great to have the ability to "pause" or "un-pause" a geo-replication with the help of API's.

    The use case is during database upgrades. Roughly I wanted to accomplish this.


    1. App A points to database…
    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 →
  5. Management connectivity from Azure via separate nic

    We use ExpressRoute and do not allow public IP's in our VNets. This causes a problem when it comes to deploying SQL Managed instance, as we need to allow inbound connectivity on ports 9000, 9003, 1438, 1440, 1452. Could it not be arranged for this connectivity to happen via a separate network unseen to the consumer so that no inbound firewall rules are required?

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

    42 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. Linux version of SQL Data Sync

    Hi, is there a Linux version of "SQL Data Sync" in the works?
    We plan on using this tool to keep a cloud DB in sync with a subset of it deployed to an Azure IoT Edge device, running Ubuntu 18.04. We are currently investigating the preview of "SQL Database Edge", which only runs as a Linux image for the moment.
    Ideally, we would like to be able to deploy a single edge device at a customer plant. If we build everything for Linux images, it would feel odd to have to ask them to provide an additional Windows system…

    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 →
  8. 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 →
  9. 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 →
  10. 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.

    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 →
  11. Fix Azure SQL Powershell modules to support Gen5 Serverless machine types.

    Currently Set-AzureSqlDatabase don't support "serverless" at all and New-AzureRmSqlDatabaseCopy don't support Serverless server types if you want "change" server type during copy operation.
    Only New-AzureRmSqlDatabaseimport supports those.

    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. 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 →
  13. 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…

    91 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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 →
  20. 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.

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

SQL Database

Categories

Feedback and Knowledge Base