StrokeIt

This is a must have utility on all Windows machines.  StrokeIt is a mouse gesture recognition program. Once you install the program simply right click and make gestures with your mouse to perform actions. For example I never have to move my mouse to the corner of a window to minimize it, I just make a small mouse movement and presto the window minimizes.

Some browse like Opera and Mozilla have mouse gestures built-in but Stroke It is truly unique in that it work on all windows. And the best thing I love is its small footprint (less than 200k). Stroke It is so cool almost everyone at my office uses StrokeIt.  Get it here.

Use scope_identity() instead of @@identity

TravisL explains why we should use scope_identity instead of @@identity when we want to get the ID of the last record that was added.

The problem with @@identity is that it returns the ID of the last record that was in the current connection. In which case if the table that you adding to has triggers (which inserts records in other tables) then @@identity returns the ID of the last record that was added by code inside the trigger. This becomes a potentially very difficult bug to track down.

So what should you do? Use scope_identity() which returns the ID of the last record that was inserted in the current scope. See MSDN:scope_identity() for detailed examples. 

Keyboard Shortcuts

Are you a keyboard freak like me? Then you've got to know how to add shortcuts to your frequently used programs so that you can launch them from the keyboard.

If you want to be a keyboard freak know the default shortcuts that come with the programs, the ones that I use most are given below. To try this press WinKey + R and then type in any of the following shortcuts and press enter. Presto, see ma no mouse!

  • cmd - Command Window
  • explorer - Windows Explorer
  • iexplore - Internet Explorer
  • notepad - Notepad
  • winword - Word
  • outlook - Outlook
  • excel - Excel
  • devenv - Visual Studio
  • inetmgr - IIS
  • iisreset - Restart IIS
  • isqlw - SQL Query Analyser
  • services.msc - Windows Services
  • calc - Calculator
  • compmgmt.msc - Computer Manager

To add your own shortcuts to other programs that you use most often there are two ways. I like the more elegant second method which uses the.

Shorten shortcuts: Instead of typing paths in the Run box or Address bar, create shortcuts in the folders Windows looks in by default. In Windows 9x and Me, try the Windows\Command folder. In Windows 2000 and XP, put the shortcuts in the Windows\System folder (not Windows\System32), since the System folder is relatively uncrowded.

To create the shortcuts, open Explorer and select the applications, folders, and files you use most often. Right-click and drag them to one of the aforementioned Windows folders, release the mouse button, and choose Create Shortcut(s) Here. (You can also create shortcuts to Web pages this way.) Give each a short name so you can launch it with little typing; you could name your word-processor shortcut wp, for example. Don't use the name of an existing folder, since doing so could confuse the Address bar or the Run box.

When using this tip with the Address bar, include .lnk (the hidden extension for shortcuts) when you type the name of a non-Web shortcut--wp.lnk, say. And in both the Run box and the Address bar, add .url when launching Web shortcuts--for example, pcw.url. If you store batch files in one of these folders, omit the .bat extension when entering file names.

Bypass paths: To cut down on typing even more, choose Start, Run, type regedit, and press Enter. Select this folder in the left pane: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths. Right-click App Paths in the right pane and choose New, Key. Type the shorthand name in the Address bar followed by .exe--regardless of whether you plan to launch an application or a file. For instance, type r.exe to launch a report file in a desktop publishing app. Press Enter to complete the naming.

Select your new shorthand key in the left pane and double-click (Default) in the right pane. In the 'Value data' box, type the path and name of the program, data file, or shortcut you want to launch. (Add .lnk to the name of shortcut paths, and .url to the end of Web shortcuts.) For example, type c:\My Documents\Quarterly Report.indd (see FIGURE 4). Click OK and exit the Registry Editor. Now when you enter your shorthand text (minus the .exe) in the Address bar or the Run box--such as r, to continue the example above--Windows will open the specified file.

Preview of Web Development with Visual Studio Whidbey

Discusses the new features in Microsoft Visual Studio code-named "Whidbey" that will make development of data-driven Web applications easier and faster. These features include a better HTML source editor, better IntelliSense, improved data access support, and full XHTML standards support. Read here

Microsoft courting Google for possible takeover

Microsoft Corp. has reportedly approached Google Inc. about a potential buyout of the search technology company.

Google hasn't been rushing to take Microsoft up on the offer: Executives there seem to favor a public offering rather than an acquisition. Read more...

Generics in C#

I've been hearing a lot about Generics the past few months and how it's going to let us write less code and more robust code. I have looked at templates in C++ before but didn't quite get the hang of it. This article on FTPOnline gives a really good introduction.

Imagine that, now I can remove all the collections class that I've used in my data tier for each table and replace them with just a single Generic class.

I can't wait till next June for Whideby, give me .NET 2.0 now!!! 

ASP.NET 2.0

There are a lot of important things happening if you're a Microsoft developer. Two key technologies that you need to get on top are Indigo (for developing distributed systems) and Whideby (next release of the .NET Framework and Visual Studio® .NET development tools). Plus Longhorn (the next version of Windows) incorporates and builds on the .NET Framework.

Read more about them:

Whideby

Indigo

Longhorn