MIT Courses Online

If you read my blog and never take away anything but this, I will be happy that my efforts have not gone to waste:

Use the MIT Open Courses.‚  http://ocw.mit.edu/OcwWeb/web/courses/courses/index.htm

MIT (one of the most prestigious universities in the world) has made their entire course selection available to read and work through online.‚  I personally am using it to refresh and grow my business knowledge, using their Sloan School of Management courses.… read more “MIT Courses Online”

How to Insert Data into a Table In SQL Server Management Studio

To insert data into a table in SQL Server Management Studio, you can use the following sample insert code.‚  I have included my notes on how the functions work using comments prefaced by — in the SQL.

–I have created a simple table for us to work with below:
create table Calendar
(
dateid int NOT NULL Primary Key identity(1,1),
month int NOT NULL constraint CK_zeroTOtwelve Check(month > 0 AND 12 > month),
date int NOT NULL constraint CK_zeroTOthirty Check(date > 0 AND 31 > DATE),
hour int NOT NULL constraint CK_zeroTOtwentyfour Check(hour > 0 and 25 > hour)
)

–The actual code for inserting data into the Calendar table we created above is as follow:
insert into calendar
(month, date, hour) –state which columns are going to be inserted into.‚ … read more “How to Insert Data into a Table In SQL Server Management Studio”

How to Create a Table In SQL Server Management Studio

One of the most basic functions in SQL Server Management Studio is creating a table for your database.‚  Below, I have displayed a piece of sample code that you can copy & paste, then customize to create your own table in SQL Server Management Studio.

Create Table Sample

— Create Table is the syntax used to make your table.… read more “How to Create a Table In SQL Server Management Studio”

Gorilla Marketing

Today, I’m going to talk about one of my earliest childhood lessons in the advertising field: gorilla marketing.‚  Literally, gorilla marketing… you thought I misspelled guerrilla marketing didn’t you?

Ivan the Gorilla lived for 27 years in the now shut down B & I Shopping Mall in Tacoma, WA.‚  I remember visiting the mall and watching Ivan the Gorilla in his enclosure.‚ … read more “Gorilla Marketing”

Socialism in America- Definition of Socialism and Socialists in Schools

At a recent dinner I had an interesting conversation with an American schoolteacher about economics and politics and eventually discovered that she was a socialist. Since I wanted everyone to enjoy the dinner, I didn’t ask her more questions to find out the depth of her socialism knowledge or if she understood the effects socialist principles have on a nation.… read more “Socialism in America- Definition of Socialism and Socialists in Schools”

Funny Police Demotivational Poster

Found this funny police demotivational poster and thought I would share it with you guys.  The police are certainly enjoying themselves a little bit too much on the job here.

If you look at the relevant links below, you will see that I have a massive collection of demotivational posters (and more police demotivational posters!). Click through them to laugh at the funny motivational posters for hours!

Civic Knowledge Test

I found an interesting civic knowledge test.‚  http://www.americancivicliteracy.org/resources/quiz.aspx Apparently, the average public servant scores lower than the average citizen.

I scored an 81% (27 out of 33).

I thought a few of the questions were BS, especially question 33 & 15.‚  I won’t tell you what they are though before you take the test.

How did you score?

Good Article on Stock Market

http://www.breakingviews.com/2008/11/20/Dow%20fairly%20valued.aspx?sg=nytimes
Read that article.‚  Very good information on why the stock market is now back to where it should be (though it will probably continue to irrationally swing down a bit more before coming back up and stabilizing).
“The stock market crash has been big. The US S&P 500 index is 52% off its high, the largest percentage drop since 1937.… read more “Good Article on Stock Market”