SQL Database

How can we improve Azure SQL Database?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Regarding Alerts - Want to notify whenever login fails anytime

    Alerts can be set to notify login failure but it only be set per user database, not server or 'master'.
    For strict security measures, I hope it sends an alert mail of login failure in spite of destination database.

    10 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • sybase DB support on azure

      To enable feature for running sybase DB on azure , since many applications are running with this type or DB in our Data center and we are not migrating to SQL DB.

      Atleast if stand alone mode support been enabled on azure Iaas , it would add more confidence to customer

      Also many customer are still using this DB and may be due to this limitation other customers may hold decision on migration

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Allow Access to Azure Services should be restricted by service name.

        The option to allow Access to Azure Services should also allow you to specify which Azure services you want to grant access.

        3 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Enable SQL Profiler for SQL Azure

          While the query performance analyzer in the Azure portal is great, it does not allow for the real-time capturing of queries. Instead, it takes a sample and only shows the most "expensive" queries.

          It can be very difficult to figure out problem queries without SQL Profiler working in SQL Azure. Adding support for this would be a huge win.

          16 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • Include an option for sql firewalls to be based on ip geography (ie. country/state-prov), not just by ip (akin to the AD user capability).

            Include an option for sql firewalls to be based on ip geography (ie. country/state-prov). For example, allow sql clients from an ip based in Canada and the US, but not from Canada/Ontario, or US/Florida. Allow an option for disabling any ip known to be an 'anonymous' ip.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Expose Resource Governor for SQL Azure

              If we had the ability to define certain connection DTU limits in SQL Azure it would facilitate common scenarios like using the OLTP database for other, less important requests like reporting without fearing a long running report will cause the application using the OLTP side of things getting slow or unresponsive.

              Basically, just give us access to Resource Governor from on-prem SQL Server.

              25 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Add Parquet support for External Tables

                Even without full polybase support (preferred) we would get a lot of value from the ability to map parquet files in blob storage as external tables in Azure SQL Database.

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Azure Portal Query Editor should remember query after refresh.

                  The new Query Editor is really useful. Old habits die hard however, and I find myself hitting F5 to run the queries. This of course refreshes the webpage and I lose the query I was working on. Please make the query editor remember any previous work after a refresh.

                  3 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Connection to Cosmos DB

                    Please provide support for Cosmos DB ODBC Connection with option to include schema JSON.

                    6 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                    • Send email to administrators when Elastic pool is running out of space even when an alert hasn't been configures

                      To get notified when an elastic pool is running out of space you have to have set up an alert. When something this critical is happening an email could be sent to the subscription admins even if an alert hasn't been sent out.

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Monitor queries on secondary database when read scale out is enabled in Premium tier

                        Monitor queries on secondary database when read scale out is enabled in Premium tier. Currently we can only find out if query is getting executed on secondary database by using SELECT DATABASEPROPERTYEX(DB_NAME(), 'Updateability') but there is no way to identify in Query Performance Insights.

                        4 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Improve dmv sys.firewall_rules.

                          When we add a new IP on the SQL server, the modify_date column, updates with the same values ​​for all rules.

                          Is this a normal behavior?

                          4 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                          • Invoke-sqlcmd with AD - Universal with MFS support

                            Add support for Powershell sqlserver module to query SQL Database with "AD - Universal with MFS support". It appears that only SSMS has this capability.

                            Is there a work around to connect to SQL DB via command line using AD?

                            16 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Suggestions for Azure SQL DB

                              Azure SQL should support SMX compression on NIC's HW level, so that it can reduce the traffic over network and reduce latency. also it should support table partition feature

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • quality

                                Data Quality capabilities allow the user to profile and cleanse their data in Azure based on commonly used Data Quality Standards (dimensions) such as Completeness, Uniqueness, Consistency, Conformity, Validity, and Accuracy.

                                19 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                • transaction log size alert

                                  I need to be able to create an alert which will send me an email when a database's transaction log reaches a certain capacity (like >75% full). A long-running query in an uncommitted transaction can keep transaction log pages from being recycled, and if that goes on long enough, the transaction log can fill up and make my database unusable. I need to know if that's about to happen.

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • SSIS Azure ConnectionManager with resiliency

                                    As seen in the following SO question; https://stackoverflow.com/questions/43727984/ssis-connection-manager-azure-sql-database-intermittent-failure

                                    There is a need for a connection manager in SSIS with build in retry / resiliency in case you connect to Azure DB. The solution with the for loop is not good enough since this can only be used in the control flow of SSIS. When most of the connection errors will occur in the Data flow. You typically don't want to reload all the data you previously loaded in the data flow when a connection error occurs.

                                    3 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Remove-AzureRmSqlDatabaseDataMaskingRule doesnt remove specified rule

                                        Remove-AzureRmSqlDatabaseDataMaskingRule doesnt remove specified rule

                                        If you create 3 DDM rules on a table and then use Remove-AzureRmSqlDatabaseDataMaskingRule, regardless of which column is passed in the -ColumnName parameter the rule on the alphabetically first column name is removed.

                                        4 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Add an option to stop/shutdown the sql server and to kill all active connections

                                          I need an option to shutdown/ stop running the sql database to save resources.
                                          I also need another options to kill all active connections, because sometimes I need to run some queries that can cause data conflict in case there are other active connections.
                                          Now the only workaround I found is to backup the database, drop db and then restore, but it's a cumbersome operation.

                                          3 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 19 20
                                          • Don't see your idea?

                                          SQL Database

                                          Feedback and Knowledge Base