A few things in life give as much satisfaction as a well designed and developed application. It really doesn't matter which language or even what you are developing. For me, the latest satisfaction is to see this website developed and up and running. It's been a very long time since I did anything in PHP. It's really great to see the amount of support the development community has and has provided for beginners. I hate to say I am a beginner but yes, after 12 years that's what you become if you don't keep in touch. Yes, a lot of positive experience learning new ways of doing things, using pHp frameworks, Wordpress and what not. I hope I will be able to share all of it soon.
|
APD Beta 2 is here. Features
 Read more ...
 Download installer (EXE, 783KB)
|
Ever wanted to make sure you really got what you paid for when you purchased the last pen-drive?
Disk Checker allows you to check the total amount of 'real' free-space you have on a USB drive. This program was written after I purchased a few pen-drives and came to know that certain sellers on various online shopping sites are selling bogus ones. Disk Checkers ensures you are getting the full capacity you intended at the time of purchasing by writing and reading back the total amount of diskspace reported by your pen-drive. Read more...
 Download Disk Checker(ZIP, 181KB)
|
Start up on an MFC application
I’ve been asked this interview question several times : where is main or WinMain in an MFC application. Though I don’t work with MFC much anymore, I thought I’d write this down once and for all. Here is a diagram with shows the function calls happening on start up: Why does wWinMainCRTStartup get called? Because [...]
Refresh all views in your database
A small little stored procedure which refreshes as views in your database: create procedure usp_refreshAllViews as begin declare @views table ( Id int identity(0,1), ViewName varchar(100) not null ) insert into @views select [name] from sys.views declare @counter int declare @count int declare @viewName varchar(100) select @count = count(Id), @counter = 0 from @views while(@counter [...]
Don’t forget to refresh that view
A potential gotcha that you may come across is when you define a view to return something like this: create view dbo.view_Item as select * from Item And let’s say the Item table has just ItemId and Name columns at this point in time. Everything works fine. Now let’s say you add a new column [...]
Delete duplicate records
I have seen this problem on many SQL forums. I have seen solutions which use CTE. Here is a solution without CTE. For the example, let’s start with a table or a table variable (I have used a table variable to avoid creating a physical table) called @Item. This table has 2 columns: itemid and [...] |
Recent blog posts
Certain answers never seem to change no matter where you are. Often talking to office colleagues the topic of salary comes up – answer remains the same — not enough. Seems little strange since the answer has been the same whether the person gets 10K or 100K per month! I guess it’s the humble Indian [...]