SQL Database

  1. Subscription dropdown when creating SQL Database

    In portal preview I accidentally created new sql server in wrong subscription. When I try to recreate in correct subscription it now says server name is already taken.

    In my numerous attempts at trying to recreate, I noticed that if I do create the server prior to selecting the subscription it then wipes out my data entry when I switch my subscription choice, which I kind of expected. Therefore I would place the Subscription dropdown prior to selecting/creating what server you want your database on.

    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. Allow SQL Database to be a subscriber in transactional push sql replication

    Now it is virtually impossible to keep an on-premise database and an Sql Database in sync. E.g. With Microsoft Sync Framework, which is batch based and not transactional, tables can be out of sync when syncing.

    24 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 your feedback here. We are always thinking about how we can improve the integration between SQL Server and Azure SQL Database. There are a number of investments that we are working on.

    We’d love to learn more about your specific scenario. Can you please email me at guyhay at Microsoft.com.
    Thanks Guy

  3. Multiple column Data Masking rule

    It would be great if we can have a Data masking rule to span across multiple columns. Say, if we have a telephone number, mobile & fax number and we can have one rule for all these columns selected, it will reduce the number of rules we need to create.

    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. Tooltips/legend on SQL Azure server icons

    Having upgraded my SQL azure servers to V12 in the new portal their icons have gone from green on top to amber, and don't display any tooltips or legend to explain the significance of the colour. To me amber is an alert colour, but there's nothing wrong that I can tell, everything is working fine.

    Some kind of explanation of what these various non-intuitive states are would be helpful

    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. Readable server name required

    Its annoying to have the auto generated code as server name (while Azure SQL DB Creation) , provide us the readable name giving option.

    2 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 →
  6. Have the Elastic Scale MultiShardConnection implement the IDbConnection interface

    By implementing the IDbConnection interface on the MultiShardConnection we can use this to set up a database context. Most ORMs have a constructor available to set up the dbContext with an IDbConnection. This way we don't have to change the complete DAL when migrating to the Elastic Scale solution.

    11 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 →
  7. SQL database metrics do not show the instance name.

    I want to pin the chart of sql metrics to my start screen for 6 sql databases. Neither the pinned version of the chart, or the detail view when you click on it show the database name. This makes it hard to know what you're looking at. You should be able to edit the title for anything you pin to the start screen.

    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 →
  8. One click subscribe to notifications when long running task completes

    When you initiate a long running task, such as changing SQL Azure service levels from standard to premium, upgrading a SQL Azure server to V12, etc., anything that could potentially take hours, you should be able to receive an email notification of when that task completes. On the notification panel you see when the task initiates. There could be a 'subscribe' button next to the running task that means you will be notified via email when it completes. I hate having to keep coming back to check on a long running task and this would make things a lot more…

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    unplanned  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add reseeding identity support to Azure Storage/SQL

    Please allow us Azure SQL admins to change/reset the identity seed for any table.

    I have two identical tables in two separate databases which I'm going to need to move the data from the one to the other here very soon. I would prefer not to have to delete the table and recreate it just to reset it the identity. In some scenarios, using DBCC CHECKIDENT is the easiest/most convenient method to do this.

    Reference: http://stackoverflow.com/questions/12415434/how-to-reset-identity-seed-in-sql-azure

    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 →
  10. Bug: This resource has been removed. for existing database

    I created a database, then deleted it and then created it again with the same name. Now the Sql databases list in the new portal displays this database, but if I click the database name to show its details I get the error "This resource has been removed."

    2 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 →
  11. Quicker freeing up of resource names

    I have 2 Azure accounts (1 personal, 1 work). In my personal account I had a SQL server named 'abc' for the sake of argument. Deleted it. Tried to recreate it in my work account and get the error 'abc' is already registered as a server name. Guess it's taking a while to realise and let me reuse.

    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. resource utilization chart

    If I pin a resource utilization chart from a SQL DB on the start, it doesn't have the name of the DB so I cant tell which chart belongs to which SQL DB

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Make SQL Azure a database option for SharePoint farms running in Azure IaaS

    We have our SharePoint 2013 on Azure IaaS and we would like to use Azure SQL for our databases instead of running SQL Server VMs.

    We'd also like to use SQL Azure for our Access Services databases. Office 365 does this already.

    37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Need to apply proper UI and proper SQL management studio. The SQL management studio needs to be like locally

    Need to apply proper UI and proper SQL management studio. The SQL management studio needs to be like locally

    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. Provide Better Notification Details

    Since my account reached its monthly limit (billing wise) I was locked out of from performing any additional actions. I started deleting extra databases to reduce the monthly costs and kept getting a vague error: "Failed to delete database". No details as to why this can't get deleted, no details on what I can do next, it simply leaves me locked out. This is a poor experience. I should be able to remove old databases to free up my billing.

    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 →

    Thanks for the feedback. We’re thinking about ways to give you more information in notifications, so that should help you here. In the meantime, you should be able to go to the Events part on the resource group blade to see more information about why the deletion failed. You can also delete the entire group from that blade, too :-P Hope this helps!

    Michael Flanakin

  16. Create Database [X] As Copy Of [Y] In [Tier]

    I am currently using a P2 instance for my live system - obviously there are a number of visitors using this site so when I update it I want to be sure it will work. As a result, I will always run the CREATE DATABASE [staging_X] AS COPY OF [Y] and then run scripts / test a release against that.

    After a few minutes this is up and running. However, this will create a P2 instance at a General Availability price of around £40! Since it's only me that's using it I could get away with a Web edition or…

    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. Don't ruin SQL Azure database import processes when a new browser client is released

    In the middle of a lengthy (over an hour long) SQL Azure database import process, the Azure web page client, in the middle of my "Importing SQL Database" run, informed me that I needed to close and reopen my browser to get the new browser client. Doing so destroyed my import run, so I had to start over again at the very beginning. Since I had two database imports running simultaneously, the pain was doubled.

    Please fix this problem by allowing users to click past this warning message without having to interrupt any processes currently running. A single OK button…

    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. Bigger free SQL DB

    I suggest you to increase free space for sql DB. MongoLab currently gives 500MB for free and this encourages me to choose this database to verify me application. I'd rather choose SQL DB but it's too small for my startup. If my startup succeed it's too late to change database.

    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. Choosing a server for Azure SQL Database shows old deleted servers

    Choosing a server for an Azure SQL Database shows servers that were deleted long ago

    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 →
  20. Add allowed IP - adresses functionallity

    I am missing the management off allowed IP adresses. Please add this in the new portal!

    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