I found this interesting link - http://www.yongfook.com/items/view/81/10-dirty-little-web-development-tricks
it talks about 10 dirty tricks about web development, much of it talks about PHP and other things.. but still its must read for everyone.
Thursday, December 11, 2008
Microsoft launches open source blogging platform
Microsoft has recently launched open source blogging platform called Oxite, I got this new from my friend Sankool Shah - http://www.sankool.net/
It is standard compliant, extensible CMS, designed to support either blogs or larger Web sites, it also supports pingbacks, trackbacks, anonymous or authenticated commenting, gravatars (globally recognized avatars), and most importantly RSS feeds at any page level which means RSS at comments also??? hmm interesting…
http://visitmix.com/ is built using Oxite.
More info - http://news.cnet.com/8301-1001_3-10119017-92.html?part=rss
Oxite - http://www.codeplex.com/oxite/Release/ProjectReleases.aspx?ReleaseId=20210
Wednesday, December 10, 2008
Article: ADO.NET with Windows Forms using Visual C#
Today, I written one more article on ADO.NET, this article is focusing on basics of programming ADO.NET, it is targeted towards students. Its like a tutorial, will take you step by step throughout the tutorial, and will help you create a small application which performs simple, select, edit and delete functionality.
You can read my article here - http://www.learnitonweb.com/Articles/ReadArticle.aspx?contId=6&page=1
and please digg it here - http://digg.com/microsoft/ADO_NET_with_Windows_Forms_using_Visual_C
Standard and Poor’s stock index annual return 1825 to 2008
Found this interesting thing.. which has a graph showing Standard and Poor’s stock index annual return from 1825 to 2008, really interesting to see the way trend is moving, as years are passing frequency of low down of economy is increasing, kind of alarm for us.
Link - http://www.boingboing.net/2008/12/09/sp-returns-and-the-r.html
Sunday, December 07, 2008
Turn Image Template into HTML Page
LearnItOnWeb.com site is back, Today I written an article on Turning Image Template into HTML Page at learnitonweb.com.
here is link to it - Turn Image Template into HTML Site Template
here is link to it - Turn Image Template into HTML Site Template
Sunday, November 30, 2008
BJP Sucks
Read this : http://josh18.in.com/showstory.php?id=355551
BJP is plain interested only in seats.. they are not at all interested in government.. sick ppl.
BJP is plain interested only in seats.. they are not at all interested in government.. sick ppl.
Wednesday, October 22, 2008
Chandrayan
When whole world is going forward.. we are going backward by people like... you know what I am talking about.. anyways I dont want to give that person any un-necessary limelight and move forward.
Today India successfully launched Chandrayaan - I, it will take 15 days to reach the Lunar Orbit.
more info http://in.news.yahoo.com/48/20081022/804/tnl-chandrayaan-i-successfully-put-into_1.html
Today India successfully launched Chandrayaan - I, it will take 15 days to reach the Lunar Orbit.
more info http://in.news.yahoo.com/48/20081022/804/tnl-chandrayaan-i-successfully-put-into_1.html
Tuesday, July 15, 2008
Apple iPhone - is it really worth the hype?
Let's see why iPhone is really hyped... for just two reasons.. 1 - Apple, 2 - Good User Interface providing touch screen... are these really revolutionary things? not really.. its just that they created user interface which can be operated using fingers easily, and just gave touch screen support to the phone. I have a cell phone which has touch screen what it doesn't have it a user interface which can take advantage of the touch screen... you might think that's why iPhone is good and really worth.. well, not just look at what it doesn't have.
1 - Bluetooth
Bluetooth which has become so important for all cell phone user's in a month definitely you must be using Bluetooth once, I use it several times in a week. ok ok I do agree it has Bluetooth, but what is the use of it when it cant do anything else then allow me to talk using bluetooth headset.. it just cant allow me to send files, no dial-up netowrking.. - http://www.iphonebuzz.com/iphones-bluetooth-is-dumb-purposely-crippled-or-both-151188.php
2 - GPS
These days all phones comes GPS receiver, ok I know this is not really big disadvantage, but should have been there. I know now Apple said that they are putting GPS in it.. but is it really high priority? just look at the next one.
3 - Copy Paste
No copy paste in iPhone... now I use need this almost everyday.. I get contact number, email address, web address in sms or some or the other way on my phone I need to copy it and paste it to store it in contacts or call or use browser to surf or send email.. now if copy paste it not there.. I have to remember it.. Is it so really difficult to implement Copy Paste?
4 - MMS
I know no one uses it.. but when you are talking about GPRS, EDGE, 3G then why not MMS???? I would like to send someone picture of mine over message.
5 - Auto-focus Camera
Apple has got Camera in iPhone... but it does not have auto-focus? what is the use of camera which doesn't have auto-focus? not everyone is photographer, even photographer needs auto-focus.
6 - Video Recording
iPhone got camera in it, which can take picture but it can't record the video.
7 - Battery
Yeah, battery is not replaceable at all... if your battery goes bad, send it to Apple and they will replace it for you.. they have sealed battery inside iPhone.. I wonder if my iPhone hangs what to do? I know I know Apple fan boys will say it doesn't hang like Windows Mobile or Nokia... but what if it does?
8 - Network Lock
This is really very very sad... it can operate only on particular network and it comes with 1-2 years of contracts or more... I know cracks are available.. but then you void warranty.
9 - Store Activation
Once you purchase it, you straight can't use it, you have to get it activated from Apple store and activation process is very long takes what about 15-20 minutes.
10 - Applications
iPhone now finally comes with application but what is the use of it when they can't run in the background???
Friday, June 27, 2008
Bill Gates
He has been my inspiration all the time, I have his poster in my bed room :) a great man, wise man... gave a lot of things to people. Today it was his last day at Microsoft from his day-to-day activities.
I wish Microsoft best of luck and I would like to thank Bill Gates a lot, without him today software industry wouldn't exist at all.
Thanks Bill.
PS: do check this out Farewell Speech, you can actually feel that he was almost about to cry I guess...
but really great man..
once again Thank you so much Bill Gates for creating industry.
Wednesday, May 28, 2008
Article: C# 3.0 New Features
Finally I am done with my first Article - here it is - http://www.learnitonweb.com/lowcom/Articles/ReadArticle.aspx?contId=4&page=1
Saturday, May 24, 2008
XBOX 360 or PS3?
If you are thinking about what to go for XBOX 360 or PS3? I recommed this particular link - http://www.gamespot.com/features/6191251/index.html?tag=topslot;title;1 in this they have taken screen shot from same game running on PS3 and XBOX 360 and compared the graphics.. we can clearly see XBOX 360 wins the race :)
btw am getting my XBOX 360 in coming few days :D
btw am getting my XBOX 360 in coming few days :D
Friday, May 02, 2008
Grow Body Parts
this is pretty exciting news story... do read it here - Grow Body Parts - this is really awsome thing to happen in medical science... I hope its a true thing and not a scam.
Thursday, May 01, 2008
Tengu - Community-Credit.com won :D
from community-credit below thing is what I have won... am pretty excited about it now.. more information about it here - Tengu
Wednesday, April 30, 2008
SQL Server 2008 - Table Type Parameter
This is very neat feature in SQL Server 2008 which many people really waited for...
now SQL Server 2008 has got a table type which can be passed as parameters in functions and stored procedures.
simplest example.. lets create employees table.
CREATE TABLE dbo.Employee(
EmpID int NOT NULL,
EmpName nvarchar(100) NOT NULL,
EmpEmail nvarchar(100) NOT NULL)
and create stored procedure to add new employees..
CREATE PROCEDURE NewEmployeeMS(@EmpID int,@EmpName nvarchar(100),@EmpEmail
nvarchar(100))
As
BEGIN
INSERT INTO dbo.Employee
values(
@EmpID, @EmpName, @EmpEmail)
now if I have to add record in it.. I have to execute this procedure multiple times..
now lets take example.. that I got records in another table and I have to get records from that and put it in another table.. I will go about doing it this way..
CREATE TYPE EmployeeTableType AS TABLE
(EmpID INT, EmpName nvarchar(100), EmpEmail nvarchar(100))
creating table type.. and when I create stored procedure it will take parameter as table type only..
CREATE PROCEDURE NewEmployee(@EmployeeDetails EmployeeTableType READONLY)
As
BEGIN
INSERT INTO dbo.Employee
SELECT * FROM @EmployeeDetails
END
notice READONLY thing in parameter.. it says that table is going to be read only.. so no any update, insert, delete will be performed.. just select.. and this thing is necessary.
finally I will do this..
DECLARE @NewEmployees EmployeeTableType
INSERT INTO @NewEmployees
VALUES(1,'John McLean','JohnMcLean@contoso.com')
INSERT INTO @NewEmployees
VALUES(2,'Bob Smith','BobSmith@contoso.com')
INSERT INTO @NewEmployees
VALUES(3,'Ted Connery','TedConnery@contoso.com')
EXECUTE NewEmployee @NewEmployees
now SQL Server 2008 has got a table type which can be passed as parameters in functions and stored procedures.
simplest example.. lets create employees table.
CREATE TABLE dbo.Employee(
EmpID int NOT NULL,
EmpName nvarchar(100) NOT NULL,
EmpEmail nvarchar(100) NOT NULL)
and create stored procedure to add new employees..
CREATE PROCEDURE NewEmployeeMS(@EmpID int,@EmpName nvarchar(100),@EmpEmail
nvarchar(100))
As
BEGIN
INSERT INTO dbo.Employee
values(
@EmpID, @EmpName, @EmpEmail)
now if I have to add record in it.. I have to execute this procedure multiple times..
now lets take example.. that I got records in another table and I have to get records from that and put it in another table.. I will go about doing it this way..
CREATE TYPE EmployeeTableType AS TABLE
(EmpID INT, EmpName nvarchar(100), EmpEmail nvarchar(100))
creating table type.. and when I create stored procedure it will take parameter as table type only..
CREATE PROCEDURE NewEmployee(@EmployeeDetails EmployeeTableType READONLY)
As
BEGIN
INSERT INTO dbo.Employee
SELECT * FROM @EmployeeDetails
END
notice READONLY thing in parameter.. it says that table is going to be read only.. so no any update, insert, delete will be performed.. just select.. and this thing is necessary.
finally I will do this..
DECLARE @NewEmployees EmployeeTableType
INSERT INTO @NewEmployees
VALUES(1,'John McLean','JohnMcLean@contoso.com')
INSERT INTO @NewEmployees
VALUES(2,'Bob Smith','BobSmith@contoso.com')
INSERT INTO @NewEmployees
VALUES(3,'Ted Connery','TedConnery@contoso.com')
EXECUTE NewEmployee @NewEmployees
SQL Server 2008 - MERGE Function
I am quite impressed with the MERGE function.. in SQL Server 2008, which is a new feature added.
lets take a simplest example to understand MERGE Function.
let's say we got a PurchaseRecords table, in which we are storing customerId and productId and PurchaseDate...
here is code to create a table with all indexes..
IF OBJECT_ID (N'dbo.PurchaseRecords', N'U') IS NOT NULL
DROP TABLE dbo.PurchaseRecords;
GO
CREATE TABLE PurchaseRecords (ProductID int, CustomerID int, PurchaseDate datetime);
GO
IF EXISTS (SELECT name FROM sys.indexes
WHERE name = N'IX_PurchaseRecords_ProductID')
DROP INDEX IX_PurchaseRecords_ProductID ON dbo.PurchaseRecords;
GO
CREATE CLUSTERED INDEX IX_PurchaseRecords_ProductID
ON dbo.PurchaseRecords (ProductID);
GO
and here is the code to insert some dummy records in table.
INSERT INTO PurchaseRecords VALUES(707, 11794, '20060821'),
(707, 15160, '20060825'),(708, 18529, '20060821'),
(711, 11794, '20060821'),(711, 19585, '20060822'),
(712, 14680, '20060825'),(712, 21524, '20060825'),
(712, 19072, '20060821'),(870, 15160, '20060823'),
(870, 11927, '20060824'),(870, 18749, '20060825');
GO
now we gona have a table which is going to store information regards to CustomerPurchaseHabit..
and code for that is here..
IF OBJECT_ID (N'dbo.FactBuyingHabits', N'U') IS NOT NULL
DROP TABLE dbo.FactBuyingHabits;
GO
CREATE TABLE FactBuyingHabits (ProductID int, CustomerID int, LastPurchaseDate datetime);
GO
IF EXISTS (SELECT name FROM sys.indexes
WHERE name = N'IX_FactBuyingHabits_ProductID')
DROP INDEX IX_FactBuyingHabits_ProductID ON dbo.FactBuyingHabits;
GO
CREATE CLUSTERED INDEX IX_FactBuyingHabits_ProductID
ON dbo.FactBuyingHabits (ProductID);
GO
INSERT INTO FactBuyingHabits VALUES(707, 11794, '20060814'),
(707, 18178, '20060818'),(864, 14114, '20060818'),
(866, 13350, '20060818'),(866, 20201, '20060815'),
(867, 20201, '20060814'),(869, 19893, '20060815'),
(870, 17151, '20060818'),(870, 15160, '20060817'),
(871, 21717, '20060817'),(871, 21163, '20060815'),
(871, 13350, '20060815'),(873, 23381, '20060815');
GO
ok now what we want to do is.. we want to go through each records in PurchaseRecords and check whether this information exists in FactBuyingHabits or not.. if it exists then update its date if it doesnt then insert it, now if we want to do this.. we will go about creating cursor then if condition inside it and do it.. what do we get? we get result.. but cursors are very slow... in SQL Server 2008 Microsoft introduced MERGE function which allows us to do this pretty easily, and performance is increased pretty good.
and code for this is something like following:
MERGE FactBuyingHabits AS fbh
USING (SELECT CustomerID, ProductID, PurchaseDate FROM PurchaseRecords) AS src
ON (fbh.ProductID = src.ProductID AND fbh.CustomerID = src.CustomerID)
WHEN MATCHED THEN
UPDATE SET fbh.LastPurchaseDate = src.PurchaseDate
WHEN NOT MATCHED THEN
INSERT (CustomerID, ProductID, LastPurchaseDate)
VALUES (src.CustomerID, src.ProductID, src.PurchaseDate);
lets take a simplest example to understand MERGE Function.
let's say we got a PurchaseRecords table, in which we are storing customerId and productId and PurchaseDate...
here is code to create a table with all indexes..
IF OBJECT_ID (N'dbo.PurchaseRecords', N'U') IS NOT NULL
DROP TABLE dbo.PurchaseRecords;
GO
CREATE TABLE PurchaseRecords (ProductID int, CustomerID int, PurchaseDate datetime);
GO
IF EXISTS (SELECT name FROM sys.indexes
WHERE name = N'IX_PurchaseRecords_ProductID')
DROP INDEX IX_PurchaseRecords_ProductID ON dbo.PurchaseRecords;
GO
CREATE CLUSTERED INDEX IX_PurchaseRecords_ProductID
ON dbo.PurchaseRecords (ProductID);
GO
and here is the code to insert some dummy records in table.
INSERT INTO PurchaseRecords VALUES(707, 11794, '20060821'),
(707, 15160, '20060825'),(708, 18529, '20060821'),
(711, 11794, '20060821'),(711, 19585, '20060822'),
(712, 14680, '20060825'),(712, 21524, '20060825'),
(712, 19072, '20060821'),(870, 15160, '20060823'),
(870, 11927, '20060824'),(870, 18749, '20060825');
GO
now we gona have a table which is going to store information regards to CustomerPurchaseHabit..
and code for that is here..
IF OBJECT_ID (N'dbo.FactBuyingHabits', N'U') IS NOT NULL
DROP TABLE dbo.FactBuyingHabits;
GO
CREATE TABLE FactBuyingHabits (ProductID int, CustomerID int, LastPurchaseDate datetime);
GO
IF EXISTS (SELECT name FROM sys.indexes
WHERE name = N'IX_FactBuyingHabits_ProductID')
DROP INDEX IX_FactBuyingHabits_ProductID ON dbo.FactBuyingHabits;
GO
CREATE CLUSTERED INDEX IX_FactBuyingHabits_ProductID
ON dbo.FactBuyingHabits (ProductID);
GO
INSERT INTO FactBuyingHabits VALUES(707, 11794, '20060814'),
(707, 18178, '20060818'),(864, 14114, '20060818'),
(866, 13350, '20060818'),(866, 20201, '20060815'),
(867, 20201, '20060814'),(869, 19893, '20060815'),
(870, 17151, '20060818'),(870, 15160, '20060817'),
(871, 21717, '20060817'),(871, 21163, '20060815'),
(871, 13350, '20060815'),(873, 23381, '20060815');
GO
ok now what we want to do is.. we want to go through each records in PurchaseRecords and check whether this information exists in FactBuyingHabits or not.. if it exists then update its date if it doesnt then insert it, now if we want to do this.. we will go about creating cursor then if condition inside it and do it.. what do we get? we get result.. but cursors are very slow... in SQL Server 2008 Microsoft introduced MERGE function which allows us to do this pretty easily, and performance is increased pretty good.
and code for this is something like following:
MERGE FactBuyingHabits AS fbh
USING (SELECT CustomerID, ProductID, PurchaseDate FROM PurchaseRecords) AS src
ON (fbh.ProductID = src.ProductID AND fbh.CustomerID = src.CustomerID)
WHEN MATCHED THEN
UPDATE SET fbh.LastPurchaseDate = src.PurchaseDate
WHEN NOT MATCHED THEN
INSERT (CustomerID, ProductID, LastPurchaseDate)
VALUES (src.CustomerID, src.ProductID, src.PurchaseDate);
Bad Captcha
This is seriously bad captcha.. I cant understand what it says...
while I was writing above post I got this captcha..
Wednesday, April 16, 2008
Tuesday, March 11, 2008
Tuesday, March 04, 2008
Site done
It's almost 2 months, since I have blogged about anything... I got caught up with lots of hectic schedule and lost track of many things.... I was also working very hard on a site and finally I have completed web site after a long time, here it is http://www.LearnITOnWeb.com/ - still I have not added RSS to it, but will be doing that too as well very quickly. I now have to load site with lots and lots of content and get it to good rolling.
I have been busy with lots of work these days, which I am executing very soon in a 2 months time frame.
but you will find me blogging again now.. I have managed to get back on to track and get back on to calendar and tasks - yeah this happens to me.. many times I just loss track of my calendar and task list.
btw if any of you coming to Launch 5th March 2008 - Regal Cinema, do let me know.. will meet up for sure. - more information - http://www.heroeshappenhere.co.in/
I have been busy with lots of work these days, which I am executing very soon in a 2 months time frame.
but you will find me blogging again now.. I have managed to get back on to track and get back on to calendar and tasks - yeah this happens to me.. many times I just loss track of my calendar and task list.
btw if any of you coming to Launch 5th March 2008 - Regal Cinema, do let me know.. will meet up for sure. - more information - http://www.heroeshappenhere.co.in/
Tuesday, January 08, 2008
Saturday, January 05, 2008
Here comes another bubble
looking at the way so many web 2.0 sites coming up.. blog sites.. community sites and what not... this video justifies it all.
and like in song of the video says.. blog it blog it.. blog this song.. so here I am doing it :D
http://www.youtube.com/watch?v=I6IQ_FOCE6I
and like in song of the video says.. blog it blog it.. blog this song.. so here I am doing it :D
http://www.youtube.com/watch?v=I6IQ_FOCE6I
Friday, January 04, 2008
PUG Meet
I will be in Pune tomorrow (5th January 2008) and will be presenting at PUG meeting.
Topic: Building Communication Aware Applications for Windows Mobile
Abstract: In this presentation Mayur Tendulkar will show how developers can leverage the functionality provided by Microsoft Windows Mobile platform to build Communication aware application. This will include, making and receiving calls, SMS interception, Bluetooth development, using emulators and real devices
Speaker: Mayur Tendulkar
Topic: ASP.NET URL Rewriting
Abstract: URL Rewriting is process of simplifying complex URLs, which are easily remembered by users and adds a great business value to web site in terms of Search Engine Optmization
Speaker: Dhaval Faria
Time: 2:30 PM to 5:30 PM
Address: Microsoft Corporation (I) Pvt. Ltd.202, 2nd Floor, Phoenix, Bund Garden Rd., Opp. Pune Residency Club, Pune 411001, Maharashtra, India
Topic: Building Communication Aware Applications for Windows Mobile
Abstract: In this presentation Mayur Tendulkar will show how developers can leverage the functionality provided by Microsoft Windows Mobile platform to build Communication aware application. This will include, making and receiving calls, SMS interception, Bluetooth development, using emulators and real devices
Speaker: Mayur Tendulkar
Topic: ASP.NET URL Rewriting
Abstract: URL Rewriting is process of simplifying complex URLs, which are easily remembered by users and adds a great business value to web site in terms of Search Engine Optmization
Speaker: Dhaval Faria
Time: 2:30 PM to 5:30 PM
Address: Microsoft Corporation (I) Pvt. Ltd.202, 2nd Floor, Phoenix, Bund Garden Rd., Opp. Pune Residency Club, Pune 411001, Maharashtra, India
Thursday, January 03, 2008
Underwater Digital Camera
you wont find me blog abotu gadgets very often.. though I am gadget freak as many of you knows...
but this thing just catches my eyes.. and looks a bit funny, you might have seen many waterproof cameras... this one is no different apart from its looks... this digital camera just makes it perfect to catch moments while ur catching up fish, shells, shark, jelly fish, etc... and u dont have to be busy holding it with one hand and pressing shutter button with another.
Wednesday, January 02, 2008
Thanks to Community-Credit for Crediting me with Artoo Potatoo
as many if you know I am very much into community contribution... I have been contributing to the community since 2000-2001, few days back I discovered a site called http://www.community-credit.com/ this site credits community contributor with stupid geeky prizes... I have won the 14th prize - Artoo Potatoo. I am now waiting for my prize to come... :D I am excited about this.. and would like to really thank Community-Credit for this.
Thank you Community-Credit and David Silverlight :D
Tuesday, January 01, 2008
Bye Bye Netscape
AOL announced that Netscape wont be Supported from 1st February 2008 - Source - http://blog.netscape.com/2007/12/28/end-of-support-for-netscape-web-browsers/
I have a very special respect for Netscape, its because of Netscape I am what I am :)... not talking about internet... ok let me talk in a more detail... 1997 got my first internet connection that time Netscape was the only browser popular among the users, I still remember version number Netscape Navigator 4.5 and 4.6 being my mots fav that time... I used Netscape Navigator to surf web sites, check emails and many more things... one day accidently or fortunately I mistaked Composer option in Netscape as Compose for email... which incidently had the same icon and with same name and same place for writing email in netscape email program (dont remeber name but operated from same application), I thought Composer is for email, clicked on it... and I was introduced to a whole new world of HTML... and my journey begins to the programming world :), and one more respect to Netscape for coming up with javascript....
its sad to know that Netscape wont be there sooner.. which will actually mean lesser competition and might slow down the development in the browser market.. the kind of revolution you can see in IE from IE 6 to IE 7 and in next version IE 8 is because of competition from Firefox, Opera and others... hope this continues and consumers gets more out of it.
Netscape will be remembered forever.
PS: I stopped using Netscape after IE 4.1
I have a very special respect for Netscape, its because of Netscape I am what I am :)... not talking about internet... ok let me talk in a more detail... 1997 got my first internet connection that time Netscape was the only browser popular among the users, I still remember version number Netscape Navigator 4.5 and 4.6 being my mots fav that time... I used Netscape Navigator to surf web sites, check emails and many more things... one day accidently or fortunately I mistaked Composer option in Netscape as Compose for email... which incidently had the same icon and with same name and same place for writing email in netscape email program (dont remeber name but operated from same application), I thought Composer is for email, clicked on it... and I was introduced to a whole new world of HTML... and my journey begins to the programming world :), and one more respect to Netscape for coming up with javascript....
its sad to know that Netscape wont be there sooner.. which will actually mean lesser competition and might slow down the development in the browser market.. the kind of revolution you can see in IE from IE 6 to IE 7 and in next version IE 8 is because of competition from Firefox, Opera and others... hope this continues and consumers gets more out of it.
Netscape will be remembered forever.
PS: I stopped using Netscape after IE 4.1
Subscribe to:
Posts (Atom)
