SQL Database

  1. Security of Upgrading Sql Azure Database through powershell

    Security of Upgrading Sql Azure Database through powershell :
    Hi Team,
    I am using the power shell script to upgrade or downgrade my Sql Azure Database. PFA file for the same however this command doesn't ask anything related to sql server credential, subscription or anything. Is it not a security threat if anyone just know my sql server name and database?
    Now try to understand from this aspect, in big team people are aware of connection strings but we don't expose sql server credential, restrict IP or sometime gives Read only access but these users can even upgrade the tier.

    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. I think azure sql server should be able to convert a .mdf file to its kind of database or should be able to accommodate it

    I'm working on starting a community banking program and company by August and I'm currently trying out platforms. I found OpenCBS an open source micro finance software, to be very useful but I'm looking to be able to have the database in azure Sql server. I kept getting an error message that the .mdf database creation failed.

    Azure Sql server should be able to convert the database extension or have it in a cup.

    This is very important for me. Thank you Team Microsoft

    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 →
  3. Allow for custom hostnames

    Provide the ability to use custom hostnames for Azure SQL DB's. Even if it's just CNAME to the *.database.net hostname.

    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. OPENROWSET and/or better tools for importing Excel or Access worksheets.

    I am a Mergers & Acquisition financial executive. I often work with large datasets that are not uniform or normalized. In the past, Microsoft Access was my best tool to relate large flat files to other datasets and create reports through Excel. Azure's SQL database is fast becoming a great tool to replace Access. It's also better integrated with Mac Excel 2016. However, Access has a lot of nice automation features that can't be duplicated in Azure SQL database. The OPENROWSET function would be a great feature allowing for importing directly from Excel worksheets and would make automating a lot…

    6 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 →
  5. SSMS Formatting

    CTRL+K+D should automatically uppercase all SQL keywords in addition to formatting code layout.

    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 →
  6. Alert when import/export is completed

    An alert should be sent when the database import or the database export is completed. Now, you can only guess.

    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 →
  7. Alphanumeric ORDER BY

    Please add support of alpha numeric ORDER BY of text values. A good sample you will find here: http://www.davekoelle.com/alphanum.html
    Without this feature is impossible to made a paging (skip, take) of for example file names.

    36 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. limit elastic job parallelism

    Add the ability to limit the parallelism of elastic jobs. Many jobs will use some amount of DTU resources, so without a limit (of say 2 or 4 parallel databases at a time) it starts them on every database simultaneously. This drives the pool to maximum utilization and keeps it there, effectively taking all databases in the pool offline until the jobs are done.

    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 →
  9. Cannot Create a SQL Server (As a Service) in New Portal

    In the old portal we had the option of creating a new SQL Server (As a Service) and then import the our Database using SQL Management Studio (Check the Image 2).
    However in the new portal we do not have the option of creating a new SQL server and only way we can create a new SQL server is by creating a SQL DB and in that wizard selecting a new Server name.

    Will there be a workaround apart from that or will Microsoft has a genuine reason to remove that option?

    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 →
  10. Bring SQL Databases (MS SQL Database as a Service) to Azure Stack

    When is comes to app development on PaaS platforms, Databases and DBaaS are "core" & "can't-live-without".

    I see them already included in first release ;)

    241 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    unplanned  ·  9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. external table query plan improvements

    External tables only support good query plans on the source when the source is: - a table not a view

               - single filtering on primary key
    

    It would be very usefull if the transmission will work also with views and more important with more well formed seletive filtering

    Example:
    Source table has a start-int and an end-int.

    Example:
    The query to get all values where start-int is larger or equal then the lookup value work good. But if the question is done to where the start-int is larger or equal then the lookup and the end-int is smaller then the…

    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 →
  12. external table support for other lobs

    It would be great if external tables would support geography types, since this is by example data which you want to store in one location.
    Now we have to double convert from geography to varchar(max) to nvarchar(max) and back

    10 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 →
  13. Set the time zone for each database at the database level instead of OS level.

    I have clients across the country that I want to encourage to use Azure. Without changing a lot of code in the program I need to set the time zone on each database.

    33 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 →
  14. SQL Database navigation & blade is garbled in Japanese

    SQL Database navigation & blade is garbled in Japanese.

    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. Add support for int128 or a datatype for IPv6

    int128 support is necessary for IPv6.
    You can store a IPv4 in an int64 (bigint).
    But when it comes to IPv6, you can't store them.

    This would be important for any applications/reports that use geolocating.

    PostgreSQL for example doesn't yet support int128, but it supports a datatype IP, which can take ipv6 or ipv4.
    They haven't added int128 support yet, because it's not yet available on all platforms they support.
    For Windows, int128 would be available.

    7 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. Add FSharp.Core to the allowed Allowed Assembly list so that F# can be used to write CLR assemblies

    FSharp.Core can not currently be added to Azure SQL because it is not a SAFE assembly due to several static fields what do not have the readonly attribute assigned to them. None of those fields in FSharp.Core can be updated currently. This would allow us to create F# based CLR assemblies in Azure SQL.

    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 →
  17. Support for DML operations with external tables in Azure

    I've seen it around in a few places that this might be something that's in the works. Is that certain, and is there an ETA on its release? The elastic database queries are a huge improvement, but our application would benefit greatly from write access as well.

    176 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Bug: SQL firwall save button greyed out

    When adding a new entry, or updating an existing entry, the save button in the new portal remains greyed out.

    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. 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. SQL Server Firewall settings if direct from SQL server shortcut on dashboard doesn't seem to save

    If you click through direct from recent all resources on dashboard to SQL server firewall settings, then add client IP, the save button seems to remain disabled. If you visit firewall setting through all resources it works fine.

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

SQL Database

Categories

Feedback and Knowledge Base