Not sure what you're doing your sql in, but may I suggest a few options?
* Intellisense in SSMS is rather good, and can be set to upper case statements.
* RedGate SQL Prompt or SQL Refractor are life savers.
* SQLInForm http://www.sqlinform.com/
Just to name a few.
Interesting. I've given thought to this myself - just because I'm not sure the US wishes to remain (or even maintain) its governmental obligations to society. People today tend to believe that government should only be here to wage war and 'defend' the populous. I tend to think government (at least a good part of it) should be to ensure the well being of its people, and that includes equitable health care. How have you found the health care in Toronto in comparison to the US?
Except that today, that will land your child a quick trip to Guantanamo....
In response to the original - simple answer, wrong question. The manager should stay if:
1. The manager can provide some sort of recognizable value to the effort (getting coffee, running interference, coding, whatever).
2. The manager is directly responsible for the late hours being incurred.
3. The manager can provide some sort of morale boost to the employees by physically being present.
On the flip side, should you remain in the office when the manager has to stay late? Perhaps he's staying late because your team didn't finish the code you promised at a particular time. What then? Why isn't the CEO staying late when you have to work overtime?
In response to parent:
Indeed, it may be time for the poster to stop looking at the individual "I'm putting in OT, why isn't my manager here" and start looking inwards, and at the macro level of the organisation. Recently, in an attempt to understand my own organization's psychotic management style (note here I'm not absolving myself of any wrongdoing), I've been reading Edward Yourdon's "Death March". Snippet:
"Companies both large and small are filled with politics and are staffed by managers and technical developers who suffer from hysterical optimism as well as the usual gamut of emotions such as fear, insecurity, arrogance, and naivete. And the combination of re-engineering, downsizing, outsourcing, and global competition - together with the opportunities provided by new technologies
The rest of Yourdon's book is spent lending an understanding as to why these things happen from many standpoints, with the hope that you can empower yourself to make a *rational* decision about your involvement in the project, and even the company as a whole. At the end of the day, it's your time, and your life. But at least come to the conclusion that you're 50% of the problem - management isn't solely responsible for your unhappiness. With the frenetic pace of companies today, people have very little time to learn, develop, and get things right. By the time something settles into resembling a normal project, everything changes and the process of education, experience, mistakes, etc. starts all over again. The players, environment - everything changes every single day.
I'm not implying that everyone should throw up their hands. But if you're not actively attempting to change the environment around you through your own education and experience, then I submit that you're just part of the problem.
Where are my mod up points!?
Redmine is the beautiful solution which walks the lines between having to input far too much information, being useful for the developer, and still useful for managers.
It seems to have quite a few TRAC defectors too. I've never used Trac, so I don't know why.
Bugzilla was far too 'developer oriented' for me - Redmine seems to take care of that rather well.
This is genius. I'm imagining the same thing on "Car Talk":
Caller: Hi, I'm calling from BFE, Arizona. My 1998 Honda Accord has the following problem...
Tom: STOP RIGHT THERE! You need to sell that car, and get a Lexus. We only recommend Lexus.
Caller: Uh, well, I've got a problem here I was hoping you could solve instead of a $40k solution...
Tom: Well, you were too stupid when you bought that. Sorry. Just go get a Lexus. Problems solved!
Tom: Next caller!
In the first gulf war we slept and lived in tents without airconditioning in the middle of summer (think Marines). The Air Force, not 2 miles away, had all air conditioned tents.
I'm glad to hear you're treated better than we were. It was effing miserable.
MARS was around when I was in Japan in 1988 in Iwakuni. Made life a lot better, since phone calls back then long distance could cost you your whole paycheck in the span of an hour or two.
Ya'll hear about the geometer who went to the beach to catch some rays and became a tangent ?
