SQL Database

  1. Azure SQL Database copy operations shouldn't require write access to the source database

    When performing a database copy operation between two different servers it appears that write access is required to both the destination server and the source database.

    See the following error from the Az CLI:

    $ az sql db copy \
    --resource-group source --server source --name source \
    --dest-resource-group dest --dest-server dest --elastic-pool dest --dest-name dest
    ERROR: The client '<client>' with object id '<object id>' has permission to perform action 'Microsoft.Sql/servers/databases/write' on scope '/subscriptions/<subscription>/resourceGroups/dest/providers/Microsoft.Sql/servers/dest/databases/dest'; however, it does not have permission to perform action 'Microsoft.Sql/servers/databases/write' on the linked scope(s) '/subscriptions/<subscription>/resourceGroups/source/providers/Microsoft.Sql/servers/source/databases/source'.

    This isn't ideal in use cases where you're automating the copy of…

    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 →
  2. Support CLR triggers on the Azure SQL DB

    Support CLR triggers on the Azure, SQL PAAS DB, Presently its available on Named instance.

    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 →
  3. Replicate the logins to secondary replica in failover group in Azure SQL Database.

    We used to have sp_help_revlogins script in onpremises which used to help us in migrating the logins and passwords of SQL server to another instance. Coming to Azure SQL Database, where we have N number of logins we are unable to create the sp_help_revlogins stored procedure in master database in order to fetch the logins data. As it is the logical master and not the actual master. Hence, we do not have the write permissions to it. It would be great it this logins and user migration can enabled which would help us to configure failover groups and migration seamlessly.

    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. Support serverless mode for SQL Database Hyperscale as well

    It's so useful for daily batch job or so. We want to avoid unnessary management task for it.

    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 →
  5. Support serverless mode for SQL Database Hyperscale as well

    It's so useful for daily batch job or so. We want to avoid unnessary management task for it.

    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 →
  6. Notification when a planned failover event occurs.

    Database instances will failover when the backend decides it is needed to better balance the Azure Service Fabric for the platform.

    We would like to have a way to get notified when these events occur.

    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. CREATE an ApplicationID and UserID

    After connect String DBMS unique ID, is created in Application Insights, I want to use that Unique ID and give access to objects based on Unique Id from the DBMS that was encrypted is not accessible outside the MS Sql Management Studio and Portal.Azure.Com and give access, so no one can access to database connection string information from outside 3rd party tool, they have to resort to the old fashion secured method to make database calls using server related connection information

    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. 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 →
  9. Display the Current Scale of Databases on the Dashboard

    Hi Azure, is it possible to include the current scale of databases on the dashboard so that it will be easier for us to monitor the utilisation. Thanks.

    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 →

    Thanks for the valid suggestion. Your feedback is now open for the user community to upvote which allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.

  10. Make Standard Reports Available for Azure SQL

    It has always been helpful to be able to right click on a database, go to Reports -> Standard Reports and run things like "Index Usage Statistics", etc. I know you can get it all via DMV's, etc. but it's nice to be able to just click a couple times and get a report generated.

    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 →
  11. whitelist export services IP

    In order to improve security in an SQL Azure environment it is better to turn off the firewall option "Allow Azure Services".
    But when turned off, you cannot use the portal anymore to export databases. You then have to use SSMS or SQLPackage.
    It would be interesting if we could allow certain services from Azure without allowing all Azure IPs.

    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. Create PostgreSQL DB in portal from pg_dump

    I can create an Azure SQL DB in the portal from a BACPAC. Please add the ability to create a PostgreSQL DB in the portal with the output from pg_dump.

    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. being able to sync couple of tables from a database with more than 500 tables

    Unable to process a schema with 723 tables, 500 is the max!

    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 →
  14. Add schedule for AzureSQL

    I'd like to have a way to simply schedule Stored procedures in AzureSQL.
    I don't want to write a function every time I need a table to be cleaned up every month.

    It could be as simple as having a CRON field and a StoredProcedure name in the SQL Server properties.

    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 →
  15. Yahoo customer service number

    Yahoo is known to offer best ever services, but with the course of use facing issues with Yahoo products and services is common. There
    are numerous issues which are common for Yahoo users while others occur seldom, but both are equally dangerous for your Yahoo email
    account. There are various ways to reach the experts, but calling the Yahoo Customer Service Number 0800-404-9736.visit site -
    https://contactcustomercare.co.uk/

    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. Need to adjust the server time to a non-UTC timezone

    Being based in the UK, we are having an issue since the daylight time changes occurred recently. We have a delivery/scheduler within our checkout process which is set for UK time and this has caused us a problem. It would be very easy to resolve if we could change the server time within the portal.

    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 →
  17. Changing database Owner does not remove permissions from 'old' owner.

    When executing 'ALTER AUTHORIZATION ON DATABASE::myDb TO [user1@mydomain.com]' this does not appear to revoke permissions from the previous owner. It appears to allow all previous 'Owners' full access.

    6 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 →
  18. Bug: DDL Triggers are NOT disabled during Bacpac import

    During the import of a Bacpac DDL triggers are not disabled and therefore are fired on each trigger defined DDL operation as they are carried out during the import process.

    An example of this is a trigger firing on ALTER TABLE actions, where the import process is recorded by the trigger in an audit table. However when the contents of the audit table itself is attempted to be imported a duplicate primary key error is thrown as the import process has already written rows to the table.

    As an example:
    Create a DDL trigger using the attached text file on…

    23 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 →
  19. Hire Professional Packers and Movers to Relocate Your Office

    Thinking about to shifting at your favorite place but also, worry about your content that how to do all the packing of heavy content?
    Then, you have no need to worry just know about best service providers who have the best packers and movers in delhi which will give you a hassle-free move. And that is “delhi packers movers”, they have best packing and unpacking services and you can get this by making a call . Visit us here: https://delhi-packersandmovers.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 →
  20. Please add details in Activity Logs (Firewall enable)

    There was a situation that we don't able to login to our database. We investigated and found out that the Firewall settings (Allow Access to Azure Services) of that database has been turned-OFF. So we turned it ON. we don't know who turned OFF the switch. So we go to the Activity Logs, and we see who are the people who touch the settings but unable to determine who turned-OFF or ON since there are no word "ON" "OFF" in the activity logs. Can you include this to the Activity Logs? for us to determine who actually turned-OFF or ON…

    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 →

    Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.

  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base