SQL Database

  1. Ability to create an Azure SQL backup (.bak) to Blob storage

    Moving a +1TB db to a VM+SqlServer via Import/Export data tier is very slow. Being able to restore an Azure DB from a .bak file should be much quicker. Or the ability to leverage restore from Long Term Backup storage to a VM.

    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. Extend STRING_AGG to only return Unique values and sorted

    I have it already, here is the CLR code I use, which i unfortunately use in SQL Azure

    Here is the simple code for it

    using System;
    using System.Data.SqlTypes;
    using Microsoft.SqlServer.Server;
    using System.IO;
    using System.Collections;

    [Serializable]
    [Microsoft.SqlServer.Server.SqlUserDefinedAggregate(

        Microsoft.SqlServer.Server.Format.UserDefined, //use clr serialization to serialize the intermediate result
    
    IsInvariantToNulls = true, //optimizer property
    IsInvariantToDuplicates = false, //optimizer property
    IsInvariantToOrder = false, //optimizer property
    MaxByteSize = -1) //maximum size in bytes of persisted value
    ]

    public struct ConcatUniqueSorted : Microsoft.SqlServer.Server.IBinarySerialize
    {

    private ArrayList list;
    
    

    public void Init()
    {
    list = new ArrayList();
    }

    public void Accumulate(SqlString value)
    {
    if (value.IsNull || value.Value.Length ==…

    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. Document when Azure IP address lists change and go into effect

    When changes occur to the list of Azure IP address and when they are available for services to begin using should be documented publicy.

    The list of available IP addresses that can be used by services in Azure can be pulled using Get-AzNetworkServiceTag and the published json files, such as https://www.microsoft.com/en-us/download/details.aspx?id=56519 and https://www.microsoft.com/en-us/download/details.aspx?id=57062.

    Cross-cloud deployments that use resources across multiple clouds, such as Azure Cloud and Azure China, depend on these addresses to configure firewall rules between services. Changes to these addresses without notification could impact production assets.

    For example, deploying an Azure SQL Data Sync group with members…

    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 →
  4. Add Azure Database scaling duration to the SLA

    Scalibility is one of the key features for moving to the cloud, but sometimes scaling can take a few hours. There is no mentioning of the duration in the Service Level Agreement on how long a scaling operation should take at maximum. Please add the amount of minutes we can expect a scaling operation to take to the SLA.

    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. Fix performance degradation issue in execution plans that use a spatial index

    This suggestion is in relation to the following known performance degradation bug in SQL Server
    https://support.microsoft.com/en-us/help/3212023/performance-degradation-when-you-upgrade-from-database-compatibility-l

    Essentially the bug can lead to some exceedingly long execution times when the spatial query returns a large result set.

    To summarise, a spatial Index is efficient where a small portion of the records points (of the total table) are intersected by an "area of interest geometry".
    The spatial index quickly discards irrelevant records and can quickly lookup smaller subsets of records to see if they match the spatial criteria.

    However, when the "area of interest geometry" intersects a large portion of the data…

    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 →
  6. SPN access from ODBC connections

    Based on https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview#connect-by-using-azure-ad-identities SPN with Azure Active Directory Password, Integrated Universal with Multi-Factor Authentication are supported for Azure SQL, however AAD SPNs does not work connecting using ODBC, where only Windows Integrated or Windows SPNs (service accounts) are supported for server based non-interactive ODBC connections. Could it be possible to use AAD SPNs wtih secrets/certificates with ODBC?

    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. SQL PAAS Database - Azure Portal Export/Import Feature enhancement

    We are facing slowness issues, failure due to low memory-complex schema for multiple databases while performing Export/Import from Azure Portal.

    Refer multiple case raised so far,

    120091623000488 | backup failing while Exporting from portal
    120091623001199 - DB Export in pending status
    120091123001736 - DB Export in pending status


    • SQL PAAS DB Import/ Export functionality -Estimation can’t be provided for any activity initiated through portal.

    • Export for small size db ~28GB goes in to pending state for 20hrs., then failed with error pointing to VM level low memory ,complex schema ,use sqlpackage.
      -Unable to get exact bottleneck for schema (explored option…
    5 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 →
  8. Allow ReadScaleout environments to be filtered when Azure SQL Database audit logs are output to LogAnalytics.

    When I output the Azure SQL Database audit log to LogAnalytics, there is no information available to filter the ReadScaleout environment; when I output it to Blob Storage, the information is isolated by outputting it to the RO directory. I'd like to add a property that tells me it's ReadScaleout when I output to LogAnalytics

    5 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. Failover on elastic pool level

    We are looking for an update/feature to have failover of SQL database at elastic pool/standalone db level with single FG group as majority SQL unavailability/maintenance occurs at elastic pool level.

    So instead of maintaining different FG group for each elastic pool/standalone DB, portal should ask for which elastic pool/db you want to failover instead of failing over all the elastic pools/db added into the FG.

    6 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 →
  10. Reserved Public IP Address

    We are looking at setting up 2 Azure SQL Managed Instance Servers, talking to each other via Linked Server, in 2 separate subscriptions. Our preference would be to whitelist the Public IPs, but supposedly Managed Instances do not have static Public IPs.

    Could Reserved Public IPs be extended to Azure SQL Managed Instance? I doubt we are the only ones with this problem.

    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. SQL Export to support Storage account with Firewall

    We unable to automate our SQL data refresh process by using New-AzSqlDatabaseExport as it does not support using a storage accounts with firewall enabled. Risky backing up corporate data onto storage accounts with any firewall in place.

    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 →
  12. Add better logging for Data Sync (per I/U/D and per table)

    At the moment the only log information for Azure Data Sync is number of processed rows in both directions. I would like to see in addition number of deletes, inserts and updates per table.

    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 Utilization graph doesn't work on Fsv2 Elastic Pools

    We have moved one of our elastic pools across to the new preview Fsv2 servers and the Resource Utilization graph no longer works.

    Would be good if they worked

    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 →
  14. Linked server support in azure sql database

    I'd like to connect to Oracle DB from Azure SQL Database via Linked Server. Unfortunately, Linked Server this is not supported in Azure SQL DB. It is supported in Azure SQL Managed Instance, but with limited number of targets: SQL Managed Instance, SQL Database, Azure Synapse SQL and SQL Server 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 →
  15. Not possible to generate a .bacpac when SQL MI encounters "references" on any table

    When attempting to use to generate a .bacpac , SQL MI fails on doing that when it encounters a reference on any table.

    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. Create an option to auto-register an Azure SQL database to Azure Data Catalog when a database is created or modified.

    In order to register an asset in Azure Data Catalog, someone has to login to the catalog and then provide information about the database they want to catalog. It would be beneficial if the the registration happened automatically when the database is created and updated when changes occur in the database. So the idea would be to create the link between the catalog and the data store in the data store creation interface. When a DBA creates a database, they can automatically register the asset and those assets appear in the catalog without a catalog administrator having to determine which…

    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. Primary DB and secondary DB can be dependent on each other in the backup retention

    If we did a failover to the secondary node, the database backup retention will not use the policy of the primary node.

    Due to it is an HA mechanism, we hope the primary DB and secondary DB can be dependent on each other in the backup retention.

    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. Always encrypted with Security Enclaves

    Provide sercurity enclaves for SQL Azure and SQL managed instances. Allow inequality comparison and pattern matching searchs.

    https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-enclaves?view=sql-server-ver15

    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 →
  19. Give Azure SQL Serverless users the ability to control underlying storage speed.

    Azure serverless SQL is a great efficiency for SQL workloads that perform daily tasks or tasks that need a large amount of power for a short period of time and pause afterwards... but it is currently useless for queries that use a lot of writes. The CPU being the only scalable thing in Azure Serverless SQL means that despite increasing the CPU, you will never gain better performance. One thing to note is that the underlying storage being so slow, will cause the serverless sql to run so much longer, costing us MUCH more per month than if we don't…

    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. Fix the database selector in SSMS

    Changing the active database in the SSMS toolbar causes the application to fail if the new database cannot successfully connect.

    If you select a database for which your user does not have permissions or manually type in an incorrect database name then SSMS gets stuck in a loop of errors. The application will either be "not responding" or showing you an error. You can acknowledge the error dialog but the application goes unresponsive again until the next error.

    The only way I've found to break this cycle is to "End Task" the application and start again.

    The "not responding" state…

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

SQL Database

Categories

Feedback and Knowledge Base