Best Business School - 2010

Best Business School - 2010

Click here

MBA - Business

Searching Gmail

Search into your Gmail

Click here


search any email or item from you gmail account

NULL condition in CASE statement

The following would NOT work

case when e.myCode = null then e.yourCode else e.myCode end as displayCode

instead use below

,isnull(e.myCode,e.yourCode) as displayCode



hope this helps

shopping scams security

good site about shopping scams

http://shopping.yahoo.com/articles/yshoppingarticles/448/the-sneakiest-new-shopping-scams/


secure shopping

good sites

http://sitepoint.com/
http://99designs.com/promo/retarget?gclid=CI-6pvaX6aQCFeJN5QodziMs1A
http://flippa.com/


http://finance.yahoo.com/career-work/article/111047/how-to-be-a-millionaire-by-age-25?mod=career-worklife_balance


last link is billionaire views

youtube

http://www.youtube.com/user/activevision

http://www.youtube.com/user/AMDUnprocessed

http://www.youtube.com/user/Avayainteractive

http://www.youtube.com/user/carnegiemellonu

http://www.youtube.com/user/ccie12933

http://www.youtube.com/user/channelintel

http://www.youtube.com/user/CiscoLive2009

http://www.youtube.com/user/CiscoSmallBusiness

http://www.youtube.com/user/ciscozine

http://www.youtube.com/user/citrisuc

http://www.youtube.com/user/computerworld

http://www.youtube.com/user/CSCOPR

http://www.youtube.com/user/EyeOnTechnology

http://www.youtube.com/user/ITWorldVideos

http://www.youtube.com/user/lockergnome

http://www.youtube.com/user/macworld

http://www.youtube.com/user/MIT

http://www.youtube.com/user/NYTechSummit

http://www.youtube.com/user/ResearchChannel

http://www.youtube.com/user/sansinstitute

http://www.youtube.com/user/sunmicrosystemsgmbh

http://www.youtube.com/user/SunMicrosystemsInc

http://www.youtube.com/user/TechTargetTV

http://www.youtube.com/user/TigerDirectBlog

http://www.youtube.com/user/VidPR

http://www.youtube.com/user/Harvard

http://www.youtube.com/user/stanforduniversity

http://www.youtube.com/user/uctelevision

http://www.youtube.com/user/ncstate

http://www.youtube.com/user/carnegiemellonu

http://www.youtube.com/user/georgiatech

http://www.youtube.com/user/UniversityofMinn

http://www.youtube.com/user/pennstate

http://www.youtube.com/user/wesleyan

I have gathered various videos for your delight and enjoyment we all need it!

http://www.youtube.com/watch?v=p32OC97aNqc

http://www.youtube.com/watch?v=tN3iNxr2bhk

http://www.youtube.com/watch?v=SW3gJFrZ4hY

http://www.youtube.com/watch?v=81NeQJWGYJY

useful links

http://cashflow777.weebly.com/videos.html

A small library... Your all welcome to download whatever you want.

http://www.4shared.com/dir/25834616/400fbf67/sharing.html

I highly recommend this website

http://www.stumbleupon.com

Tools

http://us.smetoolkit.org/us/en

Your welcome

Templates

http://www.mplans.com/sample_marketing_plans.php

http://www.bplans.com/sample_business_plans.cfm

http://www.score.org/template_gallery.html

http://isb.wa.gov/pmframework/templates.aspx


Useful links

http://www.google.com/mobile/products/sms.html#p=default

http://www.rentometer.com/

http://www.rememberthemilk.com/

http://www.ohchr.org/EN/Pages/WelcomePage.aspx

http://www.philfilms.utm.edu/

http://themis.asu.edu/

http://www.wikihow.com/Get-Six-Pack-Abs

http://shareitfitness.wordpress.com/2010/05/14/250lbs-woman-vs-120lbs-woman/

http://www.flvs.net/Pages/default.aspx

Great Game

http://chir.ag/stuff/sand/

http://www.microsoft.com/games/en-US/index.aspx

http://www.nppl.com/

http://www.networkrockstarchallenge.com/

http://science.nasa.gov/

http://www.noao.edu/


http://spaceyourface.nasa.gov/

http://www.libraryspot.com/

http://mappinghistory.uoregon.edu/

http://www.thomas.gov/

http://personalrobotics.stanford.edu/

http://library.lawschool.cornell.edu

http://www.uee.ucla.edu


http://www.nia.nih.gov/

http://ninite.com/

http://preyproject.com/

http://www.openrise.com/lab/FlowerPower/

http://www.yourpassporttothesun.com/

http://www.socialengine.net/

http://www.online-convert.com/

http://blogof.francescomugnai.com/2010/04/the-8-worlds-most-prominent-hyper-realist-sculptors

http://www.yankodesign.com/2010/05/25/in-2020-we-can-wear-sony-computers-on-our-wrist/

http://www.romancortes.com/ficheros/dancing-typography.html

http://www.mapsofwar.com/library.html

Learn a new Language & more..

http://www.missiontolearn.com/2009/06/lifelong-learner-free-resources/

http://www.missiontolearn.com/2010/06/lifelong-learning-social-networks/

http://www.onlinecollege.org/2009/01/22/free-or-open-source-tools-for-students/

http://www.missiontolearn.com/2009/07/language-learning-widgets/

http://www.edufind.com/index.php

Teach & Learn

http://smithsonianeducation.org/


http://scholarspot.com/

http://www.varsitynotes.com/

http://www.learnerstv.com/

http://OCW.ND.edu
Courses include detailed lecture notes, a calendar of teading assigned for each class and a description of major assignments.

http://OCW.Tufts.edu
Offers student-made documentaries about social issues as well as a list of weekly readings.

http://iTunes.Stanford.edu
Professors Martin Evans and Marsh McCall lecture on great works by Virgil to Voltaire.

http://iTunes.Berkeley.edu
Berkeley's lectures online

http://WebCast.Berkeley.edu
alternate site of Berkeley's lectures.

http://www.lynda.com/


http://oedb.org/library/features/236-open-courseware-collections

http://www.careervoyages.gov/education-videos.cfm

http://www.sba.gov/tools/audiovideo/deliveringsuccess/index.html

http://www.sba.gov/training/index.html

http://www.sba.gov/tools/audiovideo/Podcasts/index.html

http://www.openculture.com/2007/07/freeonlinecourses.html

http://www.videomd.com/featured_videos.aspx

http://www.freesciencelectures.com/

http://streaming.discoveryeducation.com/

http://education.usgs.gov/common/video_animation.htm

http://www.nachi.org/advancedcourses.htm

http://education-portal.com/video_library/index.html

http://www.serve.org/nche/ibt/aw_video.php

http://www.practisinc.com/interactive/patient-education-videos.php

http://www.teachers.tv/

http://library.sau.edu/bestinfo/Online/onlindex.htm

http://www.how-to-study.com/

http://www.teacherxpress.com/

http://www.flashcardexchange.com/

https://www.wdwcollegeprogram.com/sap/its/mimes/zh_wdwcp/students/majors/majors.html

Great game
Quizzes

http://www.lizardpoint.com/fun/geoquiz/uscitiesquiz.html

NASA

http://cashflow777.weebly.com/nasa.html

http://cashflow777.weebly.com/nasa-part-2.html

http://cashflow777.weebly.com/nasa-part-3.html

http://cashflow777.weebly.com/nasa-part-4.html

http://cashflow777.weebly.com/nasa-part-5.html

http://cashflow777.weebly.com/outerspace-painting.html

-------------------------------------------------------------------

http://fcit.coedu.usf.edu/holocaust/resource/resource.htm

http://www.math.hmc.edu/funfacts/allfacts.shtml

--------------------------------------------------------------------



Kids Resources

http://www.factmonster.com/

http://www.econedlink.org/

http://www.historyforkids.org/

http://members.learningplanet.com/teachers/index.asp

http://www.edheads.org/

http://www.chem4kids.com/

http://www.abcteach.com/

http://www.brainpop.com/


http://www.ocwconsortium.org/use/use-dynamic.html

An OpenCourseWare is a free and open digital publication of high quality educational materials, organized as courses. The OpenCourseWare Consortium is a collaboration of more than 200 higher education institutions and associated organizations from around the world creating a broad and deep body of open educational content using a shared model.



http://www.oercommons.org/

In a brave new world of learning, OER content is made free to use or share, and in some cases, to change and share again, made possible through licensing, so that both teachers and learners can share what they know.


http://www.schoox.com/


In schooX you can find free online courses in a wide range of subjects. Over 500 online courses, which are soon to reach 2000, are already free available under a Creative Commons license.



http://selfmadescholar.com/b/self-education-resource-list/


The internet is an invaluable resource to self-educated learners. Below is a list of some of the most helpful sites out there including opencourseware materials, free libraries, learning communities, educational tools, and more.



http://www.missiontolearn.com/2009/12/learn-foreign-language-online/


Reading from a textbook isn’t the only way to learn a foreign language. The web offers a number of free tools that can be used to enhance the learning experience inside and outside the classroom. Here are 15 language learning tools to try today:




http://www.rfid4u.com/services/freeelearning.asp

RFID Basics Course
This course helps learners to understand the fundamentals of RFID technology and provides an overview of RFID hardware including different types of tags, tag frequencies, readers, antennas, and so on.

http://www.4shared.com/dir/25834616/400fbf67/sharing.html


For those wanting to make a little money on the side
Subscribe

http://www.fusioncash.net/?ref=joeveloz

http://moneymaking777.blogspot.com/

http://www.getvouchersforfree.com?join=273

http://www.textbroker.com/

https://www.mturk.com/mturk/welcome

good videos

http://Academicearth.org
http://ocw.mit.edu/OcwWeb/web/courses/av/index.htm
http://worldlibrary.net/Collections.htm
500,000 pdf *
http://freevideolectures.com/computerscience.html
http://freevideolectures.com/
http://videolectures.net/
http://lecturefox.com

HOME Buy or Rent?

BUY OR RENT

Does Your Team Have the Four Essential Types?

CLICK HERE

30 Smart Time Management Tips and Tricks

here is good article..

CLICK HERE

Line Delimiter, Line Ending in different system

unix = lines end with LF = char(10)
dos = lines end with CR LF = char(13)
mac = lines end with CR = char(13)

DELETE Duplicate, SQL, Mark Duplicate

WITH CTE AS
(
SELECT MyStatus,ROW_NUMBER() OVER
(PARTITION BY [EmployeeID]
Order BY [EmployeeID] )
AS RowNumber,
[EmployeeID]
FROM [dbo].MYTABLE tbl )
--DELETE FROM CTE Where RowNumber > 1
--SELECT * FROM CTE Where RowNumber > 1
update CTE set eligstatus='DP'
where RowNumber > 1
GO

Where to Buy a Home ??

http://realestate.yahoo.com/promo/where-to-buy-a-home-for-less-than-800-a-month

5 Common Misdiagnoses - Importent!!

http://health.yahoo.net/rodale/MH/5-common-misdiagnoses-for-men

good article ;)

8 ways to earn extra money

http://www.theworkbuzz.com/job-search/8-ways-to-earn-extra-cash/?cobrand=msn&siteid=cbmsnmnbuzz>1=23000

good articles on fixed floating hybrid rate

http://business.rediff.com/slide-show/2010/aug/04/slide-show-1-fixed-or-floating-or-hybrid-home-loan.htm#contentTop

Dependency Injection discussion

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=19725684&gid=43315&trk=EML_anet_qa_ttle-0Qt79xs2RVr6JBpnsJt7dBpSBA

http://mef.codeplex.com/Thread/View.aspx?ThreadId=35083

ASP.NET & MVC

http://www.linkedin.com/groupItem?view=&srchtype=discussedNews&gid=43315&item=24397298&type=member&trk=EML_anet_qa_ttle-0Qt79xs2RVr6JBpnsJt7dBpSBA


http://www.codeproject.com/KB/aspnet/MVC2Introduction01.aspx

SSRS - running total

--Member wise running total
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, "table1_MemberName"))

--Running total never reset
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, Nothing))

SSRS, Cascading Parameters and Expression

-- dropdown filter
http://msdn.microsoft.com/en-us/library/aa337169.aspx

--expression
http://msdn.microsoft.com/en-us/library/ms157328.aspx

UNIX, crontab file

-- Basic UNIX script command
http://freeengineer.org/learnUNIXin10minutes.html

--list Crontab file

crontab -l

--edit crontab file

crontab -e

--Get yesterday using UNIX script
today=`date "+%Y%m%d"`
#get yesterday
date "+%Y%m%d"
date +%Y%m%d -d "yesterday"

CurrentDate=`TZ="GMT+24" date +'%y%m%d'`
echo $CurrentDate;

YESTERDAY=$((`date +%d` -1))
MONTH=`date +%m`
YEAR=`date +%Y`
NDAY=`date +%u`
WEEKDAY=${DAYS[`date +%u`]}
if [ $YESTERDAY -eq "0" ]
then
MONTH=$((MONTH-1))
if [ $MONTH -eq "0" ]
then
MONTH=12
YEAR=$((YEAR-1))
fi
set `cal $MONTH $YEAR`
shift $(($# - 1))
YESTERDAY=$1
fi
echo $YEAR$MONTH$YESTERDAY;
varyesterday="$YEAR$MONTH$YESTERDAY"
#end yesterday

echo $varyesterday;

String must be exactly one character long.

When you have DBML lINQ entity fields with CHAR data type. you will get an error while retrieve the data.

Solution:
----------
1) go to the DBML entity
2) select field
3) press F4
4) change data type to string from char, where you have DB data type VARCHAR(1)
5) Save

Cannot add an entity with a key that is already in use, LINQ

When you have table with ID coulumn (uniqueidentifier) and default value = (newid()),
than the above error occur.

To Resolve:

1) go to your .DBML file design view
2) go to property of particular columns
3) set "Auto generated Value" = true.

it will add following in DBML file IsDbGenerated="true"

Power shell, installutil

Error occur while installing powershell dll.

System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information

Resolution:
make sure you have all the project reference dll in the project, developer always forgot reference dll while delpoying the project.

alternate approch is to load the reference DLL into GAC

String or Binary Data Would Be Truncated Error, LINQ

Error: String or Binary Data Would Be Truncated.

Desc:
Generally this error occurs when we are trying to inser/update large value in SQL server table that are not fit into columns lenght of table.

In one scenario i experienced the following scenario:

I had the one enum like below:
public enum MyEnum
{ First = 101, Second=102, Sixth=103)

now I was using this enum like MyEnum.First and assigning to the one variable
But when i was trying to insert that entity in database using LINQ i was getting the above error:


After doing debugging, I've to do following changes

var myvar = (int) MyEnum.First;

The above statement will return the 101,

that's it for now.

object reference not set to an instance of an object C#

Error: object reference not set to an instance of an object

C# developer usually getting the above error, I'd suggeste first check where you are using Trim(), Substring(), Length(), ToUpper(), ToLower() function with string variables in your codind.

To Resolve:
if(!String.IsNullOrEmpty(userFirstName))
{

-- your userFirstName assignment code here
}

common table expression (CTE) vs Cursor in SQL

----------about CTE------------
http://msdn.microsoft.com/en-us/library/ms190766.aspx
----------about CTE------------


Something to be aware of:

Cursors and temp tables are stored in tempdb.

CTEs and derived tables, if there is enough memory, are stored in memory. If they require more storage than is available in memory, they will use space within tempdb.

Views, if they use aggregate functions or are dealing with large volumes of data, may also touch tempdb.

This is important to consider when looking at performance. Operations that take place in memory are much faster. As soon as you have to touch spinning disk, things slow down. You also have to consider file placement (is tempdb on the same spinning disk as something else? Are tempdb's data and log files on the same spinning disk as something else?), disk controllers (including iSCSI NICs) and other sources of I/O contention.

As mentioned above, cursors allow you to access data in a result-set on a row-by-row basis.

Here's a design pattern I like to use:

Load a result set into a table-typed variable. Either use a candidate key or a surrogate key (provided by ROW_NUMBER() OVER () ) to loop through the table. With smaller sets, it can be MUCH faster than using a cursor.

For an example using a candidate key from within the resultset, instead of deriving a candidate key from ROW_NUMBER, just use test_data.id to identify a row.

Sorry about the lack of intentation... linkedin strips out leading spaces and tabs.

IF EXISTS (SELECT * FROM sys.tables WHERE name = 'test_data')
DROP TABLE test_data
GO

CREATE TABLE test_data (column_1 nvarchar(255), column_2 nvarchar(255)
GO

INSERT INTO test_data (column_1, column_2)
VALUES
('1', 'one'),
('2', 'two'),
('3', 'three')
('4', 'four')

DECLARE @results TABLE
(
row_id int,
column_1 nvarchar(255),
column_2 nvarchar(255)
)

-- load up @results with only those rows where column_2 starts with 't'

INSERT INTO @results (id, column_1, column_2)
SELECT
ROW_NUMBER() OVER(ORDER BY column_1),
column_1,
column_2
FROM
test_data
WHERE
UPPER(LEFT(column_2, 1)) = 'T'

/* since row_id is a candidate key for @results, use it as a bookmark. */

DECLARE @current_row int
DECLARE @current_column_1 nvarchar(255)
DECLARE @current_column_2 nvarchar(255)

SELECT @current_row = MIN(id) FROM @results
WHILE @current_row IS NOT NULL
BEGIN
SELECT @current_column_1 = column_1, @current_column_2
FROM @results
WHERE id = @current_row

PRINT 'Current Row ID:' + CHAR(9) + CAST(@current_row as varchar)
PRINT 'Current Column_1:' + CHAR(9) + @current_column_1
PRINT 'Current Column_2':' + CHAR(9) + @current_column_2

-- get the next id value and start the loop again.
-- If there are no more rows, @current_row will be NULL,
-- thus exiting the loop

SELECT @current_row = MIN(id)
FROM @results
WHERE id > @current_row
END

How to obfuscate a DLL in .NET?

whatis obfuscate in .NET?? Code access security is alternative of obfuscate.
Obfuscate = it the process of scrambling and encrypting the software so that it CAN NOT be easily reversed engineered. The goal is to stop casual hacking to crack the code.


here is some good links
http://www.csharp411.com/net-obfuscators/

Code Access Security (CAS) in .NET

Some good articls
http://www.codeproject.com/KB/security/UB_CAS_NET.aspx
http://msdn.microsoft.com/en-us/library/aa302424.aspx

SQL dynamic IN clause

declare @currentGroup varchar(20),@SQL varchar(max)
set @currentGroup = '''003'',''004'''
select @currentGroup

set @SQL = N'SELECT count(*) from [YOURTABLE] where GRNBR in (' + @currentGroup + ')'
exec (@SQL)

separate first & last name using space, SQL, SPLIT

select
SUBSTRING(elg.FirstName, (CHARINDEX(' ', elg.FirstName) + 1),LEN(elg.FirstName)) AS [LastName]
,rtrim(ltrim(SUBSTRING(elg.FirstName, 1,CHARINDEX(' ', elg.FirstName)))) AS [FirstName]
,elg.FirstName
,elg.LastName
from dbm.EgLoads elg
where elg.BatchId='{207c6838-fe87-40d1-9353-0d60055c93f2}'
and LEN(SUBSTRING(elg.FirstName, (CHARINDEX(' ', elg.FirstName) + 1),LEN(elg.FirstName))) < = 2
and len(elg.FirstName) <> 1

Replicate, Repeat one value in C#

string.Concat(System.Collections.ArrayList.Repeat("0", 66).ToArray());

Convert string to Decimal in C#

(Convert.ToInt32(clm.OutOfPocketAmount) >= 0 ? (Double.Parse((clm.OutOfPocketAmount.ToString().Substring(1))) / 100).ToString("F2") : clm.OutOfPocketAmount.ToString().Substring(0, 1) + (Double.Parse((clm.OutOfPocketAmount.ToString().Substring(1))) / 100).ToString("F2"))

cannot convert between unicode and non-unicode string data types, SSIS

SSIS error:

solution
http://www.mssqltips.com/tip.asp?tip=1393

#database side

1) change the column width in database table for the error coulumn.

#SSIS package side

1) Right click 'Flatfile editor' and select 'Advanced' editor
2) Go to 'Input & Output Properties'
3) Expand 'Flat File Source Output
4) Expand the 'Output columns'
5) Select Error column and change the length.

-- Yup, refresh you're OLEDB connection with updated table information.

ready to go...

good article

"In one of the meetings, he articulated beautifully the importance of maintaining proper work-life balance. He opined that simple attributes such as prior planning and prioritising could help achieve the right balance. In another, he talked about the importance of investing time and resources on research."



http://getahead.rediff.com/report/2010/jan/19/career-taking-meetings-with-narayana-murthy.htm

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

--Error code
DECLARE @dt VARCHAR(10)
SET @dt = '12012009'
SELECT CAST(@dt AS DATETIME)

--Working code
DECLARE @dt VARCHAR(10)
SET @dt = '20091201'
SELECT CAST(@dt AS DATETIME)