2008 02 13
Data viewers for debugging data flow tasks
TOP n WITH TIES
RANK(), DENSE_RANK(), NTILE()
SCOPE_IDENTITY(), @@IDENTITY
Excel long numbers and text
Data viewers for debugging data flow tasks
TOP n WITH TIES
RANK(), DENSE_RANK(), NTILE()
SCOPE_IDENTITY(), @@IDENTITY
Excel long numbers and text
… is not really common anymore. One of the reasons why he stayed common was due to the restriction on access to “uncommon” content. But with each day, access to information is getting faster and unrestricted. The ease of finding content online is changing the perspective of content owners. Content owners themselves are distributing it for open use.
Here are some of my observations:
Can’t (afford to) go to a top school? How about top schools coming to you – MIT open courseware and UC Berkely lecture videos.
Want to impress your friends with magic tricks? They probably have already seen it on youtube (as well)!!
How about debugging your code down into the source code of .NET framework class?
TV broadcast content is available on their websites as well. (abc, nbc, and live streaming too cnn ibn)
If you have seen beryl in action on ubuntu, you would’ve said “wow” atleast 5 times!!!
yod’m 3D does some of it on windows. Multiple desktops with a slick cube rotation to switch sides.
Deskpot is a decent virtual desktop manager too.
btw… this is how to embed youtube videos into blogpost on wordpress.com
[ youtube=http://youtube.com/w/?v=_dIya1aJJKA]
is one of the most overused/misused phrase to describe something new. However, are the new things “really” new?
To get you thinking on these, here is a video of Ricardo Semler’s intriguing lecture at MIT. And this article called Coding from Scratch from the sun website.
Links via J, G and C
on google videos. These things are enlightning. I watched a very few of them and found the one on human computation is especially interesting. I thought captchas were the final solution to bots.
On an another note… sysinternals (yeah! ms bought them over too!) tools are helpful. I just seemed to have fixed a long standing issue with bad wireless connections.
Animated video of communication over TCP: warriors of the internet. Thanks Pat!
Get a feel of whats coming next from MS, the public betas are available.
IE7: beta3 currently looks much better and less buggy than the earlier beta2
Office 2007: download or TestDrive Online
Vista: am yet to try this out.
I am trying the first two, and find them as great improvements.
plug-in for SQL server tools that enables intellisense while writing queries. Works with SQL query analyzer and also SQL Management studio
http://www.red-gate.com/products/SQL_Prompt/index.htm
via secretGeek
Microsoft seems to be envisioning a great potential in the Mobile and embedded device market. I'm just done attending the sessions at MEDC06; not really related to my current work but was fun. There was a contest towards the end of the conference and three lucky wipro-ites hijacked the top three prizes 1 2 3!!
Things that still surprise me is the slow adoption rate of the Tablet PC and Windows Mobile devices. Ofcourse; the all-new-n-cool origami was also showcased at the conference.