Installing Ms SQL Server 2005 Express SP3

As you may know, SQL Server Express edition is free for personal use or being included as part of your distribution. But, if your requirement is simple, then you can try out this express edition.

There are a few features that are separated into a few packages.

The latest version of the installation packages are in SP3. If you are installing the non SP3 version, the system will prompt you that there is a newer version that is available, or known issues are there.

So, the easiest way is to install the SP3 version directly.

SQL Server 2005 Express SP3 with Advanced Features included:
Database, Reporting Services, Client Management Tool.

SQL Server 2005 Express SP3 Toolkit included:
BI Development Tool and Client Management Tool. The only difference in this package is the BI Development tool. If you need to create SSIS (SQL Server Integration Services) package, or reports on using the SSRS (SQL Server Reporting Services), you need this tool.

Visual C# 2008 Express and Ms SQL Server 2005 Express

I have been playing around with Visual C# 2008 Express, ASP.NET and Ms SQL Server 2005 Express edition for a few months lately ... just for the sake of gaining back some interests and good memories of programming ... :)

Basically, for those who likes programming can download the .NET Framework 3.5 free and you can also download the IDE (Integrated Development Environment) such as Visual C# 2008 Express and Visual Studio 2008 Express for web development free too. Another interesting thing is you can even download and install Ms SQL Server 2005 express edition free too! But, after you install the Ms SQL 2005 express edition, you need to also download the SQL Server Management Studio client for the UI-based creation of database and stored procedures.

However, when you get real with product development then you can buy the necessary licenses for proper support and additional things you need.

For further information, try this :)