Naming Conventions for the Cloud

Question

Naming Conventions for the Cloud

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
May 22, 2017 at 9:04 pm

#321617

Comments posted to this topic are about the item Naming Conventions for the Cloud

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

chrisn-585491 SSCoach Points: 16006 More actions · Answer 1

You could use a local database to keep track of your cloud database objects. :hehe:
The problem then becomes; What to name the local database??? 😛

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 2

My only qualm about naming right now with naming in the various cloud techs is I'm one of those OCD guys who hates that some services force lower case and others allow uppercase. The mix of upper and lower in naming makes me twitch. I either want them all low or all high. I don't want both! 😛

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 3

chrisn-585491 - Tuesday, May 23, 2017 6:28 AM
You could use a local database to keep track of your cloud database objects. :hehe:
The problem then becomes; What to name the local database??? 😛

DB-ception?

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 4

xsevensinzx - Tuesday, May 23, 2017 6:36 AM
My only qualm about naming right now with naming in the various cloud techs is I'm one of those OCD guys who hates that some services force lower case and others allow uppercase. The mix of upper and lower in naming makes me twitch. I either want them all low or all high. I don't want both! 😛

I want both, but I want insensitivity.

bpwilso SSC-Addicted Points: 448 More actions · Answer 5

Steve Jones - SSC Editor - Tuesday, May 23, 2017 8:49 AM
xsevensinzx - Tuesday, May 23, 2017 6:36 AM
My only qualm about naming right now with naming in the various cloud techs is I'm one of those OCD guys who hates that some services force lower case and others allow uppercase. The mix of upper and lower in naming makes me twitch. I either want them all low or all high. I don't want both! 😛
I want both, but I want insensitivity.

The number of times I've been burned by insensitivity... I'll take insensitivity, but only when forced to. I don't like it but I appreciate that it might have a place.

As for naming conventions, we usually use codes to indicate enough information to not need a guide. Not always possible in larger deployments, for those we go the dbception route and have a separate app that serializes the naming of the systems.

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 6

Steve Jones - SSC Editor - Tuesday, May 23, 2017 8:49 AM
xsevensinzx - Tuesday, May 23, 2017 6:36 AM
My only qualm about naming right now with naming in the various cloud techs is I'm one of those OCD guys who hates that some services force lower case and others allow uppercase. The mix of upper and lower in naming makes me twitch. I either want them all low or all high. I don't want both! 😛
I want both, but I want insensitivity.

That's my choice, as well. I was totally amazed when I worked in Oracle at all of the UPPER() function usage burning up CPU time and making criteria non-SARGable because people wouldn't/couldn't/didn't follow their own casing standards. If it's imperative that something be case sensitive, I'll deal with it a column at a time. That's probably easier said than done in non-English-based servers, though.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 7

i CaNt StAnd noT FollOwing Rulez. There must be ORDER! :w00t: