What are naming standards/conventions for SQL Server? (1/5)


I think it will be good idea to setup some naming standards throughout your database servers’ farm. Most of us already have these standards in place. And if there is nothing, I understand that it’s not going to be an easy task to implement standards, especially within an existing environment. BUT, it’s never too late. Let’s have something now.

 

Server name – <Three or Four Characters for Datacenter location> + <Two, Three or may be Four characters for Server type> + <three or four digit number>

Location example: USA, IND, DEL, LON, ZUR, NYK etc

Server Type example: SQLS, SSIS, SSRS, SSAS, ETL

So, server name should look something like – DELSSRS001 (or DEL-SSRS-001), by looking at the name only, anyone can now understand that this server is for SSRS & located at Delhi (DEL) datacenter. Additionally, you can define standards for named SQL instances.

Database Name – Naming database is a crucial task, it’s like finding a good name for a new born baby. This can be good idea to associate database name with the applications as family name. Like, <AppName> + <Underscore> + <Three Characters for Environment> + <version number>

Example: MyApp_Prd1, MyApp_Dev1, MyApp_UAT2

Data/Log Files – Once database name is set, it comes to Database Files & File groups. Database files should follow the same logic as database name. So, it will become something like

<databasename> + <Underscore> + <dat> + <count number>.mdf

<databasename> + <Underscore> + <log> + <count number>.ldf

<databasename> + <Underscore> + <dat> + <count number>.ndf

Example: MyApp_Prd1_dat1.mdf, MyApp_Prd1_dat2.ndf, MyApp_Prd1_log1.ldf

File Groups : <fg> + <Underscore> + <purpose1> + <purpose2> + <count number>

Example: fg_data1, fg_myindex_1

Stay tuned for upcoming posts on this series.