Friday, December 30, 2011

Kudoz ... to people who contributed to Technology

2011 has being a great year for technology.  iPad, iPod to Aakash Tablet, Android, Ice Cream Sandwich Operating system, every one of them has changed how we see or think of technology. They have bought a new change in technology. But while all this happening, on the other side the people who bought these changes in technology were leaving this world.. This post is dedicated to all those people who have made this happen…

1] Steve Jobs (CEO, Apple Inc.)

steve-jobs-iPod-iPad-iMac-iPhone

The one who bought biggest change, father of Apple Inc Steve Jobs died on 5 October, he was suffering from cancer. He made people to look at technology from another view through products like iMac, iPod, iPhone, iPad… and such more products showed a different direction to technology.



2] Dennis Ritchie (Founder of The C language and The UNIX Operating System)


Dennis-Ritchie-C-Language-UNIX-Operating-System

He was an American scientist who helped shape the digital era. He created the C programming language and with his longtime colleague Ken Thompson the UNIX operating system. He received the National Medal of Technology from President Clinton in 1999. Though he was not popular amongst common people (the non-programmers :P)  it would not have being possible to see all those software’s we use in our day to day life for sure.

3] Paul Baran (Founded the Internet)

paul-baran-internet-ARPANET
Paul Baran in 1960 started a project which included “Data Packet Switching” which later evolved into ARPANET which further increased to matrix of networks which we call it “The Internet”.
Baran died in Palo Alto, California  at the age of 84 on March 26, 2011,[1][20] due to complications from lung cancer

4] John McCarthy (Father of Artificial Intelligence)

john-maccarthy-artificial-intelligence
John McCarthy (September 4, 1927 – October 24, 2011) was an American computer and cognitive scientist. He coined the term "artificial intelligence" (AI), invented the “Lisp” programming language and was highly influential in the early development of AI.
McCarthy also influenced other areas of computing such as time sharing systems. He received the Turing award for his major contributions to the field of AI, and many other accolades and honors, including the United States National medical of Sciences.

5] Jean Bartik (one of the original programmers of ENIAC)

jean-bartik-two-women-programmers
Jean Bartik (first from left)

She was one of the original programmers of ENIAC (the first computer). She was supposed to be first lady programmer. She quit her program and left this world on 23 march of this year. 

6] Jerald Lawson (Video game maker)

gerald-lawson
Gerald “Jerry” Lawson, creator of the first cartridge-based videogame console, died Saturday morning in a Mountain View, California, hospital, Wired.com has learned. Lawson was 70.
As an engineer at Fairchild Semiconductor, Lawson designed the electronics of the Fairchild Video Entertainment System, later renamed the Channel F, in 1976.
A lifelong engineer and tinkerer, Lawson was born in 1940 and grew up in a federal housing project in Queens, New York. As a kid, he operated a ham radio; as a teenager he earned money by repairing his neighbors’ television sets.
One of his Quotes
“The whole reason I did games was because people said, ‘You can’t do it,’” he told the San Jose Mercury News last month. “I’m one of the guys, if you tell me I can’t do something, I’ll turn around and do it.”
At 6:15 a.m. Saturday, Lawson died after apparently suffering a heart attack. He is survived by his wife, son and daughter. The family is planning a memorial service in mid-May.

7] Robert Galvin (contributed in finding Cell phone)

Robert-galvin
Robert Galvin (first from right)

 Robert Galvin, who over nearly three decades as Motorola's CEO transformed the maker of police radios and TVs into one of the world's leading electronics companies, has died. He was 89.
Galvin died Tuesday night in Chicago of natural causes, his family said.
Galvin oversaw Motorola's pioneering efforts in the cellular industry, including the creation of the first commercial cellphone in 1973 and the construction of the first cellphone network in the early 80s.

And many more like these... they will always be remembered and cherished.

Monday, December 26, 2011

Android Code name/Flavor?

Android will be releasing its new OS code named “Ice cream Sandwich”. Unlike Apple, which doesn’t update its OS frequently. After reading more about android I came to know that all the code name of android OS are some or other desserts!! And this is not the only thing…all of them are alphabetically ordered. Starting from Cupcake, Donut, Eclair, Froyo, Gingerbread, Honeycomb, Gingerbread. And the latest to come off course the Ice cream sandwich.
android-ice-cream-sandwich-market


Since the code name started with Cupcake, you must have started wondering what about earlier version before Cupcake? The pre- release version of android were Astro and Bender but could not be used due to trademark reasons.

The release of latest android OS made me think what must be the next OS code name? one name came to my mind “Jalebi” … :P but most of the other code name are US desserts.

Any ways let me know what you all think of…

Saturday, December 24, 2011

Transfer data from Excel to MS SQL Server using DTS(Data Transformation Services)

 MS SQL Server 2008 tutorial :  DTS (Data Transformation Service in SQL Server)

For those who dont know DTS(Data transformaiton service), its a MS SQL Server tool to import/export data to and from MSSQL Server tables from various sources like Microsoft Excel file, Access file, another flat file, or any other MSSQL Server table.
This post will will make all the doubts clear regarding DTS in sql.

Now to demostrate DTS we will take a following example.
Consider you want to transfer a data from Excel sheet to MSSQL table. Like the one below


ms-excel-pivot-table-excel-add-ins-microsoft-excel-pivot-table-ms-excel-pivot-table-examples
Fig 1: An Excel Sheet example

For sake of explanation the XL sheet contains only 10 records. But actually it can contains thousands and lakhs of data.

Now before we start the process there are few pointers that should be checked/remembered, which are as follows:
  • The XL sheet that you needs to be exported to sql must have Column names similar to column names of table present in MS SQL Server 2005/2008 database. The reason?  explained later in this post.data-transformation-services
Fig 2: Table in SQL server with same Column names
In XL sheet column header must be followed by a "Dummy data row". Notice that in Fig 1 there is no dummy row. Now why do we need this dummy row. According to working dts sql service checks the XL's first few row's (first 8-16 rows to be precise) and counts which row has bigger data in terms of characters and sets it max, thus if your table contains max character of rows in 30th record dts will throw an Truncation error. Thus we set a dummy row large enough to tell dts that this is the largest data row in our table. After putting dummy row the XL sheet looks like below

Fig 3: Excel Sheet with Dummy data row


Now we are set. To start..open SQL Server Management Studio (2008 R2 here in my case).
>> Right click the database where the table exists and select "Import Data". This is the way i prefer. Show in figure below.

sql-server-management-studio-server-express
Fig 4: Navigating to Import/Export wizard

After this the Import / Export wizard opens up.

sql-server-versions

Fig 5: the Import/Export Wizard


Click Next and in next window select "Microsoft Excel" in Data Source (shown in fig 6) 
microsoft-sql

Fig 6
Now look at fig below(fig 7)... the check box marked in red..read what it says...."First row has column names ". Yes .. this is the one reason why we kept the column names similar... but the actual reason is still ahead...

packages-in-sql
Fig 7
After selecting Data Source, Browse the XL sheet  and click next...Let the Destination and Server name be same if you navigated like fig 4.  Note: The Destination changes depending upon Operating system and how you have installed MS SQL server. (shown in fig 8)

sql-dts-sql-dts
Fig 8



After Clicking Next below screen appears. let the first radio option be selected (shown in fig 9)
dts-in-sql
Fig 9

In next window select appropriate sheet on left and appropriate sql server table on right. (As show in fig 10)

it-services-wikipedia
Fig 10

Now on the same above window dont forget to Click "Edit Mappings". When you click it a window similar to fig shown below will open up depending on which version of sql server you are using..


transform-in-sql
Fig 11

Now if your XL sheet and sql server table column names match the source and destination will match automatically as in this example show in fig above.This is second reason why we kept XL and sql server column names similar, because if you have more columns in XL we can keep matching them here in this wizard. If the column names donot match the destination column in above window shows "ignore". Dont worry you can still match them if you have missed one or another. After you click Ok next window appears


dts-in-sql
Fig 12

Dont forget to select ignore options for last two drop downs at the end of window. After you click next following window shows up.

sql-query-analyzer

Click Next and following window shows up
what-is-data-transformation


After you click finish the actual process starts..
Oppsss!!!! and error occured.

search-in-sql

To know more about error Click "Messages"
In this case following was error


sql-service

After reading the error carefully, i came to know that we forgot to provide additional information in window shown in  fig 11

dts-sql-server
Now why did the problem occured? Because our excel sheet contains number in "cust_id" and cust_id is primary identity field in sql server. Thus we need to tell dts that we are allowing to put identity field through XL sheet. Everthing in this case would have gone right if cust_id was not present.

Any ways if all things go right then the following screen appears
sql-data-transformation-services

Now go check the data base table...

If you have any doubts leave a comment...

Friday, December 23, 2011

-o || Programmer || o-

To be a good programmer is difficult and noble. The hardest part of making real a collective vision of a software project is dealing with one’s co-workers and customers. Writing computer programs is important and takes great intelligence and skill. But it is really child's play compared to everything else that a good programmer must do to make a software system that succeeds for both the customer and myriad colleagues for whom she is partially responsible. In this post I attempt to summarize as concisely as possible those things that I wish someone had explained to me when I started developing interest in developing programs.


programming-programmer-BASIC-LOGO

I have being programming since my school days. I remember writing small programs in BASIC(for those how don’t know BASIC is ) and LOGO(it was a meant to draw different geometrical shapes using commands) . But actually later I came to know LOGO was more than that. I remember very interesting thing about LOGO, the cursor which we see now a days in LOGO there used to be a triangle which was called as “Turtle”. Anyways even in those days that programs would seem more difficult. I read an interesting article about programmers which I would like to share…



punctual-mark-in-english
Signs that you shouldn't be a programmer:
The following may not have any remedies if you still suffer from them after taking a programming course in school, so you will stand a better chance of advancing your career by choosing another profession.

1. Inability to determine the order of program execution
Symptoms

a = 5
b = 10
a = b

print a

1. You look at the code above and aren't sure what number gets printed out at the end

Alternative careers
1. Electrician
2. Plumber
3. Architect
4. Civil engineer

meaning-of-a-quote

LOL.. so all "wanna be" programmers would now have decided an Alternative careers. So in my upcomming post i am going to start a "How to" guide for programmers right from debugging a code to performance fix and lots more...



Wednesday, December 14, 2011

Ubuntu to rescue...

Hello all,
Linux has being a great competitive as well as alternative OS to Windows/Mac etc.. Many things you can do with Linux and today  I want to share this experience with you all.

But before this, a short trailer of how i found myself in soup and how Linux save the day.. Read on...

Into the Problem:
Day before yesterday i was extending my C drive using Disk management utility. my C drive at that time was 15Gb :P, Since i need developing tools on my Laptop C drive need more space. Following are list of my tools i use with its approx disk usage
* MS SQL Server 2008 R2 - takes almost 2.5GB
* MS Visual Studio 2008 - 6GB
and some times Visual studio 2010 which takes whopping 7 GB... :/ and other such tools...

OK, now back to point, I couldn't extend the C drive for some reasons. So my friend suggested to use Partition Magic to  extend or shrink a Drive.. Never needed to use partition software's.. it was first time i was going to use it. I downloaded it from Torrent z as usual.. Next was least expected or my bad luck.. when i ran the setup, an error occurred saying Drive label not found. When i opened the Windows explorer i  was shocked.. it was showing only my C drive and all my other drive (D: E: F:) were missing... I didn't knew what to do that time, so as usual to solve any problem in windows i restarted my laptop... and this was another mistake i did... i knew problem was related to Partition table.. and after that my OS didnt boot.. The error was "Operating System not found". It was disaster for me.. all my data was there in hard disk but i couldn't access it. So instead of setting up new Win 7, i decided to create a LiveUSB of Linux...



Linux-ubuntu-Natty-Narwhal-to-rescue-Windows7-Ubuntu-how-to
Before the problem existed i was using Ubuntu 11.04(Natty Narwhal) on diffrent partion. Finally created a LiveUsb of Ubuntu , backed up all my data on my portable HDD and now there was no problem to format my Laptop hard disk... So during formating i even partitioned drives, installed Win7 again, and my machine was up again for working..
-----------------------------------------------------------------
Lessons learned :

* Never trust and download softwares from sites which you are not sure of.
* If you dont know how to use some software, take help of a technician.
* And even in worst case dont panic.. "Always carry your brain with you"

In my next blog i will give all the details of how to create LiveUSB linux.

Friday, December 2, 2011

Bored... Play Tic-Tac-Toe






level 0 -- Computer is totally dumb.


level 1 -- Computer is smarter (original version).


level 2 -- You MAY win (only when you start).


level 3 -- Computer NEVER lose's.


Related Posts Plugin for WordPress, Blogger...follow kalekushal.blogspot.com