SQL Database

  1. elastic job

    Please make public the road map for Elastic Jobs.

    We are currently using the PowerShell Module Az.Sql 1.1.1-preview and we'd like to know when it is expected to become official.

    Also, there is no GUI in Azure to run/schedule jobs, and we'd like to know if there are any plans to improve the GUI experience for Elastic Jobs

    6 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. sync to another database - pull tables for schema despite errors for initial setup

    if there are errors in schema of member db on initial setup, it will not load tables and you have to run a separate powershell to find out what issues are.
    1. log messages don't cut and paste - log needs to be able to cut and paste for easy support and reading of errors.
    2. tables should just not return for the whole database. You should allow tables to show if they don't have errors and grey out or highlight tables with errors.

    Often tables with errors aren't even considered for sync and not needed anyway.

    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 →
  3. About using special symbol such as # in Database name

    Currently, creating with Database name # does not work properly on Azure Portal.
    We will seek urgent measures.
    There are many requests for this content.

    24 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. Sync schema changes

    It would be very helpful if Sync Groups would also sync schema changes. If a new column is added to one of the tables it would be helpful to sync to the other tables automatically.

    Because Sync Group does not do that, I had to write my own program to sync some databases together.

    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. In place up scale sql mange instance

    Mange sql has limitation that can not upscale
    When it is in 16 ip sunset .please make option
    That it can be upscale without creating new bigger instance and restore dbs
    It is very complex and hard to accomplish when
    All different systems attach to smaller instance and due performance issue can not upscale on the fly bigger instance on 16 ip subnet

    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. Bring Scalar UDF Inlining to Azure SQL Database

    SQL Server 2019 was released today with the feature Scalar UDF Inlining. This feature is currently not available in Azure SQL database.

    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 →
  7. create basic plan database by default if it is auto created from SSMS or EF migration.

    This month I have checked my bill and it 352.65 USD instead of 5 USD. I traced and found that it created a database automatically instead of using existing one as I misspelled database name by one letter. It costed me one month salary (400 USD). At least create low cost dbs for Indian users.

    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 →
  8. Зеркала виртуальные в процессорах и графитовых накопителях информации...

    Дублирование + на копирование цепей информации и переноса с жесткого диска и обратно на съёмные графитовые носители (виртуальный 3D накопитель) но переносной, запас объема накопленной информации при зеркалах накапливаеться и обрастает шубой инфо-электронной, при таком девайсе....

    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. Feature Request

    i ran into the document taht VNet whitelisting with service endpoints does not work because of transient issues. Can we get this working pls

    "Endpoints cannot be used for traffic from your premises to Azure services. "

    We need other options besides express route and peering.

    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. Elastic Job Agent : make it possible to send mail on job error/job complete

    A mail should be send to an operator if things goes wrong. A possible link should be provided so you can jump to the error log.

    1 vote
    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 →
  11. Elastic Job Agent : make the history configurable

    You should be able to specifiy the history in times run or in age.
    For example I want to keep the last 50 runs of this job or the last seven day.

    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 →
  12. Elastic Job Agent : Make a Power BI dashboard on de Elastic Job Database

    Would be cool to see which jobs are running in Power BI without accessing the Azure Portal. You can also do analytical stuff like how many jobs went wrong, how long does it run and so on.

    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 →
  13. Elastic Job Agent : Make a conversion command from SQL agent

    Migrate one or hunderds SQL jobs with a single command.
    Pretty easy for the migration from on premise SQL to the azure SQL. Will be a huge time saver.

    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 →
  14. Elastic Job Agent : create a GUI like de SQL Agent

    Pretty clear. A graphic user interface is missing. Should be in SSMS like the SQL Agent

    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 →
  15. Obfuscate passwords in Azure SQL Audit Logs

    When using the query 'CREATE USER xxxxx WITH PASSWORD = 'xxxxxx', the password is stored by Azure SQL Auditing. This password can then be viewed by anybody with access to the SQL Audit Files, and if Log Analytics is configured, anybody with access to the Log Analytics instance. It would be more secure if passwords were not stored to the SQL Audit logs.

    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 →
  16. Restrict the IP address range to a subset rather than the full region when using the redirect policy

    Restrict the IP address range to a subset rather than the full region when using the redirect policy. In the documentation (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture#connection-policy) it states that when using the redirect policy that "clients must allow outbound firewall rules to all Azure IP addresses in the region using Network Security Groups (NSG) with service tags) for ports 11000-11999, not just the Azure SQL Database gateway IP addresses on port 1433". Customer wants to reduce this from all IP address in the region to a smaller subset.

    13 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 →
  17. Add DB tier tile in Azure dashboard

    Please add a tile in Azure Dashboard so you can see the current DB tier. There is a workaround that we can monitor DTU limit (e.g. 3000 DTU) in last 30 minutes, but it does not show the actual current tier. (e.g. S12).

    3 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 →
  18. Keep Azure SQL Premium RS

    Microsoft should reconsider retiring the Premium RS tier of Azure SQL. It provides a service for companies like ours that want to host their QA/Staging environments in Azure but don't need the full reliability of the Premium tier. None of your other offerings will work for us. We make use of In-Memory tables (OLTP). This option is only available in the Premium/Business Critical tiers. Both of which are too expensive for QA/Staging environments. To retire this option without providing anything of comparable value is a mistake. How can customers feel confident in moving their applications to the cloud if Microsoft…

    25 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 →
  19. Navigating away from "Configure" blade of Azure SQL DB always prompts that unsaved edits will be lost

    If you click on the Configure item to launch the configure blade in the Azure Portal for Azure SQL DB, it will always prompt you to discard changes despite no changes not being made. This is obviously incorrect and confusing to inexperienced (or unprepared) users.

    Please change this to only flag if unsaved changes are actually made.

    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 →
  20. Authentication method when connecting

    Authentication method when connecting

    Requests the addition of the ability to turn off SQL Server authentication.
    For security reasons, the goal is to turn on only Azure AD authentication connections.

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

SQL Database

Categories

Feedback and Knowledge Base