I get some Web apps in compressed zip files. While its easy to unzip and map it to my local IIS server, its still a very doll job to do over and over again. So I was searching the web and came across ASP.NET 4 Web Server Here Shell Extension by Phil Haack.

A very simple shell extension starting the Cassini webserver on the selected folder:

And then just point you favorite browser at: http://localhost:8081/ or what ever port you used in the reg file.

I have attached both reg files for 32 & 64 bit.

32bit

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Directory\shell\VS2010 WebServer]
@="ASP.NET 4 Web Server Here"
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Directory\shell\VS2010 WebServer\command]
@="C:\\Program Files\\Common Files\\microsoft shared\\DevServer\\10.0\\Webdev.WebServer40.exe /port:8081 /path:\"%1\""

64bit

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Directory\shell\VS2010 WebServer]
@="ASP.NET 4 Web Server Here"
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Directory\shell\VS2010 WebServer\command]
@="C:\\Program Files (x86)\\Common Files\\microsoft shared\\DevServer\\10.0\\Webdev.WebServer40.exe /port:8081 /path:\"%1\""

Yes, the Formating is very bad, so to avoid any copy/paste errors, download the attached zip file.

Regs.zip (758.00 bytes)

So, the other day I was reading T-SQL: Why “It Depends” and in the comments section a guys suggested using the “PARTITION BY” in the OVER clause.

I thought was the heck does that do … so i searched the web for an answer … and wow … what a great way to find duplicate post … and possible also a lot of other things it can be used for that I haven’t thought about.

To the code …

WITH Data AS
(
	SELECT 
	ROW_NUMBER() OVER ( PARTITION BY CID ORDER BY Added DESC) AS DupeNumber
	,CID, Added
FROM Servers
)
SELECT * FROM Data Where DupeNumber >= 2

This will check for dupes on the CID column … and then select all the rows where DupeNumber is over or equal to 2. You could then instead of select it … you could delete it.

Fancy way … I like it.

So the other day I was talking to my fellow MSP’s(Microsoft Student Partner) if some of of was using VS 2010. Most of us had tried the beta but not really used it cause it still had a slow UI, which should be fixed in the next release, BETA2.

So while writing this, I also began the installation of: Visual Studio 2010 Ultimate Beta 2 Web Installer (x86) - (English). Instead of downloading the normal ISO image, I would try the Web Installer this time. More on that later how it went.

I will later write something about the new features as I start using Vs 2010. For now just take a look at this link: Visual Studio 2010 and .NET Framework 4 Beta 2 Walkthroughs