Saturday, November 22, 2008

Identity Columns in MS SQL Server


Identity columns in MS SQL Server from Nitin Reddy on Vimeo.

Yet Another Deathcast

Abraham Biggs (alias CandyJunkie), a 19-year-old teenager from Florida, committed suicide last Wednesday while providing a live video feed via his webcam. The cause of his death was drug overdose.

A video of the incident can be found here.

Thursday, November 20, 2008

Software Engineering Conferences

International Conference on Software Engineering (ICSE)
http://www.icse-conferences.org/

Working IEEE/IFIP Conference on Software Architecture (WICSA)
http://www.wicsa.net/

Association for Computing Machinery: Special Interest Group on Software Engineering (ACM SigSoft)
http://www.sigsoft.org/

Working Conference on Reverse Engineering (WCRE)
http://swerl.tudelft.nl/wcre2008/

IEEE International Conference on Software Maintenance (ICSM)
http://www.icsm2008.org/

Themes in GMail

GMail has introduced a super-cool themes so you can customize the look of the interface. I particularly like the Ninja and the Graffiti themes. The Tea House theme require a really high resolution - my 1280x800 isn't enough and I have to scroll vertically to see the tea houses. Most of the themes work with just about any resolution though.

You can access the themes from the Themes tab under Settings.




Wednesday, November 19, 2008

Windows 2008 R2


Windows Server 2008 R2 Overview

From: aschek,
2 weeks ago


Windows Server 2008 R2 Overview
View SlideShare presentation or Upload your own. (tags: microsoft r2)






SlideShare Link

Javascript Libraries


JavaScript Library Overview

From: jeresig,
2 years ago


JavaScript Library Overview
View SlideShare presentation or Upload your own. (tags: dojo prototype)



JavaScript Library tutorial that I gave at the October 2007 Ajax Experience conference.



SlideShare Link

Monday, November 17, 2008

Multi-row INSERT

With SQL, we can SELECT, UPDATE and DELETE multiple rows simultaneously, but we can normally INSERT only one row at a time.

There ways around this, but they usually involve selecting a resultset and passing it to an INSERT statement like this:
INSERT INTO emp (id, ename)
SELECT 4567, 'nitin'
UNION ALL
SELECT 4568, 'naina'

With Microsoft SQL Server 2008, you can now insert multiple values with an INSERT statement. Example:
INSERT INTO emp (id, name) VALUES (4567, 'nitin') (4568, 'naina')

This ought to make help make applications more efficient as they can send multiple values in one go instead having to send data to the server one row at a time.

Will other database engines follow suit and adopt this syntax? Time will tell.

Windows Scheduler Task or Windows Service

I've noticed a lot of projects on which the developers add windows services when all they need is a console application running as a scheduled task (using the Windows task scheduler).

A windows service is a pretty good approach when you need to have something constantly running such as a network service to respond to client requests or a heartbeat service to check application health every couple of seconds.

However, if you've got a windows service running in the background waiting on a timer to execute some bit of code, then you might want to consider using a scheduled task. They're easier to debug, require less development effort and do their job reasonably well.