SQL Database

  1. 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 →
  2. Change Data Capture

    Allow Change Data Capture in SQL Azure

    It has been available in SQL server since 2008, the jump to SQL Azure seems logical.

    478 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    34 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Use some of the same naming conventions for links to content as the old portal, or ADD HINTS.

    It took me 20 min to find the allowed IP address to give access to the DB. "Show firewall settings" IS NOT EVEN CLOSE TO "Manage allowed IP addresses". Just add the old content in parenthesis or name it the same so we are not soooo lost trying to find how to do the same thing we used to do. Then later down the road change the name to something else, but at least notify us, don't just change the name and leave us hanging to search like crazy to find stuff.

    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. 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. SQL database monitoring chart rarely displays data

    The older site displayed a warning icon with something about unable to load management data for this resource. I've only noticed this with the database chart but it seems intermittent at best, doesn't provide much value as a dashboard tile.

    13 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 →
  6. [bug] SQL Azure Database Information Not Available in Preview Portal

    Experiencing a repeated bug in the preview portal with Azure SQL Database. Occasionally after altering the service level tier of an existing database that database no longer appears in the Portal UI. The server will still appear, and you can drill down to the database name, but you are never able to access the database details or monitoring metrics via the preview portal. The standard portal works correctly and displays the correct database information.

    24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Read-scale and cross-region database replication

    I am a Principal Program Manager in Azure SQL Database. I want to provide better support for the following scenario.

    I have a web application that is currently deployed in Europe. We expect the business to grow so we will need to expand to other regions. I am using SQL Azure for my DB. The data is relatively small (<10GB) so I don’t want to deal with data partitioning. Also having a single data image will help me with the analytics. I would like to replicate the data to all regions and setup smart routing so that the web front…

    29 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 →
  8. Scale standard geo-replicated secondaries independently of the primary

    Paying for the the secondary to be at the performance level the same is a waste of money. I have a database at S3, this is for reads only as it has very little writes, so having the secondary at this level is unnecessary, I know it has a discount of 25% , but this is way too expensive.
    In the event of a failover, I am quite happy to manually scale the database up to it's required level, but why do I need it at the same level as the primary?

    7 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 →
  9. 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. DONT MAKE AZURE SO ******* COMPLICATED

    GO CONSULT SMARTER ASP, AND DONT MAKE AZURE SO COMPLICATED, I SPENT HOURS LOOKING HOW TO UPLOAD A SIMPLE ******* MDF DATABASE FILE TO AZURE PORTAL. FIRST I CREATED A SQL DATABASE, THEN I WANTED TO IMPORT MY DATABASE, GUESS WHAT, I NEED TO SPECIFY A STORAGE ACCOUNT, REALLY? IT IS A SIMPLE UPLOAD AND CHANGE CONNECTION STRING MATTER. PLEASE, FFS.

    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 →
  11. Wrap names so we can tell which database is which when pinning SQL Azure databases to start

    Wrap names so we can tell which database is which when pinning SQL Azure databases to start

    5 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 →
  12. Fix the Browse SQL databases view (and PowerShell's Get-AzureResource) to return all databases

    I have three SQL Azure databases on a server. After scaling up a couple of databases from S0 to S1, they each disappeared from the "SQL databases" section of portal.azure.com. The other database on the same server is still visible there. All three are still visible in the preview portal when I select "SQL servers" and click on the particular server, but when I try to drill down into one of the "hidden" databases from there, only the most basic information will populate. In particular, the Azure Resource Group shows as "Not Available".

    This all happened about a week ago.…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow transact-sql jobs for all service tiers not just elastic scale databases

    Allow transact-sql jobs for all service tiers not just Elastic Scale databases

    Recently, you rolled out Elastic Database Jobs for Elastic Scale databases which gave users the ability to write t-sql jobs to run on databases. This functionality should be extended to all service tiers so that all users can take advantage of this functionality. While writing jobs using Powershell Runbooks is a serviceable workaround, many organisations have a large amount of jobs that are written in t-sql that would be very difficult to migrate. Giving all users the ability to write t-sql jobs would help to remove this barrier…

    30 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 →
  14. Persist Elastic Scale Split&Merge service status

    Once e.g. a split operation is started via the elastic scale split&merge service and you accidentally close the tab you will no longer be able to access the progress of the operation. It would be great if one could see the ongoing operations once the service is reopened. (Maybe even completed ones).

    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 →
  15. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. No SQL Pricing calculator

    Right now you have exactly nothing in your calculator for estimating the cost of a database server in Azure! Any selection in the SQL options redirects you to the "new" VM calculator which doesn't have any options for SQL Server cost calculations.

    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 →
  17. Ability to create an SQL Server by itself (as was possible in the non-preview portal)

    In the release portal I could easily create a new SQL Server by itself (no need to create a database in it immediately).

    In the preview portal I can only seem to add a new SQL server as part of creating a database.

    I would find it useful if I could create an SQL server independently in the preview portal.

    Thank you.

    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. Defect: Server name is already used

    Defect:

    I created a new server and new database in Azure SQL. I had to delete that server and now I am trying to create server with same name. But it says that server name is already used. I could also reproduce same scenario.

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. SSIS ADO.Net Bulk load removes CHECK CONSTRAINT fro Azure SQL DB

    Since ADO.Net is the only suggested access for Azure SQL , it would be great if Bulk insert will not remove CHECK CONSTRAINT when using ADO.NET destination. Workaround is to use OLE DB, but OLE DB is not a suggested connection for SQL Azure. Also, not using Bulk load will increase the load time.

    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. Bug? SQL Database no longer showing in portal

    In the middle of customising the dashboard of Azure's (preview) portal, I changed a SQL Database tile from 2x2 to 2x1. Bad plan it seems, as the tile's database name disappeared and the tile now simply says "SQL Database". Clicking on the tile takes me to a pretty much empty blade.

    More worryingly, the "all resources" no longer lists my database. The database server blade includes my problem database as being on the server (i.e. in the list of SQL databases), but clicking on the database shows me the same pretty empty blade. (The legacy portal shows the database correctly,…

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base