SQL
Always Encrypted feature in SQL Server
Category: Azure,Azure SQL,Encryption,SQL,SQL Server Author: Nishant Rana Date: 3 weeks ago Comments: 0

Always Encrypted is used for encryption at the column level rather than the entire database. It provides both data at rest as well in memory (in flight). It is different from column (cell-level) and Transparent Data Encryption (TDE) which uses keys and certificates, which are stored in the database. In the case of Always Encrypted, … Continue reading “Always Encrypted feature in SQL Server”
Source: Nishant Rana


Dynamic Data Masking (DDM) in SQL Server
Category: Azure,Azure SQL,DDM,Masking,SQL,SQL Server Author: Nishant Rana Date: 3 weeks ago Comments: 0

Through the Dynamic Data Masking feature in SQL Server, we can hide the sensitive data by masking the data from the user who does not have permissions. (Here the data in the database is not changed). There are 4 different functions to do that – default – Entire column is masked. partial – only works … Continue reading “Dynamic Data Masking (DDM) in SQL Server”
Source: Nishant Rana


Query CDS Data using SQL from Power BI or SSMS (Preview)
Category: Power BI,Power Platform,SQL,SSMS Author: Manish Rawat Date: 5 months ago Comments: 0

Recently Microsoft has announced a preview of an additional way to access read-only data in CDS. The TDS endpoint for CDS allows read-only access to the system for reporting and analytics. The Tabular Data Stream (TDS) Protocol endpoint is managed by an administrator. So far,  the CDS OData endpoint served as the single access point for all types of operations. In […]

The post Query CDS Data using SQL from Power BI or SSMS (Preview) appeared first on Knowledge From Manish.

Source: Manish