Lesson 1:
A man is getting into the shower just as his wife is finishing up her shower, when the doorbell rings.
The wife quickly wraps herself in a towel and runs downstairs.
When she opens the door, there stands Bob, the next-door neighbor.
Before she says a word, Bob says, ‘I’ll give you $800 to drop that towel.’
After thinking for a moment, the woman drops her towel and stands naked in front of Bob, after a few seconds, Bob hands her $800 and leaves.
The woman wraps back up in the towel and goes back upstairs.
When she gets to the bathroom, her husband asks, ‘Who was that?’
‘It was Bob the next door neighbor,’ she replies.
‘Great,’ the husband says, ‘did he say anything about the $800 he owes me?’
Moral of the story:
If you share critical information pertaining to credit and risk with your shareholders in time, you may be in a position to prevent avoidable exposure.
Lesson 2:
A priest offered a Nun a lift.
She got in and crossed her legs, forcing her gown to reveal a leg.
The priest nearly had an accident.
After controlling the car, he stealthily slid his hand up her leg.
The nun said, ‘Father, remember Psalm 129?’
The priest removed his hand. But, changing gears, he let his hand slide up her leg again.
The nun once again said, ‘Father, remember Psalm 129?’
The priest apologized ‘Sorry sister but the flesh is weak.’
Arriving at the convent, the nun sighed heavily and went on her way.
On his arrival at the church, the priest rushed to look up Psalm 129. It said, ‘Go forth and seek, further up, you will find glory.’
Moral of the story:
If you are not well informed in your job, you might miss a great opportunity.
Lesson 3:
A sales rep, an administration clerk, and the manager are walking to lunch when they find an antique oil lamp.
They rub it and a Genie comes out.
The Genie says, ‘I’ll give each of you just one wish.’
‘Me first! Me first!’ says the admin clerk. ‘I want to be in the Bahamas , driving a speedboat, without a care in the world.’
Puff! She’s gone.
‘Me next! Me next!’ says the sales rep. ‘I want to be in Hawaii , relaxing on the beach with my personal masseuse, an endless supply of Pina Coladas and the love of my life.’
Puff! He’s gone.
‘OK, you’re up,’ the Genie says to the manager.
The manager says, ‘I want those two back in the office after lunch.’
Moral of the story:
Always let your boss have the first say.
Lesson 4
An eagle was sitting on a tree resting, doing nothing.
A small rabbit saw the eagle and asked him, ‘Can I also sit like you and do nothing?’
The eagle answered: ‘Sure, why not.’
So, the rabbit sat on the ground below the eagle and rested. All of a sudden, a fox appeared, jumped on the rabbit and ate it.
Moral of the story:
To be sitting and doing nothing, you must be sitting very, very high up.
Lesson 5
A turkey was chatting with a bull.
‘I would love to be able to get to the top of that tree’ sighed the turkey, ‘but I haven’t got the energy.’
‘Well, why don’t you nibble on some of my droppings?’ rep lied the bull. They’re packed with nutrients.’
The turkey pecked at a lump of dung, and found it actually gave him enough strength to reach the lowest branch of the tree.
The next day, after eating some more dung, he reached the second branch.
Finally after a fourth night, the turkey was proudly perched at the top of the tree.
He was promptly spotted by a farmer, who shot him out of the tree.
Moral of the story:
Bull Shit might get you to the top, but it won’t keep you there..
Lesson 6
A little bird was flying south for the winter. It was so cold the bird froze and fell to the ground into a large field.
While he was lying there, a cow came by and dropped some dung on him.
As the frozen bi rd lay there in the pile of cow dung, he began to realize how warm he was.
The dung was actually thawing him out!
He lay there all warm and happy, and soon began to sing for joy.
A passing cat heard the bird singing and came to investigate.
Following the sound, the cat discovered the bird under the pile of cow dung, and promptly dug him out and ate him.
Morals of the story:
(1) Not everyone who shits on you is your enemy.
(2) Not everyone who gets you out of shit is your friend.
(3) And when you’re in deep shit, it’s best to keep your mouth shut!
Monday, January 31, 2011
Wednesday, August 25, 2010
Import Microsoft Access (v2003) tables into SQL Server Express Edition (v2005)
In my little corner of the world, I have seen this issue come up three times by three different people in the past 7 days so I thought I would posts this. I actually just went through this myself a little bit ago:
1. Open Microsoft SQL Server Management Studio Express
2. Create a database for the import, if necessary
3. Open the Microsoft Access database that will be imported into SQL
4. Switch to “Tables” in Microsoft Access
5. Right click on the Table to be exported
6. Select “Export”
7. In the ‘Save Type As…’ field select “ODB Databases()”
8. Name the Table and Press “OK”
9. Press the “New…” button
10. Select “SQL Server” and Press “Next>”
11. Enter a name for the Data Source then Press “Next>”
12. Press “Finish”
13. Enter a Description if necessary
14. Select the SQL Server to connect to and Press “Next>”
15. Select the correct Authentication settings and Press “Next>”
16. Check “Change the default database to:” and Select the correct Database then Press “Next>”
17. Press “Finish”
18. Press “Test Data Source…” to very the information entered was correct
19. If test completed successfully then Press “OK”
20. Press “OK”
21. In “SQL Server Login” dialog box, enter correct authentication information and Press “OK”
22. Export should occur without any further dialog boxes or prompts
23. Switch back to the Microsoft SQL Server Management Studio Express
24. Navigate to the database, refresh the console and verify the table was created/imported
1. Open Microsoft SQL Server Management Studio Express
2. Create a database for the import, if necessary
3. Open the Microsoft Access database that will be imported into SQL
4. Switch to “Tables” in Microsoft Access
5. Right click on the Table to be exported
6. Select “Export”
7. In the ‘Save Type As…’ field select “ODB Databases()”
8. Name the Table and Press “OK”
9. Press the “New…” button
10. Select “SQL Server” and Press “Next>”
11. Enter a name for the Data Source then Press “Next>”
12. Press “Finish”
13. Enter a Description if necessary
14. Select the SQL Server to connect to and Press “Next>”
15. Select the correct Authentication settings and Press “Next>”
16. Check “Change the default database to:” and Select the correct Database then Press “Next>”
17. Press “Finish”
18. Press “Test Data Source…” to very the information entered was correct
19. If test completed successfully then Press “OK”
20. Press “OK”
21. In “SQL Server Login” dialog box, enter correct authentication information and Press “OK”
22. Export should occur without any further dialog boxes or prompts
23. Switch back to the Microsoft SQL Server Management Studio Express
24. Navigate to the database, refresh the console and verify the table was created/imported
Wednesday, March 10, 2010
creating MYSQL stored procedure and calling it from PHP
# Open phpMyadmin.
# Select a database to work with.
# Open the SQL tab.
Assume your database contains table called employees.
In the SQL tab,
you can start writing :
DROP PROCEDURE IF EXISTS listEmployees $$
CREATE PROCEDURE listEmployees()
BEGIN
select * from employees;
END $$
In delimiter [;] change ; to $$.
Hit go. Thats it, you are done with creating your first stored procedure.
Up to this anyone can google and create the stored procedure, but big mess is how to use this in PHP.
After many trails and trails I learned how to call procedure in php.
Normally you would use the below to connect to a mysql database in php.
$connector=mysql_connect(host,user,pass);
In order to use stored procedures try connecting like this:
$connector=mysql_connect(host,user,pass,true,65536);
mysql_select_db(database,$connector); //Nothing changes here
Now you are done with making php mysql to use with stored procedure.
Lets see how you can call stored procedure with php.
$query=mysql_query("CALL listEmployees()");
while($result=mysql_fetch_array($query))
{
echo $result[emp_name]."
";
}
Thats it. It calls procedure called listEmployees(which we written above and that does lists all employees data from employee table).
# Select a database to work with.
# Open the SQL tab.
Assume your database contains table called employees.
In the SQL tab,
you can start writing :
DROP PROCEDURE IF EXISTS listEmployees $$
CREATE PROCEDURE listEmployees()
BEGIN
select * from employees;
END $$
In delimiter [;] change ; to $$.
Hit go. Thats it, you are done with creating your first stored procedure.
Up to this anyone can google and create the stored procedure, but big mess is how to use this in PHP.
After many trails and trails I learned how to call procedure in php.
Normally you would use the below to connect to a mysql database in php.
$connector=mysql_connect(host,user,pass);
In order to use stored procedures try connecting like this:
$connector=mysql_connect(host,user,pass,true,65536);
mysql_select_db(database,$connector); //Nothing changes here
Now you are done with making php mysql to use with stored procedure.
Lets see how you can call stored procedure with php.
$query=mysql_query("CALL listEmployees()");
while($result=mysql_fetch_array($query))
{
echo $result[emp_name]."
";
}
Thats it. It calls procedure called listEmployees(which we written above and that does lists all employees data from employee table).
Writing stored procedures of mysql in PHPMYADMIN
1. Open phpMyadmin.
2. Select a database to work with.
3. Open the SQL tab.
4. Select all of the SQL statements between the DELIMITER statements in your stored procedure script. Do not include the DELIMITER statements! Here’s what my example script should look like:
DROP PROCEDURE IF EXISTS spFoo $$
CREATE PROCEDURE spFoo ()
BEGIN
SELECT 'Foo' FROM DUAL;
END $$
5. In the delimiter field, just below the SQL editor’s text area, enter $$ as your delimiter.
2. Select a database to work with.
3. Open the SQL tab.
4. Select all of the SQL statements between the DELIMITER statements in your stored procedure script. Do not include the DELIMITER statements! Here’s what my example script should look like:
DROP PROCEDURE IF EXISTS spFoo $$
CREATE PROCEDURE spFoo ()
BEGIN
SELECT 'Foo' FROM DUAL;
END $$
5. In the delimiter field, just below the SQL editor’s text area, enter $$ as your delimiter.
Saturday, January 23, 2010
Famous quotes, witty quotes, and funny quotations 2
have."
afterwards to solve other problems."
(1596-1650), "Discours de la Methode"
but the silence of our friends."
Famous quotes, witty quotes, and funny quotations
- "Moral indignation is jealousy with a halo."
- - H. G. Wells (1866-1946)
- "Glory is fleeting, but obscurity is forever."
- - Napoleon Bonaparte (1769-1821)
- "Victory goes to the player who makes the next-to-last mistake."
- - Chessmaster Savielly Grigorievitch Tartakower (1887-1956)
- "Don't be so humble - you are not that great."
- - Golda Meir (1898-1978) to a visiting diplomat
- "His ignorance is encyclopedic"
- - Abba Eban (1915-2002)
- "If a man does his best, what else is there?"
- - General George S. Patton (1885-1945)
- "Political correctness is tyranny with manners."
- - Charlton Heston (1924-)
- "You can avoid reality, but you cannot avoid the consequences of avoiding reality."
- - Ayn Rand (1905-1982)
- "When one person suffers from a delusion it is called insanity; when many people suffer from a delusion it is called religion."
- - Robert Pirsig (1948-)
- "Sex and religion are closer to each other than either might prefer."
- - Saint Thomas Moore (1478-1535)
- "I can write better than anybody who can write faster,
and I can write faster than anybody who can write better." - - A. J. Liebling (1904-1963)
- "People demand freedom of speech to make up
for the freedom of thought which they avoid." - - Soren Aabye Kierkegaard (1813-1855)
- "Give me chastity and continence, but not yet."
- - Saint Augustine (354-430)
- "Not everything that can be counted counts, and not everything that
counts can be counted." - - Albert Einstein (1879-1955)
- "Only two things are infinite, the universe and human
stupidity, and I'm not sure about the former." - - Albert Einstein (1879-1955)
"A lie gets halfway around the world before the truth has a chance to
get its pants on."- - Sir Winston Churchill (1874-1965)
- "You may not be interested in war, but war is interested in you."
- - Leon Trotsky (1879-1940)
"I do not feel obliged to believe that the same God who has
endowed us with sense, reason, and intellect has intended us to forgo
their use."- - Galileo Galilei (1564-1642)
- "We are all atheists about most of the gods humanity has ever believed in. Some of us just go one god further."
- - Richard Dawkins (1941-)
"The artist is nothing without the gift, but the gift is nothing
without work."- - Emile Zola (1840-1902)
- "This book fills a much-needed gap."
- - Moses Hadas (1900-1966) in a review
- "The full use of your powers along lines of excellence."
- - definition of "happiness" by John F. Kennedy (1917-1963)
- "I'm living so far beyond my income that we may
almost be said to be living apart." - - e e cummings (1894-1962)
- "Give me a museum and I'll fill it."
- - Pablo Picasso (1881-1973)
- "Assassins!"
- - Arturo Toscanini (1867-1957) to his orchestra
- "I'll moider da bum."
- - Heavyweight boxer Tony Galento, when asked what he thought of
William Shakespeare - "In theory, there is no difference between theory and practice.
But in practice, there is." - - Yogi Berra
Thursday, January 7, 2010
Gtalk Invisibe mode via Lab Edition
Basically the desktop Gtalk client doesn’t allow you to set invisible offline status so one tip you can try out is by downloading the Gtalk Lab edition (Download lab edition) which is a google talk desktop client with a lot of features unavailable in the Gtalk gadget (the one which we use regularly).You can also launch orkut, google calendar with a click on a button using the lab edition and use those cute smileys bar in the chat window.
Another way to show offline status to your friend’s is to make use of multi protocol chat client for mac and windows but I prefer the lab edition as it is light and developed for users who wants to connect with only Google friends :)
Another way to show offline status to your friend’s is to make use of multi protocol chat client for mac and windows but I prefer the lab edition as it is light and developed for users who wants to connect with only Google friends :)
Subscribe to:
Posts (Atom)