THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » naming conventions   (RSS)
  • Enforce SSIS naming conventions using BI-xPress

    A long long long time ago (in 2006 in fact) I published a blog post entitled Suggested Best Practises and naming conventions in which I suggested a bunch of acronyms that folks could use to prefix object names in their SSIS packages, thus allowing easier identification of those objects in log records, here is a sample of some of those suggestions: ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 10, 2013
  • Suggested Best Practises and naming conventions

    Once upon a time I blogged at but that ended in August 2009 when I left EMC. There is a lot of (arguably) valuable content over there however certain events in the past leave me concerned that that content is not well cared for and I don't have any confidence that it will still exist in the long ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 29, 2012
  • T-SQL Tuesday #20 : T-SQL Best Practices

    T-SQL Tuesday, the invention of Adam Machanic (@AdamMachanic), is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and then after all the submissions are in, writes a summary of all of the entries. This encourages people to participate in the community more ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 12, 2011
  • The curious case(s) of the Microsoft product naming department

    A long time ago, in a galaxy far, far away... Okay, it was here on earth, a little over 5 years ago.  With SQL Server 2005, Microsoft introduced a very useful feature called the DAC.  DAC stands for ''dedicated administrator connection''... you can read about it here, but essentially, it allows you a single connection into the server ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 20, 2010
  • Enforcing naming conventions using database unit testing

    My naming convention obsession Anyone that has ever worked with me will tell you that I am a stickler for naming conventions. I have a somewhat obsessive reputation for it; I can’t help it – I seem to have a deep seated uncontrollable desire to ensure that every object in my database(s) is/are named consistently (is there anyone else out there ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 5, 2010
  • What's in a name?

    In a lot of my projects, the issue of naming/coding conventions comes up.  I am a big fan of PascalCase/plural for tables and views (e.g. dbo.CustomerAddresses, dbo.OrderDetails), PascalCase for column names (e.g. FirstName, HomePhone); and for stored procedures, I am partial to the Entity_Action naming convention (e.g. dbo.Customer_Create, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 22, 2010
  • Bad habits to kick : inconsistent naming conventions

    In my last post in this series, I talked about using the schema prefix, with particular focus on dbo-only systems.  In this post, I want to treat the use of inconsistent naming conventions. Stored Procedures In one of the systems I've inherited, we have stored procedures written by different people (or even by the same people at ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 11, 2009
Privacy Statement