SQL Database

  1. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. Delete empty virtual cluster

    This process does not work. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-delete-virtual-cluster
    Delete the empty virtual cluster. It goes away. Refresh the portal. It comes right back.

    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. Provide a way to clear local cache in HyperScale

    While executing some long query, for example deleting and recreating index of large table, sql server fills local pages with all pages for one table and every other query slows entire server down. It takes couple of minutes before server to get in normal speed. I suspect that is due to local pages, if we could easily clear it, it would speed up after executing such long queries.

    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. Enable resource move feature for Azure SQL Managed Instance

    Azure SQL managed instances are not movable across subscription. Provide the ability to move Virtual Cluster and Managed Instance.

    3 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 →
  11. SQL new feature: multiple 'shadow clustered' column

    Imagine a table clustered on identity column ID:

    create table dbo.TAble1a
    (
    ID bigint identity(1,1) not null primary key clustered ,
    Name nvarchar(50) not null,
    CreatedDatetime datetime not null default(getdate())
    )
    insert into dbo.TAble1a (Name) select 'A'
    insert into dbo.TAble1a (Name) select 'B'

    So all rows are clustered based on ID
    Now I 'know' (or I make it) that the CreatedDatetime is actually also sorted because it is aligned with the ID column.

    if we now could say to SQL that the Column CreatedDatetime is 'shadow clustered' so that when we ask:
    select * from dbo.Table order by CreatedDatime desc …

    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. 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 →
  13. 15 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. 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. Use T-SQL to query DB/Server Tags

    I would like to be able to query the DB and server tags via T-SQL so that I can use it in queries

    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 →
  16. SQL instance inventory from ChangeTrackingData

    I am trying to fetch the SQL server instances installed on the machines and also its version. However i am not able to do that using the Azuure Inventory. I should be able to fetch the SQL instance Names , Patch Level of the SQL instance. Also good to capture the features like Is Always on Enabled , Features enabled , etc. Basically this is a basic inventory ask, SCCM does that with out any issues.

    Is there an easy way to do that apart from writing my own custom automation run book ?

    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. Improving of deleting Azure SQL Database that called from dashboard in Azure portal.

    Created tile to dashboard can delete SQL database from itself.
    It behavior is very dangerous that seems from viewpoint of Fault tolerance. Because ,operator want to remove tile from dashboard Nevertheless Misunderstanding of operator to confuse "remove from dashboard" with "delete" is going to be to delete sql database.

    The biggest problem is that only SQL databases can remove resources from dashboards. And It processing is only confirm dialog "yes" , "no".

    I strongly believe that "delete" menu must be delete from dashboards.

    16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. Bug report - Discrepancies typed as 'discrepencies '

    Team,

    Under "Data Security" , while showing vulnerability assessment overview

    VA2061 - Auditing should be enabled at the server level

    Below description has spelling wrong for "Discrepancies "

    "Azure SQL Database Auditing tracks database events and writes them to an audit log in your Azure storage account. Auditing helps you understand database activity and gain insight into discrepencies and anomalies that could indicate business concerns or suspected security violations, as well as helps you meet regulatory compliance.
    For more information see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing "

    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 →
  19. MySQL/PG/Maria Export/Import Feature

    Add feature to export and import MySQL/PG/MariaDB databases

    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. Azure SQL Threat Detection Filters IP from Azure SQL Query Editor

    Today we received an alert as "An unfamiliar principal successfully logged on to server [SERVERNAME]" with some following details:

    Client IP address: 23.96.227.***

    Client IP location: Chicago, United States

    Data center: North Central US

    Client application: Azure SQL Query Editor

    After working with MS Support Technician, it turns out that Detection Threats doesn't recognize internal IP from a server node assigned by Azure SQL Query Editor.

    This alert created huge pressure and noise in order to identify the origin of this connection.

    It is great if any IP from Azure internal nodes are whitelisted by Threat Detection.

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

SQL Database

Categories

Feedback and Knowledge Base