SQL Database

  1. Allow using Query Notifications with Azure SQL Databases

    Please allow using Query Notifications with Azure SQL Databases.
    In combination with OutputCache having SqlDependency set the Query Notifications mechanism should reduce web sites load and increase pages response time.

    194 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Problem with the "Allowed IP Addresses" page

    We currently have several IP addresses registered with spaces in the name. The validation on the names is claiming these are invalid. However according to the validation message these names should be fine as they do not contain any of the disallowed characters or end with a '.'.

    Please either update the validation message to state that spaces are not allowed or fix the validation that is causing this problem.

    I have attached an image of the validation message.

    Thank you.

    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. Make it easy to keep database connection details out of source code

    I want to avoid putting my production username/password for the Azure DB in source control where all other developers can see it and thereby have read/write access. This is not easy today. Couldn't it work similar to the way Azure credentials are transmitted during a deploy? Or maybe we could store this data in Azure tied to the account, and copied into new instances as they are spun up?

    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 →
  4. REST service for the enumeration of SQL Azure databases on a SQL Azure server.

    Currently it is not possible to enumerate the databases inside a SQL Azure server, please add a REST service to query databases inside each server.

    12 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 →
  5. Preview portal needs improvement on Database Server Management

    As you try to manage Database Servers in the preview portal you will be see a list of server that you are able to use. The problem is that as i administrator i have to manage on more than 3 subscriptions at the moment and i get a list of databases with the "complicate" names.
    So for management purpose i like to see an improvement on how the Database names appears. I think i a good to see as feature the ability to add a secondary name in databases for Internal use only
    (I don't care for domain name of…

    9 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. Increase the max length of a SQL Aazure administrative password

    The maximum length of a SQL Azure administrator's password is eight characters. That's not secure enough. It should be at least double that.

    5 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 →
  7. Support for migrating existing SSIS ETL packages

    Migrate SSIS ETL packages, which load data to my SQL Azure staging database, to a new ETL service in Windows Azure

    36 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow any SQL user to create database as copy

    According to http://msdn.microsoft.com/en-us/library/windowsazure/hh852669.aspx one of the backup strategies proposed is to copy the database. If that is what is proposed officially, then you can count on people writing scripts, services, worker roles, etc to back up the database. Using the equivalent of the SA to do so is just unacceptable solution. If my code is compromised then I am exposing usernames/passwords (encrypted or not). Furthermore, it's not like I can just remove that user and replace him for some other user.

    We should be allowed to set specific roles to any users so they can copy the database.

    12 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. 21 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 →
  10. SqlBulkCopy.WriteToServer fails on SQL Azure if destination table is temporary

    SqlBulkCopy.WriteToServer fails on SQL Azure if destination table is temporary.

    0 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 →

    Upvotes: 30

    <=-=Oct 25 2011 2:38PM=-=>

    Hi Andrey,

    Thanks for reporting this issue. SqlBulkCopy.WriteToServer does not work in this case because SQL Azure currently does not support temp table. We will route this bug to SQL Azure team so that they can follow up with you.

    Young Gah Kim
    Development Lead
    ADO.NET Managed Providers and DataSet Team

    <=-=Apr 19 2012 6:15PM=-=>

    Hello Andrey,
    Thanks for reporting the issue. The problem is due to the fact that SQL Azure doesn’t support 3-part names for stored procedure calls. In this case, the driver/provider use tempdb.sys.sp_* syntax to access certain stored procedures that provide metadata about objects and these calls fail. We are looking at resolving the issue & enabling 3-part names for tempdb calls.
    Otherwise, you can use temporary tables in SQL Azure fine – we do support it with the restriction mentioned above. Additionally, you can’t create temporary tables…

  11. Enable GZip/Deflate Compression of SQL Azure OData Response

    OData's AtomPub protocol is very verbose. My calculations indicate that AtomPub multiplies Data Transfer Out bytes by a factor of 8.75. (See Querying OData.org’s SQL Azure Northwind Sample Data Service: http://oakleafblog.blogspot.com/2010/03/odataorgs-sql-azure-northwind-sample.html).

    Despite the Accept-Encoding: gzip, deflate header, SQL Azure OData responses aren''t compressed. I agree with this comment by Scott Hanselman - failure to compress OData responses is LAME.

    41 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. Support the dbmail.

    The feature dbmail in SQL 2005 makes email sending much easier, should keep it in SQL Azure.

    66 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 →
  13. Implement FILESTREAM for blobs into Azure Blob Store

    Storing blobs in the database is fairly pointless when you have a dedicated blob store. Implement the FILESTREAM protocol to store blobs in a user's azure storage

    928 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    19 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Support staging/production scenario as in Windows Azure

    This could be done with the future cloning technique or perhaps a more sophisticated one?

    200 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 62 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 →
1 2 36 37 38 40 Next →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base