LINK: http://weblogs.sqlteam.com/joew/archive/2007/10/23/60383.aspx
Why write a cursor to traverse each table – this stored proc allows you to traverse each table automatically:
EXECUTE sp_MSforeachtable ‘EXECUTE sp_spaceused [?];’;
Neat!
——————
Show all files in the Finder | Software | Mac OS X Hints | Macworld.
Executing Shell Scripts from the OS X Dock? - Stack Overflow.
lunchtime!!
Stone Soup And Boiled Frogs
An old fable goes (something like):
Allied soldiers were returning home from the war. They were hungry. They went into a village which was locked down from being so poor and ravaged. The soldiers put on a pot of water and put three stones in it. One villager asked “what is it”? The soldiers cunningly replied “it’s stone soup, but it would be much better with carrots”. The gullible villager ran off and gave up his hard-earned communist rations for the good of the soup. Later, another Red came up and was told by the soldiers “Potatoes give the soup body”, and he too was brainwashed into handing over his commie rations. Eventually all of the village were duped by the infidel soldiers, but shared in the communal flavour that was the soup.
The moral of the story is that you should
Be a Catalyst For Change
If you need to make large changes, momentum will be slow and there will be little buy-in. Start with something small which piques people’s interest and develop it. One you’ve got it, show people and then say “of course it would be better if we added…”. Given the immediate result of having seen some progress, people will be more receptive to change.
The flip-side to all of this is the problem that the villagers lost sight of the greater picture. They were all heavily focused on their own little agendas they couldn’t see the forest from the trees.
Remember the Big Picture
A frog placed into boiling water will jump out. But a frog placed into cold water and slowly boiled will stay there until he is moist and juicy. The frog doesn’t notice the change. Don’t be like the frog - keep an eye on the big picture and constantly review what’s happening around you - not just what you personally are doing.
Challenge
The soldiers progressively deceive the villagers, but the change they catalyse does them all good. OTOH, by deceiving the frog, you’re doing it harm. Can you determine whether you’re making stone soup or frog soup when trying to catalyse change?It’s a difficult question to answer because the intention you set out with may not be the result you achieve. The soldiers intent was to make an entire meal, which is a positive outcome from one perspective, but from the other perspective the villagers have probably consumed more rations than they would ordinarily have in order to make the large pot of soup, and therefore have placed themselves in a more difficult position long-term, for a short-term gain. Keeping constant checks on the situation would help to ensure no unnecessary rations went into the soup thereby keeping the process mutually beneficial to all.
The Pragmatic Programmer: CH1-3
Software Entropy
Entropy refers the the amount of disorder in a system. In software systems, we generally mean software rot
Don’t live with broken windows
Some software systems have code which stays pristine, others tend to rot and decay. What makes the difference is the attitude by those working on the codebase. Researchers of crime statistics proposed a theory of broken windows which states that one broken window left for any substantial length of time instills in the inhabitants a sense of abandonment. This leads to another window getting broken, littering, graffiti and the sense of abandonment becomes a reality.
Don’t leave broken windows! If you can’t fix it, then board it up - comment out the offending code, or display a not-implemented message; Take some action to show that you’re on top of the problem.
When putting out fires, you want (in particular) that you’re careful about how to implement the fix as all it takes is one badly designed piece of code, a poor management decision or something similar to start the decline. It’s too easy for software teams to fall into the mindset of “all the rest of this code is crap, i’ll just follow suit”
Challenge
Can you tell when a window first gets broken? What is your reaction? If it was the result of someone else’s decision, or a management edict, what can you do about it?A broken window isn’t always apparent. Sometimes a code smell creeps in during a large task where all parts of the system aren’t understood upfront. Driving out the implementation may lead to something functional, but could be complex and difficult to understand. The reaction should be to identify the smell however possible, and discuss the importance of fixing it. If the problem was a result of someone else, perhaps discussing the design approach taken and coming to a mutual understanding of why the design turned out that way, is required. This would at least promote education as to how it could have been done better.
The Pragmatic Programmer: CH1-2
The Cat Ate My Homework
A pragmatic programmer takes responsibility for everything they agree to. You *ALWAYS* have the right to not take on the responsibility, but when you do, you should expect to be accountable for the outcome.
Tip 3: Provide Options, Dont make Lame Excuses
Always be honest and direct, admit mistakes and offer solutions. Don’t say something can’t be done; explain what can be done to salvage the situation.
Talk to yourself (or cat) about how to voice your problems to your boss, and critically analyse what you say to make sure it doesn’t sound like you’re making excuses.
Challenge
How do you react when someone - such as a bank teller or clerk comes to you with a lame excuse? What do you think of them and their company as a result?A: It reflects poorly on the company and the perceived lack of care or knowledge of the person. Admitting not knowing but actively seeking a solution at least shows genuine interest in trying to achieve the best outcome despite the shortcomings which lead to the situation.
The Pragmatic Programmer: CH1-1
Use GMail for iPad in Chrome
Create a shortcut to the following link:
%userprofile%\AppData\Local\Google\Chrome\Application\chrome.exe —app=”https://mail.google.com/mail” —user-agent=”Mozilla/5.0(iPad; U; iPhone OS 3_2; en-us) AppleWebKit/531.21.10 Mobile/7B314” —user-data-dir=”%tmp%\gmipad”
I like the simple interface here…just clean and simple.
Chrome can now save all open tabs to a bookmark, which nicely complements erdinç’s solution. To do this, just right click any tab, and choose “Bookmark all tabs”. It will create a new folder and store all the tabs there, you just need to rename the folder afterwards. I tested this on version 4.0, not sure about older versions.
How do I save tabs? - Google Chrome Help
-
About
- Change this text in the admin section of WordPress
-
You are currently browsing the archives for October, 2007.
-
Archives
- September 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- November 2007
- October 2007
- August 2007
- May 2007
- April 2007
- April 2006
- March 2006
- February 2006
- July 2005
- June 2005
