SQL Database

  1. Finnish month, Marraskuuta, in my monitoring!

    Under the monitoring section for my database, "DTU percentage today", it has the month down as Marraskuuta, not November.

    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. Fix the portal bottom buttons

    The footer menu - the dark blue menu with save/export/delete db and etc. blinks like disco for several seconds switching the available buttons haphazardly. After 5-15 seconds, depending on where in the menu am I, it 'relaxes' to the proper buttons which I can use.

    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 →
  3. Thesaurus support in SQL Azure

    SQL Azure do support Full Text Search but thesaurus is not included. I know few partners requesting for this feature because for their ecommerce portal they are using SQL Azure and User Search is an integral part in any ecommerce portal. They are finding it hard to design an appropriate search functionality without out of the box thesaurus support.

    Incase SQL Azure team can take-up this feature that would be great.

    Regards,
    Zainu

    39 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 →
  4. Ability to Add Database From SQL Server Blade

    The SQL Server Blade should have an 'Add/Create Database' button. Button can navigate to the SQL Database Blade, or bring up the appropriate database workflow.

    I didn't see the option on SQL Server Blade, so if it's there make it more visible.

    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 →
  5. Broken link on Database Configure page in old portal

    See the screenshot attached - the link for "Learn More" is broken on Databases -> Pick Databse-> Configure is broken.

    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 →
  6. Azure Sql database password force change on first login

    Azure SQL Database needs a feature, like SQL Server, to enforce password expiration, and MUST_CHANGE for SQL Logins

    93 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 →
  7. Opt-out of Query Performance Insight and drop Query Store data

    Make it possible to completely opt-out from Query Performance Insight and drop Query Store data.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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 →
  9. Provide a way to force "transient" SQL errors for testing.

    When using Azure SQL, transient errors due to throttling, load balancing etc become a fact of life quickly. There are methods to deal with this, but testing that the methods actually work in your server is very tricky or impossible.
    It would be great if there were a way in the portal, or Powershell APIs, to force transient errors in some way. For example, "for the next N minutes return a throttling error for every second operation".
    For examples of the lengths developers go to in order to test this:
    https://github.com/robdmoore/SQLAzureTransientDemo
    http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/connection-resiliency-and-command-interception-with-the-entity-framework-in-an-asp-net-mvc-application

    this is a great deal of tricky code…

    18 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 →
  10. Import data blocked by Preview Portal - what are we missing?

    We need to import excel data into the Azure portal - we did it last week on AWS but friends suggested Azure would be better with better tools, interfaces, etc for our start up going forward. So we set up our DB today in SQL on Azure today to test it - importing one set of data (data sets aren't huge size wise - 1700 rows) - to test if we can move forward with MSFT. The source data is in excel so that seemed like a good idea. But Azure doesn't seem to have any web/portal based import functions…

    8 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. Cannot see any Storage accounts when trying to import a database

    Cannot see any Storage accounts when trying to import a database.

    I have a storage account and a container with the BACPAC file for the database. When I try to import the database the preview portal tells me I have no storage account. :(

    I'm trying to follow these instructions
    https://azure.microsoft.com/en-us/documentation/articles/sql-database-import/

    3 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 →
  12. Easy Alerting on Database Size

    Our small 1GB SQL Azure database recently reached its size limit which affected our web site and services. I'm astounded that there is no easy way within the Azure Portal or management UX to quickly and easily setup alerting on the size limit -- especially considering the impact that not being able to write to our database has had on our website and services.

    Placing some easy alerting on database size within the Azure Portal or management UX would also provide a great place to upsell other monitoring services for SQL Azure.

    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. More granular sizing for Elastic Database Pools

    Currently the sizing of Elastic Database Pools is not very granular. I'd like to be able to adjust the pool eDTU in much smaller increments, e.g. 5 or 10 DTUs at a time.

    Let's say I have a premium elastic pool serving say 20 databases with 125 eDTU and I'm happy with the performance. I get a few more customers so need to add say 3 databases ... there's no way to grow my pool to support the additional load. Either I pay twice as much to have a 250 eDTU pool or I put up with fewer average resources…

    89 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Is it currently possibly with Azure SQL Database to have 1 Primary DB and 8 Active, Readable Secondary DB's(Synchronous or Asynchronous)?

    Is it currently possibly with Azure SQL Database to have 1 Primary DB and 8 Active, Readable Secondary DB's(Synchronous or Asynchronous)?

    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. to allow that synonyms in Azure SQL Database can reference other Azure SQL Databases (in order to use cross database joins from Azure SQL DB

    to allow that synonyms in Azure SQL Database can reference to other Azure SQL Databases (in order to use cross database joins from Azure SQL DB)

    55 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 →
  16. bug: The database firewall rules errors when adding an IP address

    This is true both from the portal (new) and deploying a resource manager template

    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 →
  17. Return to simpler deployment of databases from ssms

    There is no way this email could properly reflect my frustration!
    According to your own help files, deployment is easy (for a simple database - and I'm a simple man, so my databases are likewise): Just "deploy to Azure SQL"
    But:
    ssms 2012 does not support the new Azure sql v12 .. SO ...
    update to ssms 2014 ... oops ... need to upgrade to sp1 (actually only needed cu6, but hey ... what's a download or two) ..
    ssms 2014 sp1 will not deploy to Azure sql ... only to Azure VM
    Yes ... I understand (after prowling the…

    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. SQL Database Metric shows 100% peaks for DTUs in hourly view, switch to Daily shows 50% peaks

    SQL Database Metric shows 100% peaks for DTUs in hourly view, switch to Daily shows 50% peaks.

    I am trying to work around if we are reaching DTU limits and the charts show different values for daily than hourly. Especially when there are 100% peaks in hourly.

    2 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. Support AIB in Full Text Search

    Azure Media Services creates AIB files for SQL Full Text Search. Today they only work in SQL on IaaS. It would be great if they worked in v12 now that we have Full Text Search.

    More info:
    http://azure.microsoft.com/blog/2014/11/03/using-aib-files-with-azure-media-indexer-and-sql-server/

    http://blogs.msdn.com/b/playready4/archive/2014/09/17/what-can-you-do-with-azure-media-indexer.aspx

    0 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 →
  20. Fix a bug that allows external computers to connect to an SQL Server even though there are no IP addresses in the allowed IPs list

    It feels that, if there is some setting that turns on the firewall to be able to connect to MS SQL, it should be easily found. Intuitively, it feels that if I don't specify any IPs in the "allowed IP address" section, nothing should be able to connect to the database and retrieve data. Is there any specific option I have to turn on to make the firewall work?

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

SQL Database

Categories

Feedback and Knowledge Base