SQL Database

  1. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. Provide T-SQL equivalent command for the Switch-AzuremRmSQLDatabaseFailOverGroup

    Provide T-SQL equivalent command for the Switch-AzuremRmSQLDatabaseFailOverGroup

    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. SQL Data Sync no acepta mayor a 500 tablas

    I have a problem, when i try to load my database on premise to the cloud, it marks me the following error can´t crate more than 500 tables

    Can you help me, please.

    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 →
  9. Acquire TabStudio plugin and integrate into SSMS

    www.tabsstudio.com plug-in allows for editor tabs to be displayed vertically on multiple rows, rather than just the default behavior of right-left navigation on a single row when too many opened documents exceed the available width. BTW, that product works for Visual Studio with the same functionality. Add the new configuration settings to Tools | Options |Environment | Tabs and Windows setting page.

    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. database copy different subscription

    I have the need to create a copy of several databases into a different subscription. Other than copying them to a "server" on the same sub and then moving that server, them copying those dbs to the proper target server, I don't see any other obvious way to do this. I would prefer not to have to make backups to storage accounts first.

    Please add the ability to copy and move a DB to any sql server we have access to on any subscription.

    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. Ability to reduce the number of decimal places lat/longs are written to WKT or GeoJSON with

    Ability to reduce the number of decimal places lat/longs are written to WKT or GeoJSON with. We have reduced our Json payload by well over 50% by reducing the lat long to 8 decimal places. This is still gives us about 1cm accuracy. However we have had to use C# code using sqlserver.types running outside Sql to perform this task. It would make like much easier if we could do this natively – the only way I can see to do this is SQL is through string manipulation.

    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. Missing Firewall option in new portal

    I read in some documentation that I can set firewall options in the new portal. However, I can't find it anywhere in the new portal.
    I had to switch to the old portal to allow my IP addrress access.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    I do see that the documentation here needs fixing (will submit this request to the content team):

    https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/

    In the meantime, you can do the following:
    If you’re not currently connected, connect to the Azure portal.
    On the default blade, click SQL servers.
    On the SQL servers blade, click the server on which to create the firewall rule.
    You’ll see a blade with a Settings section and “Firewall” as an option.

    Thanks for submitting this feedback.

    Best Regards,

    Joe Sack
    Principal PM, SQL Server and Azure SQL DB

  13. Fix the database storage quota calculation in V12

    It looks like the quota calculation reported in the portal may be double counting ... possibly from sys.indexes.
    I'm uploading a database at 75GB including indexes. The Azure SQL Database except for PK's does not include the indexes so the upload is certainly less than 35GB. Yet, it reports an exceeding 250GB storage quota error.

    If I'm wrong, please do let me know.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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 General Purpose service tier supported region

    We were trying to deploy Gen4 resources in different regions. But some deployments fail due to some regions not supporting Gen4. In the Documentation, we found that Australi region is not supporting. But we found that "UAE North", "UK South", "UK West", "South Africa North" and "France Central" also not supporting Gen4 resources. Is it poosible to add this to documentation.? It might help developers to time. :)

    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. D365 has settings for max threads. You do not provide this needed information. I need to know how many cores each tier level supports.

    Need you to provide core-count for each service tier. I don't know why you leave out this information since D365 has settings where number of cores has to be considered.

    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. Run Microsoft Flow when alert

    I want to run automation by Microsoft Flow when Azure SQL Database alert.
    for do business workflow with no-code by everyone.

    My scenario:
    1. When Azure SQL Database alert, notify DBA, and add it to the support system

    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. Want To Shift Then Know About Packers and Movers Noida?

    From planning your relocation, to packing and wrapping your belongings and assets with proper care, to loading and unloading, to rearrangement, our proficient moving experts keep a close eye on each and every phase of the relocation process to tackle any type of possible issue. As a rapidly growing and eminent Packers and Movers in Noida and the surrounding area, we take pride in providing client friendly and professional logistics services to achieve utmost client contentment. Packers And Movers is well known service specializing in residential relocation in and out from all major cities within India.
    For More Information Visit…

    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 →
  19. For the free trial, as a developer, I should be able to utilize the use of SQL Express database for member authentication.

    For the free trial, as a developer, I should be able to utilize the use of SQL Express database for member authentication without having to pay for the cost of creating a VM.

    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. DTU resizing suck Databases

    DTU resizing takes the running DB tasks in the name of current transactions. At any point in time the running database should not go offline. The Azure support executive mentioned that currently there is no such feature, but it's really important for Microsoft to ensure the services are online always. You cannot call it as feature of your bug!

    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