SQL Server Enterprise Manager Gotcha

A fairly routine task today became a bit of an ordeal, made worse by remembering the symptoms but not the solution. So, I’m documenting this to try and prevent future occurrences.

All I wanted to do was set up a Foreign Key / Primary Key relationship. This should have been relatively straight-forward but wasn’t. The error message from Enterprise Manager told me that it couldn’t create the relationship but didn’t tell why.

Now, I remembered this problem happening before but for the life of me could not remember reasons for it happening. Eventually after getting other people’s views I found the reason, which is that the two columns didn’t have a relationship. I was making too many assumptions.

In future the best way to prevent this error are to follow these two steps.

1.) Make sure column names are fully descriptive. This way the links between should be obvious. See Step 2.

2.) Try and do a join between the two tables. The error I was getting was me trying to link two columns that could not be linked. It might be useful if SQL could tell me that, but it didn’t and perhaps can’t. The confusion arose from there being two IDs, and I was referring to the wrong one. Now, there should only ever be one ID but at the moment with some of my database tables, one ID points to a SharePoint List Item, and the other to a row in the database. The work I’m doing at the moment is to try and get rid of the links between SharePoint and the database so normality can resume.

 

Advertisements

What do you think?

Does this image say “Romance” or “Transaction”? I know what I’m thinking, and I suspect I know what he’s thinking too!

SpiritOfRomance

 

Isn’t the joy of falling in love the complete exhilaration of it all, being swept of your feet? Not leaving anything to chance, smacks a bit of being calculating and cold. Where’s the romance in a perfectly manufactured marriage? There’s also the exclusivity. I’m sticking to my own kind, not poor people or some hard-working nurse. No, sod them, I want to breed with aggressive go-getters and create lots more little CEOs just like me. After all, it will make the world a better place, or should I have said a bitter place?

Drowning in a tide of effluvia

I was lying in bed thinking about all sorts really. Some thoughts were connected with programming, new ideas, introspection and dwelling on the week I’ve just had – not a particularly good one as it happens and then I started thinking about the English language and how it changes.

JRR Tolkien made the study of languages his life’s work. I think he knew about 19 languages and, of course, he created several new ones himself: Quenya and Sindarin being the most well-developed. He also wrote a few books that gained some recognition but some of these were off-shoots, a mythology creating a history, and therefore reasons, to explain the growth and change in his invented languages.

Language changes all the time and it’s impossible, and most would argue un-healthy, for a language not to change and evolve. The languages we speak are not perfect. They don’t always capture precisely the emotions we feel at a particular instant or what we wish or desire. Our interaction with the world around us and with each other is complex because as humans we are complex. We like to understand and make sense of things. Or at least I do!

English is one of the most popular languages on the planet, first spread by the British in their heavy-handed attempt at world domination, and then in the many resulting consequent waves. Curiously, though there is, or was, great diversity in the pronunciation of English within the United Kingdom. There has never been a defined or correct way to say a word. Therefore we have words such as ‘READ’, that can read one way, or taken as read. We have words like ‘DOES’, female deer but also a verb: he does go on a bit doesn’t he? Now, that English is a global language the pace of change and the range of influences on the language are vast.

Words come and go. They come into fashion or their meanings change. Sometimes for the better. To be described as sophisticated is now rather a compliment, whereas originally it meant you were un-trustworthy, not straight-forward. Another such word is funky. She’s funky, that’s funky! Sounds cool eh! Except that funky originally meant something that smelt bad. Sick, seems to be going through such a change although for me sick is another word for vomit and to be sick is to be ill.

There are other words that are similarly changing and I’m thinking here primarily about business language. Leverage is one such word. Growing up one applied leverage in order to move something. Within the banking sector that’s still the implied meaning. We need to apply leverage. But there is growing trend to see the word ‘use’ being replaced with ‘leverage’ and that doesn’t make sense to me. Why discard a perfectly nice word for some big clumsy lever of a thing? If you are going to use something then use it! Don’t leverage it! That’s a very specific meaning but sadly I think I now sound like an old pedant moaning about change.

Another word with a specific meaning that is now changing is impact, and the various ugly abuses that result from the over-use or over-leverage of it. The Meteor Crater in Arizona is the result of an impact. A rock from space hit the Earth and the result of that impact can still be seen today. A negative impact is an oxymoron. Quite often with some words I’m able to make a swift mental substitution, when I hear leverage I replace it with use, ‘impacts’  is replaced with ‘affects’ but I sometimes struggle when I hear negative impact. Can I use unfortunate consequences, bad luck or shall I just batter the person who has uttered this banality with a heavy club therefore demonstrating forcibly the true meaning of the word impact! A negative impact is when I don’t hit you thereby doing nothing!

Unfortunately, there are many such examples and I don’t think there is much that can be done to stop this rising tide of effluvia. I’m sure there are one or two other like-minded people out there who see and hear these words and cringe just as much as I do but there are others who seem to quite cheerfully use them without much regard for what they are actually saying.

Why get so worked up about this? Well, it shows a certain lack of imagination, it shows a certain dimness. For me the word impact has gained popularity for the same reasons as awesome. It’s a bigger, more impressive sounding word to use in a marketing presentation. We want this fruit juice to make a big impact! Good for you! I hope it doesn’t leave a hole in my body.

But now everyone is out making an impact with the result that the meaning of impact is now somewhat lessened. Impact should be used to describe the immense contributions of Einstein or Shakespeare, now it carries all the awe-inspiring grandeur of an angry drunk kicking a dustbin outside his ex-girlfriend’s house at nine o’clock on a Tuesday night.