RSS Feed

Why Database Names Matter

7

November 12, 2009 by Mike Hillwig

There is a reason users shouldn’t be allowed to name their own databases. Actually, there are probably several thousand reasons. I have a new one for you–It makes my life more difficult.

Lets say you work for a company called Acme. And lets say your manufacturing people created an in-house Microsoft Access application with a SQL database called AcmeDatabase.  And lets say that your support organization created a database on a different server called Acme that’s part of their CRM system. On top of that, the ERP system (yet again on a different server) prefixes all four of its databases with Acme_.  As the DBA, you’d never permit this to happen unless you inherit this mess.

Welcome to my world and the mess I inherited. I have my company name (or some form of it) in countless databases. Lets make this just a little more interesting, though. We’re going to be consolidating database servers in the near future and potentially putting all of these databases on the same server.

These are databases that could potentially end up living on the same server:

  • AcmeDatabase
  • Acme
  • Acme_App
  • Acme_Data
  • Acme_Forms

Which one s are ERP, CRM, or Manufacturing?

When we consolidate database servers, we’re also going to be renaming some of these databases. My application owners won’t be too happy about this. They’re going to have to get over that. I inherited this mess, and I’m going to make it right.


7 comments »

  1. […] This post was mentioned on Twitter by Mike Hillwig, AppSecInc. AppSecInc said: Why Database Names Matter http://bit.ly/2hcpH0 […]

  2. Firoj says:

    Hi Michelle! Happy to hear that you role is expanding! I too am in a siilmar situatoin as a consultant right now that is mixed with SQL and MySQL. More on that later. I would agree with the majority of those who have sounded off that the use of catagories and a separate blog between the 2 DBMS’s would be perfect. I also wanted to get in touch with you about that parseString_UDF you have me look at a while back (I think I may have found a use for it, but want to make sure I do not violate any licensing you may have put in place since).Take care!Rich Yarger (a.k.a. SQL_ME_RICH)

  3. Hi Mandy, We were pleased as our last morning tea prep was last Christmas, with all the sweet goodies, and I love the change to savoury!Have a great week! x

  4. Revelation wcześniej wydało jeszcze Lure of the Temptress. To jest dopiero retro pełną gębą. Najbardziej jednak cenię to studio za pierwszego Brołkena, przy którym kiedyś zarywałem noce. Później powtórzyło mi się to tylko przy Klątwie Małpiej Wyspy (najsłodszej przygodówce ever).

  5. http://www./ says:

    I'm envious on your upcoming class.After talking to you at the LG shoot, and reading your earlier AAR, Todd's "Shoot Fast/Hit Fast" class is on top of my list for 2012.The only hitch is it has to be close enough to drive to the class.The big weakness in my shooting is that I'm "slow as fuck," and Todd's class seems just the thing to work on that.Rob

  6. I’ve been absent for a while, but now I remember why I used to love this web site. Thank you, I will try and check back more often. How frequently you update your website?

  7. I’m impressed, I have to say. Really not often do I encounter a blog that’s both educative and entertaining, and let me tell you, you might have hit the nail on the head. Your idea is outstanding; the issue is something that not enough individuals are talking intelligently about. I am very completely satisfied that I stumbled across this in my search for something referring to this.

Leave a Reply

Your email address will not be published. Required fields are marked *

Search

Pages