Azure Synapse Analytics
-
Row-Level Security
It would be great to implement Row-Level Security on SQL Data Warehouse.
That would be a great solution for scenarios where (for example) we have clients like PowerBI using data from SQL warehouse, and persons who have limited data access.159 votes -
120 votes
We announced GA support for this at Ignite Nov. 2019.
-
SQL Data Warehouse endpoint in the Virtual Network
Currently Azure DWH is only accessible using the host name of logical SQL Server and all traffic goes through public Internet.
Would be great to have an endpoint with a reserved IP within the Virtual Network to ensure given logical SQL Server is seen as an internal resources within the corporate network.
103 votesWe have released virtual network support for Azure SQL Data Warehouse. Please see the blog announcement here:
-
Authenticate from Azure AD
Allow users to authenticate using Azure Active Directory in addition to SQL Server authentication.
30 votesThanks again to all of you for sharing your feedback with us. We have completed this feature and it has now been deployed world wide. 6233962
-
Azure AD Universal Authentication Integration in Visual Studio
Organizations with MFA requirements have to use AD Universal Authentication to log into Azure SQL DB/DW. This can be done through SSMS, but support for Visual Studio would unlock more users.
20 votesAzure SQL Data Warehouse supports MFA with SSMS, Visual Studio, SQLCMD, BCP tools.
-
Need data encryption and decryption support for data at rest in Parallel Data Warehouse
Parallel data warehouse does not support data encryption and decryption at rest as in previous version of SQL Server. it is very difficult to go with PDW if we are in the position to process PII data. It is necessary to add cryptography feature to make PDW as more secured system for storing data at rest. Even though the cryptography can made through external component (ie., .Net code) the performance will be the question when deal with massive records.
3 votesSQL Data Warehouse supports Transparent Data Encryption (data encryption/decryption of data on disk/at rest).
You can read more at:
https://azure.microsoft.com/documentation/articles/sql-data-warehouse-encryption-tde-tsql/ -
Add XP_LoginInfo (for APS)
With OLTP SQL, the command xp_logininfo helps mapping out security and would be helpful in APS.
1 voteThank you for your suggestion. This request has been forwarded to the APS team for consideration in a future release. 11022371
- Don't see your idea?