Monthly Archive: November 2009

Nov
16

Google Waves “Hello World”

Is Google changing the meaning of the term “waving” with their upcoming collaborative service, Google Wave? A lot of buzz has been generated about this upcoming service, currently in a limited test phase of development.

Currently a lof of features are still on the design board, and more soon to be implemented. Meanwhile, Google is steadily sending out more invites to people who signed up to test the service while in development. I have just received access myself, and invited some friends to join me.

Here’s an official video that attempts to explain more about waving and what this service will attempt to accomplish for people:

Nov
06

How To: Edit Query Data Directly In MS SQL 2005 & 2008

SQL 2008 Server Box Shot

Still accepting direct injection fuel

In MS SQL 2000 Management Studio it was possible to directly edit data when performing a query by using the “Open Table -> Query” menu option on a table. Microsoft changed things around for SQL 2005 & 2008, so that menu option is gone, but it can still be done. Here’s how to do it:

An effective way to do this is to first create an empty table AnEmptyTable that is easy to find at the top in Object Explorer.

Right-click your newly created table and click “Open Table”. As it is empty, this is much faster than opening any other table. At the top is a little button in the upper left which says “SQL” and a tooltip that says “Show SQL Pane”. Enable them both and voila! You can now run queries at the top and edit the results below.

Know a better way? Post comment please.