Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Two Best Practices!


Two Best Practices!

Author
Message
dhathewa@isd.net
dhathewa@isd.net
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 4
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dhatheway/twobestpractices.asp



David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3674 Visits: 3114
As a DBA I expect all submitted code to be commented.
The comments should detail up front which tables are going to be used, what variables if any are declared and what they are supposed to be etc.

========================
He was not wholly unware of the potential lack of insignificance.

LinkedIn Profile

Newbie on www.simple-talk.com
Frank Kalis
Frank Kalis
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5971 Visits: 289
quote:

As a DBA I expect all submitted code to be commented.
The comments should detail up front which tables are going to be used, what variables if any are declared and what they are supposed to be etc.

========================
He was not wholly unware of the potential lack of insignificance.


Does it work?

Frank
http://www.insidesql.de
http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3674 Visits: 3114
In my environment yes because
  • I have a suitable carrot (the keys to the bosses drinks cabinet and the ability to sign expense forms).
  • I have a suitable stick (I contribute to their appraisals).
  • I practice what I preach.
  • Our projects come back to haunt us and when they haunt the person performing the exorcism may not necessarily be the person who originally wrote the code.

I stress that the projects that come back to haunt do so, not because of poor quality, but because we deal with government projects and tend to get repeat business requiring reworking due to fundamental changes in requirements.

========================
He was not wholly unware of the potential lack of insignificance.

LinkedIn Profile

Newbie on www.simple-talk.com
Frank Kalis
Frank Kalis
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5971 Visits: 289
Ah yes, ask the user what he wants and he starts thinking (maybe the first time) on what he's doing the whole day

In another forum I found an interesting definition of USER
quote:

"USER, n.: The word computer professionals use when they mean 'idiot.'" Dave Barry



When you deal with government, do you get your payment in time?

Frank
http://www.insidesql.de
http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3674 Visits: 3114
I used to work on an HP3000 mini-computer where the console had ultimate control followed by administrators followed by users.

We had a utility that let us impersonate differing levels of access.
To impersonate the console we typed GOD.
To return to administrive roles we typed MORTAL.
To impersonate a user we typed TIT.

Enough said

========================
He was not wholly unware of the potential lack of insignificance.

LinkedIn Profile

Newbie on www.simple-talk.com
Frank Kalis
Frank Kalis
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5971 Visits: 289
TIT ????

TIT Taste in Television (Married with Children)
TIT Teacher in Training
TIT Technician Induced Trouble
TIT Tenchi In Tokyo (anime)
TIT Tennessee Institute of Technology
TIT Ternary Digit
TIT The Internet Times
TIT This Is Terrible
TIT This Is Thailand (Bangkok Post)
TIT This Is True
TIT Time in Transit
TIT Titus
TIT Tokyo Institute of Technology
TIT Torpedo Impulse Tank
TIT Trotters Independent Trading
TIT Trotter's International Trading
TIT Tugaya Institute of Technology
TIT Turbine Inlet Temperature

The results from http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=tit

Frank
http://www.insidesql.de
http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3674 Visits: 3114
Sorry, forgot the language barrier.

They say that eskimos have thousands of names for snow, the British have millions that can be used as insults.

Bodily parts can be used as insults and tit is one of the milder ones. Given the nature of the bodily part its can even be regarded as an affectionate insult.

British insults range from "affectionate greeting" to genuine full-blooded "I'd like to do unto you what God did unto the Sodomites"!

People's names can also be used in a derogatory sense. For example the phrase "doing a Mandy" refers to a scam in the property trade that was carried out by one of our politicians (Peter Mandleson) where you sell a £300,000 house for £250,000 (thereby falling into a lower tax threshold) but charge £50,000 for fixtures and fittings.

In fact the British have turned insulting people into such an art form that the mere sending of a Christmas card can be deemed to be a gross insult (according to one of our more useless politicians).

If you have ever read "The Hitchhikers Guide to the Galaxy" there is a character in it who had immortality thrust upon him. Unable to cope with the shock of finding himself imortal he decided to devote his time to insulting each an every being in the universe personally. I'd like to think of him as British.

========================
He was not wholly unware of the potential lack of insignificance.

LinkedIn Profile

Newbie on www.simple-talk.com
Frank Kalis
Frank Kalis
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5971 Visits: 289
You mean the Douglas Adams' book?
If so, wasn't this character the robot?

Me thinks the British have served the art of insulting very well in having black puddding and serving warm beer

Frank
http://www.insidesql.de
http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3674 Visits: 3114
Yep, Douglas Adams.

The robot was Marvin the paranoid android but I'm thinking of a character in a later book in the series but can't think of his name.

There is a message for all computer programmers in this book when the computer, "Deep Thought" finally gives his answer to life the universe and everything but says that the programmers should have specified the ultimate question first! If that doesn't sum up user requirements then I don't know what does.

I particularly liked God's last message to his creation "We apologise for the inconvenience".

In addition to your warm beer and black-pudding I think you should add haggis and bagpipes (I know we didn't invent bagpipes but we do persist in playing them).


========================
He was not wholly unware of the potential lack of insignificance.

LinkedIn Profile

Newbie on www.simple-talk.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search