Naming Standards

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

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.75 (12)

2008-02-29 (first published: )

13,967 reads

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)

2005-10-03

22,656 reads

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)

2008-06-20 (first published: )

50,288 reads

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)

2005-02-25 (first published: )

27,790 reads

Blogs

New Centralized View of SQL Resources in Azure

By

Yesterday, some new views were made available in the Azure portal that will be...

Letter To My Father

By

We spread my Fathers ashes over the past weekend. It was one of the...

My Organizer's Notes and Goodbye after #SQLSatBR 2019

By

Some 2019 tips for other SQLSat organizers from my last year as lead organizer...

Read the latest Blogs

Forums

How to copy rows from the same table and update the ID column?

By BOR15K

I appreciate it is utterly trivial question, and yet... When you have a small...

AOAG Secondary Checkdb

By Super Cat

I'm looking into setting up a AOAG with a DR server which will have...

sp_executesql with multiple parameters

By Scott In Sydney

I'm trying to write a stored procedure that will select the entire table if...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers