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

Advertisements

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

Selecting the Top N in each Category

When we write queries in TSQL selecting the top ‘n’ number of rows is easy. It can be achieved by a query similar to the following. SELECT TOP(10) Names FROM [Users] WHERE IsActive = 'True' ORDER BY ApprovedOn DESC But when selecting the items which are from different tables and with subcategories this is quite … Continue reading Selecting the Top N in each Category