SQL Database

  1. SQL full text search, third party filters

    Search indexing of PDF files is an essential feature which on SQL Server is (currently) only possible through installing a third party filter - which is not possible on Azure SQL databases

    32 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 →
  2. Advance Notification of Azure SQL maintenance

    Customers can receive advance notification for Scheduled Maintenance to Azure SQL Database.
    Currently the notification is sent when update for Azure SQL is applied.
    But the notification is NOT sent when reconfiguration is performed manually due to any maintenance purpose.

    During reconfiguration happens, many batch jobs cannot connect to database and end abnormally.
    Those batch jobs are very important for their business.
    The customer request to send notification before all maintenance which cause reconfiguration.

    32 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. SQLCMD Unexplained behaviour returning output starting with square brackets

    complete explanation at https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b0c08c5d-a6aa-4ec7-9b54-87807cf81548/sql-server-2012-sqlcmd-unexplained-behaviour-returning-output-containing-square-brackets-?forum=sqltools

    Basically, SQLCMD does not behave the same way since SQL 2012 when a message starts with an opening bracket.
    The following command returns an empty string when previous version returned the entire text:
    sqlcmd -b -E -S -Q "RAISERROR('[A][B][C]',10,1)"
    this one removes the firs value between brackets:
    sqlcmd -b -E -S -Q "RAISERROR('[A] [B][C]',10,1)"

    32 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 →
  4. Provide method for accurately determining log free space

    Currently none of the existing methods for determining log space free give a true value when using vCore. With vCore you are allotted a fix amount of space for your logs when you set the storage size. For example, if you specify 1TB of storage, you get 300GB allocated for log. However, if you run something like DBCC SQLPERF(LOGSPACE) you will see the Log Size (MB) and Log Space Used (%) values fluctuate wildly. The Log Size value may say 4947 (4MB) but the Log Space Used shows 99.92%. This leads you to believe that your 300GB of log space…

    31 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. Provide better reason codes for Azure SQL unavailability

    When Azure SQL databases are unavailable the Reason "code" seems to always be "Unplanned". We know from research and confirmation from Microsoft that this can be due to back end service reconfiguration, issues after updates, etc. My suggestion is to provide enhanced reason codes so that we know when there is a problem and when it's due to something expected like back end service reconfigurations. Having a more granular view of the reasons would save a lot of troubleshooting time (for us and for MS). At a minimum, it would be nice to have categories such as:
    Reconfiguration - caused…

    31 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. Add SQL memory utilization monitoring for elastic pool databses.

    Add SQL memory utilization monitoring for elastic pool databses.

    we would like to, know the Resource memory utilization of a databases in the eslastic pool.

    31 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. Add the feature to turn off/on Azure Database for MySQL server

    We need to have the same "Server name" after turning on the Azure Database again, would be nice if some cost would be lower as we just use Storage in a stopped state.
    Cloud is all about "Pay as you go"!

    30 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. Allow transact-sql jobs for all service tiers not just elastic scale databases

    Allow transact-sql jobs for all service tiers not just Elastic Scale databases

    Recently, you rolled out Elastic Database Jobs for Elastic Scale databases which gave users the ability to write t-sql jobs to run on databases. This functionality should be extended to all service tiers so that all users can take advantage of this functionality. While writing jobs using Powershell Runbooks is a serviceable workaround, many organisations have a large amount of jobs that are written in t-sql that would be very difficult to migrate. Giving all users the ability to write t-sql jobs would help to remove this barrier…

    30 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. Add ability in Azure SQL DB to have use minimal logging

    Would like the ability in Azure SQL DB to use minimal logging just an an om premise SQL Server would do. For example, doing an insert into an empty table with only a clustered index and specifying WITH (TABLOCK) should do minimal logging.

    30 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 →
  10. Elastic query without opening firewall to all of Azure

    From the documentation at
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-vertical-partitioning#best-practices

    It says "Ensure that the elastic query endpoint database has been given access to the remote database by enabling access for Azure Services in its SQL DB firewall configuration"

    There should be a way to enable elastic query without allowing anything in Azure to connect by setting "Allow access to Azure services" to ON.

    30 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 →
  11. Shrink the transaction log file after each differential backup

    Currently the log file is only shrunk after each full backup (7 days). To prevent the transaction log file from growing to an unnecessary size, it should be shrunk after each differential backup (12 hours). This should dramatically reduce the size of the log backups saving on backup storage costs.

    30 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. sp_msforeachdb for Azure Database

    SQL Server 2008 through 2016 had this undocumented stored procedure which allowed the DBA's to execute a certain task/script on multiple database at one shot but with Azure database/logical server this stored procedure is no more available.

    30 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 →
  13. Deploy SSDT database project with external tables fails

    During the deployment of a SSDT Database Project with external tables on Azure, deployment fails with this error message:
    2018-07-10T17:23:00.8539155Z Dropping [EDS]...
    2018-07-10T17:23:01.7970626Z An error occurred while the batch was being executed.
    2018-07-10T17:23:01.8200128Z Updating database (Failed)
    2018-07-10T17:23:02.1289225Z ##[error]*** Could not deploy package.
    Error SQL72014: .Net SqlClient Data Provider: Msg 33165, Level 16, State 1, Line 1 Cannot drop the external data source 'EDS' because it is used by an external table.
    Error SQL72045: Script execution error. The executed script:
    DROP EXTERNAL DATA SOURCE [EDS];


    • The Target of SQL Project is target platform 'Microsoft Azure SQL Database V12'.

    • A Azure SQL…
    30 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 →
  14. Make target service objective for scaling operation available via SQL tables/views

    Target service objective was available in slodatabaseobjectives in V11, but it not available in V12.
    This makes admin tasks harder.

    30 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. Support direct upload of bacpac to new or existing database

    Please allow us to support a direct upload of a bacpac file both when making a new database or on top of an existing database. Unless there's something I'm missing, to restore on top of an existing database I have to
    1) move the bacpac into storage
    2) make a new database from storage
    3) rename/delete the old
    4) rename the new

    This process is VERY annoying.

    29 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 →
  16. Read-scale and cross-region database replication

    I am a Principal Program Manager in Azure SQL Database. I want to provide better support for the following scenario.

    I have a web application that is currently deployed in Europe. We expect the business to grow so we will need to expand to other regions. I am using SQL Azure for my DB. The data is relatively small (<10GB) so I don’t want to deal with data partitioning. Also having a single data image will help me with the analytics. I would like to replicate the data to all regions and setup smart routing so that the web front…

    29 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. True SQL DB capabilities on Azure Stack

    We as service providers have demand from the market for PaaS SQL on Azure Stack. The current RP model is not sufficient.
    As a service provider you want to limit and measure the performance per customer.
    As a service provider you want to limit perfomance within a plan
    As a customer you want to select the Performance and DB size when deploying a SQL PaaS database.

    27 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 →
  18. Allow SPN's to create AAD Users

    As we follow best practices and fully automate Azure using SPN's while leveraging AAD for users, we wish to create AAD users in SQL DB using our SPN's.

    When attempting to create AAD users in a database using an SPN, we received this error:
    "Principal 'xxxxxx' could not be created. Only connections established with Active Directory accounts can create other Active Directory users."

    We were told by support that "At this time, the statement CREATE USER [] FROM EXTERNAL PROVIDER; is not supported for SPN."

    Request we make this possible...

    27 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 →
  19. Defect: Server name is already used

    Defect:

    I created a new server and new database in Azure SQL. I had to delete that server and now I am trying to create server with same name. But it says that server name is already used. I could also reproduce same scenario.

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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.

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

SQL Database

Categories

Feedback and Knowledge Base