Profiling .NET managed Services using VS 2010

In order to profile/analyze .NET managed services, make sure to run VSPerfCLREnv /globalsampleon from the command line.

VSPerfCLREnv can be found under:
C:\Program Files\Microsoft Visual Studio 10.0\Team Tools\Performance Tools

More details here.

Note that profiling is not available for all VS releases. I had to get a VS 2010 Premium just for that. It is also available for the TEAM editions.

Happy Profiling!

Two Free MS downloads

XML Notepad 2007

Microsoft Network Monitor

Sketch Path

Sketch Path, a handy XPath tool

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?

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 !

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 

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