SQL Database

  1. PITR Restore is not showing in the Portal after database restore

    A customer recovered a deleted Azure SQL DB replacing old one. Then he wanted to restore again to previous point in time he should have more than 7 days of backup, however it was not showing in the Portal. Only was able to restore to previous restore point using Powershell.

    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 →
  2. SQL Azure maintanance work should be re-scheduled as per our prefered time

    Most of the time our service was down because of DB maintenance work. So, we need our preferred time to set DB maintenance work.Please consider and update us.

    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 →
  3. Backups

    Currently, a user account with the appropriate permissions could delete all of the LTR backups and then delete the sql server and at that point the database and all backups would be instantly and permanently gone and could not be recovered either by the client or by Microsoft. This seems like a large concern for anyone using Azure Sql database in a production capacity. There needs to be some type of immutable storage option for PITR and LTR backups. If one account were to be compromised this scenario could occur. Either allow directing backups to a storage account where immutable…

    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. Enable serverless feature via ARM template

    Currently serverless feature not supported by ARM template. Manually changing to serverless from the portal results in an sku name of GP_S_Gen5_1 (choosing the most basic). If I update my fully-working ARM template with this SKU name (instead of S0) for example, I get an error on deployment reporting:

    "error": {
    "code": "InvalidSkuName",
    "message": "Invalid SKU name 'GP_S_Gen5_1'."
    }

    However this is already the value of the sku name on resource JSON export as a result of the change via Portal.

    NOTE: There were other detected changes to the JSON export (from Portal changes), which I also ensured were updated…

    13 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 →
  5. The operation has been cancelled by user

    subnet we are able to destroy without removing all references which can cause multiple issues. like if we have added firewall rule in sql server which can cause issues like new subnet we can't add in firewall rule.

    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. Enable elastics jobs to use managed service identity

    SQL Server now supports MSI and yet Elastic Jobs still relies on SQL user credentials. It would be much better to be able to give a job an AD identity that can be managed and can be given rights on certain servers and databases.

    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 →
  7. HIPAA Compliance for Azure Database Migration Service

    Azure Database Migration Service is not HIPAA compliant. How can we move terabytes of PHI data to Azure SQL DB?

    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 →
  8. Sync schema changes

    It would be very helpful if Sync Groups would also sync schema changes. If a new column is added to one of the tables it would be helpful to sync to the other tables automatically.

    Because Sync Group does not do that, I had to write my own program to sync some databases together.

    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 →
  9. Need to have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    Need to have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    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. Need to have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    Need to have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    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. Azure Data Sync for Managed Instance

    Hey Guys,
    Can you tell me if you have in plan to enable this service for Azure Managed Instances?

    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. TDE- Encryption Key Rotation

    Service-Managed keys are said to be protected by built0in server certificates, however it does not state the following:

    1, How often the keys are rotated.
    2, How are the keys backed up.
    3, How to access the keys.

    Reference doc missing the info:
    https://docs.microsoft.com/en-us/azure/sql-database/transparent-data-encryption-azure-sql?view=sql-server-2017

    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. Resource health maintenance

    Show in Resource Health the "Azure Scaling and Maintenance Tasks" from the Azure Backend,
    Currently is showed: Database is "Unavailable" with not helping reasons and suggestions.

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

    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 →
  15. query optimizer assumes uniform distribution

    The query optimizer makes 4 assumptions about the data in tables.
    One of them is that the values in statistics are uniformly distributed in the table.
    For example, we have a table with 1,000,000 rows and
    in one column half are '0' and '1'.
    The column statistics show this.
    All the '1' values are at the front of the table and all the '0' at the back.
    For a query like "select .. where flag = '0'",
    the query optimizer picks a "cluster index scan" execution plan
    because the uniformity assumptions makes in think the values are
    0 1 0…

    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. Option to disable transaction logging in Azure SQL Database

    We are using Azure SQL Database for processing large amount of data and building data warehouse. By default Azure SQL database logs every write operation (DML) which impacts the data processing time. It would be great if there is option (with disclaimer) to disable the transaction logging to use Azure SQL Database for large scale analytical applications.

    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. 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 →
  18. Enable access to SQL Server/ Storage accounts via P2S VPN

    Currently when the Azure resources (SQL server/ Storage accounts) are associated with P2S VPN VNET they are accessible in the VMs created in same subnet only via client tools. If possible kindly allow the resource access via the VPN connection on the client machine. In this case a User doesn't need to include the Network client IP in the allowed network range and it will allow to keep Firewall configuration restricted to some office network (if required) and baseline minimal networks in advanced security.

    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. I'm Store SQL Data base in AOS Project but it was provides the some errors

    Recently I store my data in Sql but it was presents the some error messages.... can u solve this data base problem - https://aostv.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 →
  20. Deploy SSDT database project: update table with security policy fails when column was added

    During publishing of a SSDT Database Project, after adding a column on a table with an view and a security policy on Azure SQL Database, deployment fails with this error message:

    (51,1): SQL72014: .Net SqlClient Data Provider: Msg 3729, Level 16, State 3, Procedure vDemo, Line 1 Cannot ALTER 'dbo.vDemo' because it is being referenced by object 'SecurityPolicy_Demo'.
    (51,0): SQL72045: Script execution error. The executed script:
    ALTER VIEW [dbo].[vDemo]
    AS
    SELECT Id,
    CustomerId,
    Col01
    FROM [dbo].[Demo];

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

SQL Database

Categories

Feedback and Knowledge Base