SQL Database

  1. 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 →
  2. 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 →
  3. Advance filtering for Azure Database for threat detection

    We often receive alerts for "Someone has logged on to your SQL server '***' from an unusual location.". Most of the time, this was triggered by our DBAs within our office network. As the subscription owner receives too much of these "false-negative" alerts, these alert no longer make sense to them.

    Our office had a dynamic pool of public IPs. If Azure could implement an advance whitelisting feature, this would be a great help.
    For example, if DBA groups access these DBs from an IP range.

    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 →
  4. 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 →
  5. Enable same region support for VNET Integration

    Currently if you enable VNET Integration for an azure storage account in the same region as Azure SQL Server, Polybase access to the content in the storage account fails. App Services has a VNET Integration feature in preview that allows same region access as an example.

    2 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. Allow ElasticPool SQL Database to join P2S Virtual Network (VPN) - Round 2

    This is round 2 of the idea posted here:

    https://feedback.azure.com/forums/217321-sql-database/suggestions/5537689-allow-sql-database-to-join-virtual-network-vpn?tracking_code=704e9fed32d702f27033e3c1be63d789

    which was closed since SQL databases now have "virtual network" endpoints. However, these endpoints still do not work with P2S VPN connections using Azure VPN Gateway, so I don't know why this idea was closed as completed.

    This means that we either need to create our own workarounds, such as SSH tunnels via VMs inside Azure, or we need to keep using the IP whitelisting method (the latter of which defeats the whole purpose of using a VNET-based access control). In addition, security auditors don't look kindly on databases with…

    108 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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 →
  8. 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 →
  9. 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 →
  10. Give access to Full Text Search crawl logs.

    Troubleshooting Full Text Search issues would be much easier having access to FTS crawl logs.

    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. Azure SQL Managed Instance - Encrypt multiple db's with different asymmetric keys

    The big blocker for us moving to Azure SQL Managed Instance is that we will not be able to provide our customers the option of BYOK.

    We need to be able to set a separate asymmetric key as the TDE protector for each database, allowing our customers to set their own encryption key for their own database.

    Right now, Managed Instances allows only setting one TDE protector per instance, not per database. We cannot be expected to pay for an additional instance for each database just to be able to encrypt each database with different keys. This is already possible…

    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. Ability to create consolidated Vulnerability scan report across multiple sql servers/databases

    Allow to create aggregate reports by sql servers and its databases instead of database by database which does not scale

    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 managed instance replication - general availability time frame?

    I understand replication for Azure SQL Managed instance is in preview mode. Wondering, if you have any approximate time frame when it can be used for Production database. Looks like decision makers in my company would feel comfortable once the product is in 'general availability' mode

    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. make harder to delete resources on azure portal

    Clicking "Delete" on pinned SQL Database in the Azure Portal Dashboard doesn't ask for confirmation. This should be fixed. Also, two-factor authentication for delete actions would be perfect.

    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. Got "Setup Failed" during installation of Microsoft SQL Server Management Studio

    Got "Setup Failed"
    "The certificate was explicitly marked as untrusted by the user (0x800B0111)"
    during installation of Microsoft SQL Server Management Studio

    I have to say, I didn't change any certificates before installation and follow all provided instructions...
    After I got this issue, I tryed to solve this with provided documentation: I didn't find any installed files or folders in Registry to delete.
    Also, I got the same issue while installing older versions of Microsoft SQL Server Management Studio.
    I cannot find any useful information what is the main problem :(

    I have Windows 10 x64 OS. Added log file…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Provide SQL Server Connector functionality for Azure SQL PaaS

    In order for an EKM provider to communicate with an Azure Key Vault the database must be either Azure SQL IaaS or an on-prem instance of SQL Server. When using Azure SQL Paas, however, it would be great to have this level of security available as well as the ability to manage credentials in one area and within a Key Vault.

    21 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 →
  17. Authenticate using Azure AD DS

    Just like how Azure Files supports authenticating using Azure AD Credentials from Azure AD DS domain joined machines, it would be great to be able to authenticate to Azure SQL in a similar manner.

    We have some legacy apps running in Azure VMs that users log into, it would be great to be able to authenticate to SQL using their current logged in credentials (similar to how Windows or Azure AD Integrated authentication works)

    Currently we are prompting them for credentials and using the Active Directory Password authentication mode.

    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 →
  18. Enable “per-database charge for elastic pools” in Azure SQL Database (PaaS) Platform.

    Enable “per-database charge for elastic pools” in Azure SQL Database (PaaS) Platform.

    . SQL Database Elastic Pool is a shared resource model that enables higher resource utilization efficiency, with all the databases within an elastic pool sharing predefined resources within the same pool. There is no per-database charge for elastic pools. You are billed for each hour a pool exists at the highest end or vCores, regardless of usage or whether the pool was active for less than an hour

    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. Hyperscale: Bring back copy database

    We really, really need the ability to copy Hyperscale databases just like other Azure SQL tiers!

    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. Enable XE sqlserver.backup_restore_progress_trace

    This event was introduced in SQL Server 2016 and is also available in Azure SQL Database Managed Instance.
    In order to track (automated) backup times/running time and restore progress this would be very helpful in backup/restore monitoring for Azure SQL Database.

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

SQL Database

Categories

Feedback and Knowledge Base