Naming Standards

SQLServerCentral Article

SQL Server Name Convention and T-SQL Programming Style

  • Article

There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]

4.7 (10)

You rated this post out of 5. Change rating

2019-12-10

24,267 reads

External Article

SQL Code Layout and Beautification

  • Article

William Brewer takes a look at the whole topic of SQL Code layout and beautification, an important aspect to SQL programming style. He concludes that once you are tired of laying SQL out by hand, you had better choose a tool with plenty of knobs to twiddle, because nobody seems to agree on the best way of doing it.

2008-05-26

6,244 reads

SQLServerCentral Article

Practical Methods: Naming Conventions

  • Article

Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.

2.62 (13)

You rated this post out of 5. Change rating

2008-02-29 (first published: )

15,012 reads

SQLServerCentral Article

Stored Procedure Naming Conventions

  • Article

As your SQL Server applications grow, chances are that you have more and more objects, especially stored procedures that you need to keep track of. An organized environment is key to being able to prevent the duplication of code and effort. Joe Sack brings us a look at how he names stored procedures to easy identification.

3.86 (7)

You rated this post out of 5. Change rating

2005-10-03

25,369 reads

SQLServerCentral Article

Best Practices for Database Design

  • Article

One of the few things that SQL Server does not automatically help you with is the design of your tales, views, and other database objects. Having standards and design techniques can greatly ease the maintenance of your schema as well as ease the transition to having others work with the database. New author J.D. Gonzalez brings us some of his naming techniques to keep things organized.

2.03 (115)

You rated this post out of 5. Change rating

2008-06-20 (first published: )

52,228 reads

SQLServerCentral Article

Database Standards and Conventions

  • Article

Having a good set of naming conventions for your SQL Server objects is one of the most vital things to a company. In the long duration of a business, it saves money and time as programmers are transferred internally and don't need to relearn object names. As learning curves lower, cost lowers. This article covers some of the conventions that Brian Knight uses and why he uses them.

1.38 (8)

You rated this post out of 5. Change rating

2007-09-22 (first published: )

28,182 reads

Blogs

Choosing to not drive the Tesla

By

I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...

Advice I Like: Transactions and Relationships

By

Life gets better as you replace transactions with relationships. – from Excellent Advice for...

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

Read the latest Blogs

Forums

Limits, Not Goals

By Grant Fritchey

Comments posted to this topic are about the item Limits, Not Goals

Making Additions and Changes; Getting Error Preventing Them

By Ahr Aitch

MS SQL Server/SSMS are my tools. As my project evolves I find I need...

SSL Certificate Chain

By suchit.d@promantia.com

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...

Visit the forum

Question of the Day

Precision and Scale II

What is the precision, length, and scale for an int variable?

See possible answers