Azure DBA

← Customer Feedback for ACE Community Tooling

My feedback

  1. Grantable Schema-level truncate permission

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Azure Synapse Analytics » SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
    Azure DBA shared this idea  · 

  2. DROP IF EXISTS

    78 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  Azure Synapse Analytics » SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Azure DBA supported this idea  · 

  3. Support for spatial data type

    168 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    under review  ·  7 comments  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Azure DBA commented  · 

    This is imperative for using best-in-breed presentation tools.

    Azure DBA supported this idea  · 

  4. Support EXECUTE AS for stored procedures

    30 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Azure Synapse Analytics » SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Azure DBA commented  · 

    We have the same requirement where a design team specifies the DDL (i.e., column/table names, data types, nullability), the database admin team performs the phyiscal implementation (i.e., chooses distribution, indexing) and a third team (ETL) owns the ongoing production loading of the tables.

    It is imperative that one user can define procedures that allow other users to run said procedures in a context where the calling user is known, but the imbedded SQL runs as another user (typically with elevated permission).

    Postgres and Greenplum provide this mechanism with SECURITY DEFINER specification on UDFs. Teradata provides this mechanism via their macro and access rights implementation. I believe other versions of SQL server also provide exactly "EXECUTE AS".

    Azure DBA supported this idea  · 

  5. Resource class override

    38 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Azure Synapse Analytics » SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminAzure Synapse Team (Admin, Microsoft Azure) responded

    We announced workload isolation via workload groups for public preview at Ignite in Nov., 2019. Workload groups allow you to create your own custom resource classes (among other things). Check out workload classification that allows you to assign requests by more than just login information too!

    An error occurred while saving the comment
    Azure DBA commented  · 

    I absolutely agree. When running at low DWU settings, I'm constantly seeing small queries being queued as a time-consuming query from a large/xlarge resource class is running. With only four resource classes, we shouldn't have to manage 4x the userIDs, but instead should be able to specify the default resource class and promote/demote as needed in any script run.

    Azure DBA supported this idea  · 
2 Next →

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice