Learn MS .NET

During MIX09, the Web Platform Installer was mentioned in the first keynote on Wednesday, March 18. Some of the new features they mentioned were a new Web Application Gallery to install these on your server or local machine easily.

They also talked about some new extensions for IIS 7 as well.  Well they have many new features in this Beta.  I will go over them and I am testing it to see how it will do with installing some PHP applications as they are the hardest for me to get working properly on my Vista Laptop.

Web Platform Installer Download

Overview

The Microsoft Web Platform Installer 2.0 (Web PI) is a free tool that makes it simple to download, install and keep up-to-date with the latest components of the Microsoft Web Platform, including Internet Information Services (IIS), SQL Server Express, .NET Framework and Visual Web Developer. In addition, install popular open source ASP.NET and PHP web apps with the Web PI.

What’s New

• Administration Pack 1.0
• Advanced Logging 1.0 Beta
• Application Request Routing 2.0 Beta
• Database Manager 1.0 – RC
• Dynamic IP Restrictions 1.0 – Beta
• FTP Publishing Service 7.5
• IIS Media Services 3.0 Beta
• Windows PowerShell Snap-In 1.0
• Silverlight 3.0 Tools for Visual Studio Beta
• SQL Server 2008 Management Studio Express
• WebDAV 7.5
• Web Deployment Tool 1.0 – RC

Lots of new goodies to play with and as well as configuring Sql Server 2008, PHP and installing several web applications and configuring them for you.

Well off to play with it and see how it goes.

For anyone having trouble trying to find an SDK that they know Microsoft ships have a look at the following it may provide and answer for you in your search.

Microsoft SDKs

While working on my projects it becomes necessary sometimes to add a column to a table in SQL Server.  My brain goes fuzzy sometimes around SQL as I don't do a lot of hardcore programming in SQL.  Most of my SQL is limited to writing basic Select, Update, Insert and Delete procedures.  So I've determined that with my blog I'm going to put up some of the tips I find along the way to make my life easier and hopefully in the long run I will make someone else's easier as well

So here is how to check if a column exists in a SQL table:

   1:  IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS

   2:      WHERE TABLE_NAME = ‘TableName’ AND COLUMN_NAME = ‘TableColumnName’)

   3:      BEGIN

   4:          ALTER TABLE dbo.[TableName]

   5:          ADD [TableColumnName] [int] NULL

   6:      END

   7:  GO

It's not a complicated piece of code to do just takes some remembering or looking for.