Sunday, November 1, 2009

Two Free MS downloads

XML Notepad 2007


Microsoft Network Monitor

Monday, August 31, 2009

Sketch Path

Sketch Path, a handy XPath tool

Sunday, July 26, 2009

Adding Scripting to a .NET app

Iron Python is a good option.
How to embed IronPython script support in your existing app in 10 easy steps?

Saturday, June 6, 2009

Palm Pre




The amazing Palm Pre; the picture says it all a QWERTY Keyboard & a 3.1" display.
More like they put all the good from a Nokia E71 and an iPhone !

Thursday, June 4, 2009

The Perfect Solution for quering hierarical data

Recursive Queries Using Common Table Expressions

WITH cte_name ( column_name [,...n] )

AS

(

CTE_query_definition –- Anchor member is defined.

UNION ALL

CTE_query_definition –- Recursive member is defined referencing cte_name.

)

-- Statement using the CTE

SELECT *

FROM cte_name

Wednesday, June 3, 2009

SQL Server CLR Functions

SQL Server CLR Functions is simply put, mixing SQL & .NET (Can life be any better?)

To enable CLR:

exec sp_configure 'clr enabled', 1
reconfigure


References:

How to create a SQL Server Project?

How to create and run a CLR SQL Server User-Defined Function?

How to deploy SQL Server Project Items to a SQL Server?

Example

Friday, March 13, 2009

BBC Botnet experiment



More details here and here