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
We announced GA support for this at Ignite Nov. 2019.
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 votes
We have released virtual network support for Azure SQL Data Warehouse. Please see the blog announcement here:
Allow users to authenticate using Azure Active Directory in addition to SQL Server authentication.30 votes
Thanks 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
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 votes
Azure SQL Data Warehouse supports MFA with SSMS, Visual Studio, SQLCMD, BCP tools.
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 votes
SQL Data Warehouse supports Transparent Data Encryption (data encryption/decryption of data on disk/at rest).
With OLTP SQL, the command xp_logininfo helps mapping out security and would be helpful in APS.1 vote
Thank 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?