How to create a Metadata Catalog in Data Governance: step by step
How to create a Metadata Catalog in Data Governance to centralize descriptions, provenance and responsibilities, with a…
4 min
13 Aug 2026
How to do Data Lineage in Data Governance: step by step
Learn how to implement Data Lineage in Data Governance to trace data origin and impact. Practical example with metadata…
4 min
28 Jul 2026
How to create database roles in SQL Server: step by step
Learn how to create database roles in SQL Server to control access by group: create the role, grant permissions, add me…
4 min
16 Jul 2026
How to Create Ledger Tables in Azure SQL: Step by Step
Learn how to create Ledger tables in Azure SQL step by step: immutable history, change auditing and T-SQL verification,…
4 min
11 Jul 2026
How to implement Column-Level Security in SQL Server
Learn how to implement Column-Level Security in SQL Server to restrict sensitive columns such as salaries, using GRANT …
4 min
08 Jul 2026
How to create temporal tables in SQL Server: step by step
Learn how to create system-versioned temporal tables in SQL Server to automatically keep each row's history and query y…
4 min
07 Jul 2026
How to Enable Transparent Data Encryption (TDE) in SQL Server
Learn how to enable Transparent Data Encryption (TDE) in SQL Server step by step and protect data, logs, and backups at…
4 min
06 Jul 2026
How to audit table access with SQL Server Audit
Learn how to audit table access in SQL Server with SQL Server Audit: create the audit, define what to log and see who r…
4 min
05 Jul 2026
How to classify sensitive data in SQL Server
Learn to classify sensitive data in SQL Server with ADD SENSITIVITY CLASSIFICATION: label confidential columns and audi…
4 min
05 Jul 2026
How to implement Row-Level Security in SQL Server
Learn to implement Row-Level Security in SQL Server step by step: create the predicate function and the policy that sho…
4 min
05 Jul 2026
How to mask sensitive data in Azure SQL (Data Masking)
Learn to mask sensitive data in Azure SQL with Dynamic Data Masking. Step-by-step guide to protect emails and card numb…
4 min
05 Jul 2026
Data governance: access control with GRANT in SQL
Learn to apply least privilege in data governance with GRANT, REVOKE and DENY in SQL Server. Step-by-step guide using r…
4 min
05 Jul 2026