Azure – You can now Data Discovery and Classification for free for Azure SQL database and Synapse Analytics

You may already know that Azure SQL has a feature called Data Discovery and Classification which helps you to identify if sensitive information are saved in your databases (you can have more details hare

Previously this Data Discovery and Classification was only available as part of the Azure SQL Advanced Data Security (now called Azure Defender for SQL).

Well, good news, you can now use this feature for free without having Azure Defender for SQL.

To start using the Data Discovery and Classification, logon to your Azure portal ( and access the SQL database or Synapse Analytics resource you want to enable


There access the Data Discovery & Classification blade (under the Security section)


Then you can add a data classification by access the Classification tab and create your classification details

image_thumb[2]  image_thumb[3]

If you don’t have a data classification defined, you may still have already some recommendations based on the default information types defined by Microsoft (public, GDPR, confidential).


You can configure these information type by accessing the Configure blade from the Overview tab

image_thumb[5]  image_thumb[6]

Benoit Hamet
Benoit Hamet
Benoit is working on Microsoft collaborative technologies He has been awarded as MVP for more than 12 years Currently MVP on Office 365 after being awarded on SharePoint (2011-2012) and Windows client & server (2002-2007) Speaker at various Microsoft events (TechDays, TechNet seminars) and Quest Software He works on on-premises (Active Directory, RADIUS/NPS, Exchange, Skype for Business, SharePoint, SQL, Terminal Server, Windows client and Windows Server) or online (Azure, Intune, Office 365, Exchange Online, SharePoint Online, Skype for Business Online, Teams) technologies