Installing IIS 7 on Windows Vista

Brett Hill presents an excellent introduction to installing the next version of IIS onto Windows Vista on the MSDN Channel 9 website. The following link will take you directly to this streaming video.

Installing IIS 7 on Vista

More information regarding IIS 7.0 can be found also at the following Url which also contains links to the latest MSDN Show which is dedicated to discussing IIS 7.0

Windows Vista Build 5472

Microsoft today released build 5472 to beta testers, it is unclear however at this moment if build 5472 will be made more widely available than its predecessor build 5456 which never made it onto the MSDN subscriber downloads website.

Also released today were associated builds of the Windows SDK which will contain pre-release versions of the Microsoft .NET Framework 3.0, it is also unclear however if the builds of the .NET Framework have changed between these two interim Vista releases. I’ll try and establish an answer to this sometime tomorrow once I’ve completed downloading the near 10Gb required for the x86 and x64 distributions along with the SDK download.

Hopefully build 5472 will include updated device drivers for the NVIDIA GeForce Go 7800, although we’ll see tomorrow.

Updated July 17, 11:15pm PST: According to Mary Jo Foley of Microsoft-Watch, MSDN subscribers can expect to have access to build 5472 within the next few days.

Updated July 18, 11:36am PST: Windows Vista Build 5472 installed onto my 32-bit based Dell Inspiron 9400 and the NVIDIA GeForce Go 7800 is now supported with Aero Glass 🙂

Here are two screen captures showing Aero Glass support working now for the NVIDIA GeForce Go 7800, and a second capture showing the version information and system rating.

SQL Server 2005 T-SQL Recipies

Some time ago I came across an excellent reference for SQL Server 2005 T-SQL with the book SQL Server 2005 T-SQL Recipies by Joseph Sack. Within the book you’ll find recipies for every possible area of T-SQL as it ships with SQL Server 2005, ranging from basic querying constructs to the use of the CLR integration features and the Service Broker. The chapter on the new encryption features within SQL Server 2005 saved us many hours while we were enhancing the security features for an e-government project that we’re actively working on.

As someone who spends most of his time working with the C# language, and has often thought I should learn more about the T-SQL language, this book provides me an excellent resource for those moments when I find myself writing some more complex T-SQL such as that involved with the encryption and decryption of data using the database master and service master keys.

If you’re either a developer or DBA using SQL Server 2005 I would really recommend that you get a copy of this book in either hard copy or PDF.