SQL Database

  1. Create a Server and Import a Database

    As of now you cannot create a server and import an existing database.
    Also need a quick way of creating certificates, and viewing connection data (string).

    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. Elastic job: Add cron style scheduling

    It would be good to be able to schedule elastic jobs to run for example first Saturday of month at 11.00pm.

    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. Ability to create consolidated Vulnerability scan report across multiple sql servers/databases

    Allow to create aggregate reports by sql servers and its databases instead of database by database which does not scale

    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. Multi-database delete UI/UX

    when deleteing just one sql databse the system ask for the db name (good!)... when deleting more than one it just ask to type yes (and there is the problem!) - I selected the prodcution db along with the intended db and **** broke lose cause I typed yes and it deleted both without asking me anythin else... it should ALWAY ASK for the db name regardless of the number of DBs to delete.

    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 →
  5. Total backup storage amount of SQL Databases

    We need to have an option that it permits find the total amount of Azure backup storage used for all databases into the Azure SQL Server, when you have more that five DBs into an Azure SQL Server is too complicated have the total amount.

    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 →
  6. Native support for creating a GeoJSON string from a geospatial type

    Native support for creating a GeoJSON string from a geospatial type. We currently do this by “ToStringing” the geography instance then doing several string REPLACEs to turn it in to GeoJSON. A fast, native function would be awesome.

    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 →
  7. 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 →
  8. Best Flight - Aircanada Airlines Customer Service 1-855-500-0238

    Before customers can proceed with making a reservation online on the website of Air Canada Airlines, it recommended that they get in touch with reservation reps on the Aircanada Airlines Customer Service. Upon doing so, travelers can obtain all the significant information about the latest deals, discounts, best fares and facilities that accompany a reservation. Aircanada Airlines Customer Service is a dedicated helpline that assists the customers round the clock.

    For More Information Visit Here: https://aircanada.airlinescustomerservice.org/

    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 →
  9. more view to database resource utilization like blocking locks, etc. in SQL PaaS

    • more view to database resource utilization like blocking locks, etc. in SQL PaaS

    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. View Designer Bug

    MSSM connected to Azure SQL-DB.
    Unable to add extra tables in View designer.

    Using context-menu: Views > New View
    Select one or more tables - press [Close]
    Right-click and notice that 'Add Table' is disabled.
    It is not possible to add ekstra tables to the View Designer!

    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 →
  11. Get this overengineered **** to work.

    This **** just doesn't work. I've been trying to publish my SQL Server database to Azure for two days.

    Now I'll have to spend 30 bucks a month on Indians who hopefully know the right sequence of dials to turn and buttons to press.

    Maybe that's what Microsoft wants to begin with.

    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 →
  12. Disable Server Admin (after creation)

    Server Admin Login and Password is mandatory during the creation of Azure SQL. Would like it to be possible to delete after creation of server and AAD SQL Admin.

    •There are enough companies who have to rule (inherited from the on-prem) that accounts must be controlled by a centralized Identity Store, such as AAD.
    •Password rotation must be done, it is a lot easier when you have a centralized identity Store instead that you have to do it for a lot of Azure SQL Servers.

    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 →
  13. Option to disable transaction logging in Azure SQL Database

    We are using Azure SQL Database for processing large amount of data and building data warehouse. By default Azure SQL database logs every write operation (DML) which impacts the data processing time. It would be great if there is option (with disclaimer) to disable the transaction logging to use Azure SQL Database for large scale analytical applications.

    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 →
  14. 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 →
  15. Azure Active Directory admin and user-defined database roles

    We've created two seperate Azure AD groups, a group called Admins and a group called Readers.

    The Azure AD group "Admins" is configured as Azure AD Admin on the SQL database making every member of this group a db_owner.

    The second group "Readers" has been created as a contained DB user with the following statements.

    CREATE USER [Readers] FROM EXTERNAL PROVIDER;
    ALTER ROLE dbdatareader ADD MEMBER [Readers]
    ALTER ROLE custom
    datareader ADD MEMBER [Readers]

    The second role custom_datareader is used for row-level security.
    However we've noticed that the role isn't applied if a member is both in the "Admins"…

    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 →
  16. Audit log queue details

    My understanding is that there are buffers in place that limit the number of concurrent writes to audit logs, however that information is not public. Can you share the details of the queue buffer limits or, even better, make this a feature that customers can control on their own?
    Thanks.

    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 →
  17. better mechanism of cross database communication for SQL PaaS.

    better mechanism of cross database communication for SQL PaaS.

    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. Size restrictions - planned to grow past 8TB?

    We have a 6TB database and see the current 8TB limit as the main reason we cannot use it. Are there plans to support larger database size, and if so, can you share at least a guess on the time frame this could be implemented? Are there technical hurdles that would prevent it?

    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. Provide SQL Management in an Embedded version (lite) for small clients. This would be really cool.

    Not all clients are huge and not all of them have hired IT skilled staff. So offering the possibility for developers to embed the Sql Designer into webpages would be really cool. This might not be feasible or even good practice for large databases but small ones, could be a great idea. It might exist already ... If it doesn't ... Please push it to the decision makers. I would even offer to do it for you guys :D

    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 report - Discrepancies typed as 'discrepencies '

    Team,

    Under "Data Security" , while showing vulnerability assessment overview

    VA2061 - Auditing should be enabled at the server level

    Below description has spelling wrong for "Discrepancies "

    "Azure SQL Database Auditing tracks database events and writes them to an audit log in your Azure storage account. Auditing helps you understand database activity and gain insight into discrepencies and anomalies that could indicate business concerns or suspected security violations, as well as helps you meet regulatory compliance.
    For more information see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing "

    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