SQL Server Data Classification – Importance of Proper Naming

Hello Friends,

In one of my previous blog post we have seen Data Classification tool in SSMS. This tool helps us in four steps – Discovering, Classifying, Labeling and Reporting of sensitive data. This tool classifies columns based on column name. if you will not have meaningful column name then this tool will not help you. To read more about this tool you can click here.

Let me show you the importance of having proper column naming conventions with example. First, I am going to create a database and a table with proper column names under that database:

USE [Master]
GO
CREATE DATABASE [ColNameTest]
GO
USE [ColNameTest]
GO
CREATE TABLE [dbo].[ProperColName](
	[FName] [varchar](50) NULL,
	[LName] [varchar](50) NULL,
	[AddressLine1] [varchar](250) NULL,
	[AddressLine2] [varchar](250) NULL,
	[City] [varchar](100) NULL,
	[PostalCode] [char](10) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[ProperColName] ([FName], [LName], [AddressLine1], [AddressLine2], [City], [PostalCode]) 
VALUES (N'Prince', N'Rastogi', N'Harwin Road', N'Apartment No. 4444', N'Richmond', N'23060')
GO

Now run Data Classification on this new Database:

Data Classification - Improper Naming Convention 1

In output, you can see all column are classified using this data classification tool:

Data Classification - Improper Naming Convention 2

Now let’s create a new table with improper naming and run data classification tool again:

USE [ColNameTest]
GO
CREATE TABLE [dbo].[ImproperColName](
	[FirstN] [varchar](50) NULL,
	[LastN] [varchar](50) NULL,
	[ADL1] [varchar](250) NULL,
	[ADL2] [varchar](250) NULL,
	[Cname] [varchar](100) NULL,
	[Code] [char](10) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[ImproperColName] ([FirstN], [LastN], [ADL1], [ADL2], [Cname], [Code]) 
VALUES (N'Prince', N'Rastogi', N'Harwin Road', N'Apartment No. 4444', N'Richmond', N'23060')
GO

Data Classification - Improper Naming Convention 3

Now you can see that we didn’t get the improper naming columns under data classification report.  For data classification you can add such column manually to data classification report:

Data Classification - Improper Naming Convention 4

As a Data professional we should always use proper meaningful names for objects.

HAPPY LEARNING!

Regards:
Prince Kumar Rastogi

Follow Prince Rastogi on Twitter | Follow Prince Rastogi on FaceBook

 
Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Avatar

About Prince Rastogi

Prince Rastogi is working as Database Administrator at Elephant Insurance, Richmond. He is having more than 8 years of experience and worked in ERP Domain, Wealth Management Domain. Currently he is working in Insurance domain. In the starting of his career he was working on SQL Server, Internet Information Server and Visual Source Safe. He is post graduate in Computer Science. Prince is ITIL certified professional. Prince likes to explore technical things for Database World and Writing Blogs. He is Technical Editor and Blogger at SQLServerGeeks.com. He is a regular speaker at DataPlatformDay events in Delhi NCR. He has also presented some in depth sessions about SQL Server in SQL Server Conferences in Bangalore.

View all posts by Prince Rastogi →

Leave a Reply

Your email address will not be published. Required fields are marked *