SQL Database

  1. elastic job

    Please make public the road map for Elastic Jobs.

    We are currently using the PowerShell Module Az.Sql 1.1.1-preview and we'd like to know when it is expected to become official.

    Also, there is no GUI in Azure to run/schedule jobs, and we'd like to know if there are any plans to improve the GUI experience for Elastic Jobs

    8 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 →
  2. provide query plan in Query performance insights pane in azure portal

    In SQL databases, Query performance insights gives a good view of resource consuming queries. It will be great for developers and operations to have a query plan view for such queries, similar to the one offered in SQL Management Studio.

    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. Generate connection string for Geo-Replica immediately

    In case of DB disaster recovery timing is quite important and DB restoration takes significant time and for us means these steps:
    1) Create new DB from backup (wait for complete)
    2) Enable read-only Geo Replication to 2 regions (wait for complete)
    3) Take connection string from 2 and change devops configs and schedule config build (wait for complete)
    4) Deploy services using config with new connection strings

    So step 3 could be done in parallel to waiting for step 2 if we knew connection string ahead of time and save much valuable time in case of disaster

    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. A feature request from customer: SQL DB should calculate each schema's size for customer automatically

    A feature request from customer: SQL DB should calculate each schema's size for customer automatically rather than let customer use DMV to calculate which is very time and resource consuming.

    Current query:
    SELECT SUM(reserved_page_count)*8*1024 FROM sys.dm_db_partition_stats, sys.objects WHERE sys.dm_db_partition_stats.object_id = sys.objects.object_id and sys.objects.schema_id={0}

    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 →
  5. Elastic job: Add cron style scheduling

    It would be good to be able to schedule elastic jobs to run for example first Saturday of month at 11.00pm.

    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 →
  6. Error out appropriately when trying to restore a .bak file.

    I wasted 9 hours today (plus a week with a Data Box Disk) trying to restore a .bak through the Azure Portal to a SQL Database.

    Because it's not supported, it should have been able to tell me within the first few minutes

    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. Ability to view backup storage usage via Portal, Powershell, or DMV

    As there is currently a $0.10/GB charge for PiTR storage over the size of the database size it will be important to have a way to view backup storage usage so you can best plan how long to have your retention set to best optimize your billing.

    If possible this could be a property in Get-AzSqlDatabase and Get-AzSqlElasticPool.

    45 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 →
  8. 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 →
  9. 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 →
  10. Azure SQL Database serverless manually pause and resume

    It would useful to have the possibility to manually pause and resume a serverless sql database

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Azure SQL DB export PS command need to validate presence of .bacpac value in the storage uri parameter

    Azure SQL DB export PS command need to validate presence of .bacpac value in the storage uri parameter.

    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. sp_createstats is failing on SQL Azure

    When running sp_createstats on an Azure SQL Database it fails with the below message. In order to easy reproduce, create a new SQL database and run the sp_createstats:
    print @@version
    go
    sp_createstats

    Microsoft SQL Azure (RTM) - 12.0.2000.8
    May 2 2019 20:11:13
    Copyright (C) 2019 Microsoft Corporation

    Table 'testDan.sys.sqlagent_jobs': Creating statistics for the following columns:
    Msg 1088, Level 16, State 12, Line 3
    Cannot find the object "sys.sqlagent_jobs" because it does not exist or you do not have permissions.

    As per the official documentation, sp_createstats is supported on Azure SQL: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-createstats-transact-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. improving of deleting azure sql database that call

    Azure SQL Database that to be set dashboard can select delete menu from it ( I attached image png file). It behaves that way only when Auzre SQL database is selected. Selecting other azure resources can not select delete menu. Other resource only can select "Remove this item from dashboard". As a result, the operator executes "Delete from SQL Database" in the intention of "remove from tile".
     I believe that "delete" menu have to delete from when selected from Azure SQL database in dashboard.

    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. InMemory object support for Hyperscale

    Add InMemory object support for Hyperscale. We were going to break up our elastic pool into individual Hyperscale databases, which would have doubled/tripled our subscription costs, but reduce our noisy neighbor problems and give us more flexibility in scaling up/down during processing intensive weekly loads. We cant move to Hyperscale - our loads are 40% faster subquerying from in-memory table variables than temp tables on Azure BC4_Gen_8

    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. best wholesalers in delhi

    DealerSahab is an exciting service listing portal & a new marketplace for manufacturers, dealers, traders,best wholesalers in delhi, and suppliers. It will create your business profile, upload your product detail and customized it’s to get leads in your business area.Your business is not growing and you are unable to reach your customer. You are spending a lot of money on advertising but not getting relevant leads to your brands. Then its time to list your business to DealerSahab.visit - http://www.dealersahab.com/

    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 →
  16. feature need-Sync group also needs to be displayed on Member database and Sync Metadata database side

    Sync group is displayed only on the hub database side.
    It would be great if one could see the Sync group also on the Member database and Sync Metadata database side.

    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. Add cross instance service broker for SQL Azure Managed instance

    The implementation Service Broker in managed instance product is an improvement but is still missing a trick buy not having cross instance capability.

    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 auto-resume reliable

    We've recently moved to serverless SQL. This works generally and is good, but the auto-resume is unreliable. Mostly we see delays of 2-10 secs which is ok. Sometimes its 5-10 mins and we have to try multiple times to connect before the auto-resume kicks in - i.e. our app is reporting DB timeout errors to users while this is happening.

    Please make auto-resume reliable.

    I would have raised a support ticket, but you want to charge me for reporting that your service isn't working - I strongly suggest you allow your customers to let you know when a service isn'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 →
  19. About TLS1.2 Support for "Microsoft ODBC Driver for SQL Server"

    When connecting to SQL Database using Microsoft ODBC Driver for SQL Server, there is no page that clearly describes which ODBC version supports TLS 1.2.
    I would like to write in public information.

    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. Increase max database size for SQL databases

    Allow the data max size to be increased beyond what is currently offered. A max database size of 1 TB for a Premium 6 database is too small. I can move up to a P11 to get up to 4 TB, but we do not need that much compute power.

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

SQL Database

Categories

Feedback and Knowledge Base