Enforce Naming Conventions

• 
  Interesting idea. Can you give an example of the convention you'd like to enforce?

  David Atkinson June 14, 2018 15:33

  - 0 +
• 
  Table and stored procedure names should begin with either "app" or "ssp"

  kjmcsd June 14, 2018 15:37

  - 0 +
• 
  Have you thought about using SQL Server's built in policies to enforce this?

  David Atkinson June 14, 2018 15:41

  - 0 +
• 
  I'm looking at that right now.

  kjmcsd June 14, 2018 15:49

  - 0 +
• 
  Nope - but you could write a tSQLt test for it and run it as part of your build/CI processes.

  AlexYates June 14, 2018 16:12

  - 0 +
• 

  I'm finding out that policies only tell you if there are things not meeting standards. They do not enforce or prevent people from not complying with them. I think this would be a good feature to add to SQL Source Control. Adding this on the TFS side breaks SQL source control.

  kjmcsd June 14, 2018 16:25

  - 0 +
• 
  Adding to Alex's suggestion, you might be able to write the tSQLt tests and have them run in a pre-commit hook, which could fail the commit should they not all pass? If this works, it would be a great blog post to share with the wider community.

  David Atkinson June 14, 2018 16:34

  - 0 +
• 
  Yes - that's a better idea.
  
  Do what David said.

  AlexYates June 14, 2018 16:49

  - 0 +

Add comment

Please sign in to leave a comment.