SQL Database

  1. 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 →
  2. 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 →
  3. 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…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. Export SQL Full and Diff backups directly to blob storage

    If I need local access to a DB backup from the recent past (not the current state), for support or dev purposes, presently I first need to restore a new copy of the database, wait for an unknown amount of time, and then export the bacpac to blob storage.

    I'd like to explore and export the existing full and diff backups directly to blob storage for download, or even better, directly download.

    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. Azure Active Directory admin and user-defined database roles

    We've created two seperate Azure AD groups, a group called Admins and a group called Readers.

    The Azure AD group "Admins" is configured as Azure AD Admin on the SQL database making every member of this group a db_owner.

    The second group "Readers" has been created as a contained DB user with the following statements.

    CREATE USER [Readers] FROM EXTERNAL PROVIDER;
    ALTER ROLE db_datareader ADD MEMBER [Readers]
    ALTER ROLE custom_datareader ADD MEMBER [Readers]

    The second role custom_datareader is used for row-level security.
    However we've noticed that the role isn't applied if a member is both in the "Admins" and "Readers"…

    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. SQL Managed Instance - support the rename of databases when in geo-replication set-up.

    The ability to rename databases in SQL Managed instance. as well as being supported on a single instance, needs to be supported on a databases in an Always On Group. As the Database ID (GUID) could be used to reference the database in the replicated copy; I would have thought this would be a quick win?

    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. Revised response to: Error SQL71564: Error validating element [sql user]: The element [sql user] has been orphaned from its login

    The above error causes a import of a SSMS data tier application (bacpac file) to fail. To generate such an export may have taken a significant amount of time to execute. The resolution to the issue would have been to create the required logins or delete the users and then re-export. A more friendly way of dealing with this would be to prompt during the import process. Provide the option to let the import continue and to not create any orphaned users.

    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. SSMS Export data-tier application should warn if tables do not have a clustered index

    It would be helpful to know up front (issue a warning earlier in the process) that it is mandatory in Azure for tables to include a clustered index. In fact, this is not true as my initial Azure test database contained a table with no indexes at all. Indexes are not mandatory in SQL Server.

    I am sure this is about trying to prevent bad indexing strategies being imported into the Cloud. As a suggestion could you have a check box on the export process "Target export is for Azure". If this is checked then you can warn users about…

    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. Export data-tier application should warn if tables do not have a clustered index

    It would be helpful to know up front (issue a warning earlier in the process) that it is mandatory in Azure for tables to include a clustered index. In fact, this is not true as my initial Azure test database contained a table with no indexes at all. Indexes are not mandatory in SQL Server.

    I am sure this is about trying to prevent bad indexing strategies being imported into the Cloud. As a suggestion could you have a check box on the export process "Target export is for Azure". If this is checked then you can warn users about…

    0 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. Implement Multi DB Export from cmdlets in AZ Powershell

    Implement Multi DB Export from New-AzSqlDatabaseExport cmdlet in AZ Powershell

    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. create elastic job agents

    I want to try elastic job agents service. However when config Preview terms, this prevent my accepted to start this service? So, How could I register this service?

    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