What you need to know about SQL Database Dynamic Data Masking before the GA

Please read this post after reading this, as some critical changes have gone to the DDM feature of SQL Databases in GA SQL Database Dynamic Data Masking will be Generally Available (GA) very soon by the end of this month. For more information about Dynamic Database Masking please read this article. As per the article … Continue reading What you need to know about SQL Database Dynamic Data Masking before the GA

Hierarchy in TSQL – step by step guide

Hierarchy data type is introduced in SQL Server 2008. It is a CLR data type. This post gives a simple step by step guide to implement HierarchyID data type Hierarchical navigation or simply the navigation between nodes could happen in 2 ways. Depth First Breadth First Having said that, we’ll start the tutorial. Create a … Continue reading Hierarchy in TSQL – step by step guide