Installing SQL Server Express 2008 on Windows Server 2003

December 20, 2009
James Skemp

SQL Server Express is an easy way to add Microsoft SQL Server to a Windows-based server. While limited in functionality, SQL Server Express is still a viable solution. In this article I'll be covering a custom install of SQL Server Express 2008 on Windows Server 2003. Server system For this install I was running Windows Server 2003 R2, Enterprise Edition, Service Pack 2 on Sun VirtualBox, with 256 MB of RAM.

December 6, 2009
James Skemp

Unfortunately, BlogEngine.NET doesn't currently have a very good way to determine, at a glance, all of the comments that haven't been approved. While this will certainly be coming in a future release, or as an extension, I figured writing something simple to do this would be a good LINQ to XML test for me. You can download the built executable, or play with the code, which is included below. Download the executable (7-Zip format).

November 19, 2009
James Skemp

I have a large collection of repositories, and until now ran a single batch file that had to be updated each time I created a new repository, to add the new directory. To combat that, I did some research and created a new batch file that does all the heavy lifting for me. To save others time, I present it below. SET timeVar=%date:~10,4%%date:~4,2%%date:~7,2% SET repoDumpDir=..\repos_dump FOR /D %%G IN (*) DO svnadmin dump %%G > %repoDumpDir%%%G%timeVar%.

October 25, 2009
James Skemp

I'd really like to implement membership providers in my Web applications, but just don't have the user-base that requires SQL Server (Express), nor the memory on my production server. Having looked at SQLite before, I figured it would be exactly what I'd need, without going to the alternative of XML. After some research I found Roger Martin's SQLite Membership, Role, and Profile Providers, and finally decided yesterday to implement these on a dummy MVC site.

October 24, 2009
James Skemp

The following goes through the steps needed to setup Windows Server 2003, with Web server capabilities (IIS 6 in this instance), on a Sun VirtualBox virtual machine. Why Windows Server 2003 when Server 2008 is out and available? Because a large number of hosts (mine included) haven't made the switch yet. Requirements Sun VirtualBox. We want this in particular for the great networking functionality, but other apps, like Microsoft Virtual PC, will work fine as well.

October 12, 2009
James Skemp

There aren't too many good gamer's games on the Nintendo Wii, so when Muramasa: The Demon Blade started getting advertised, I started getting really excited. Finally, a reason to dust off the Wii and play something other than Virtual Console games. With 108 blades available, Muramasa is also a completionist's dream. With the interest of making it a little easier to determine what weapons are available, I've crafted the following file, listing all the blades with their type, attack, secret arts, and effects, as well as which of the two character's trees it belongs to (those shared blades are noted as such, however some I still need to set).

September 12, 2009
James Skemp

Similar to my post on parsing Last.fm's artist.getSimilar, I've been working with Yahoo! Music's Web services today. Unfortunately, Yahoo!'s services aren't quite as friendly as those made available by Last.fm. So that I remember, and others don't have to tackle this as well, here's the class I've created. (Download JamesRSkemp.WebServices.YahooMusic.cs.) /* Created by James Skemp - http://jamesrskemp.com/ Version 1.0 More information at http://strivinglife.com/words/post/Parsing-Yahoo!-Musics-Artist-Web-Services-with-C-and-LINQ-to-XML-Search-for-artists.aspx Shared under a Creative Commons Attribution 3.0 United States License - http://creativecommons.

September 12, 2009
James Skemp

The following covers how to parse the XML response of artist.getSimilar, from Last.fm's Web Services. Setup and assumptions The first step is sign up for a free API account at Last.fm. You'll also need to target .NET Framework 3.5 when you setup your project, so as to access LINQ functionality. When writing the steps listed below, I was working on a Windows Forms Application, but the steps should be the same, or very similar, for other project types.

July 3, 2009
James Skemp

For a business to implement version control, they typically want some kind of support, preferrably that they need to pay for, and that may or may not be used, and that may or may not be helpful. Luckily, CollabNet offers certified binaries of Subversion, available for the low price of the time needed to register. Additionally, they offer support, training, installation, and hosted solutions, in addition to the large Subversion community. Compared to the other solutions out there, including Microsoft's, there's really no question on what your first choice should be.

July 2, 2009
James Skemp

Having just upgraded to VirtualBox 3.0.0, I was running into an issue with being able to access a Windows Server 2003 guest from my Windows Vista host machine. By default, when creating a Windows Server 2003 guest machine the Network settings are set such that Adapter 1 is PCnet-FAST III, attached to NAT. This allows the virtual machine to get outside, but not in. However, it's possible to add a second adapter, attached to the host-only adapter.

Newer

Older

Search

Links of Note

Support This Site

If my blog was helpful to you, then please consider visiting my Amazon Wishlist.

Installing SQL Server Express 2008 on Windows Server 2003

Determine BlogEngine.NET comments that haven't been published

Example batch file to dump Subversion repositories

Using SQLite as a membership, profile, and role provider in ASP.NET MVC

Steps to setting up a Windows Server 2003 Web Server on VirtualBox

Muramasa: The Demon Blade - Complete weapon listing

Parsing Yahoo! Music's Artist Web Services with C# and LINQ to XML - Search for artists

Parsing Last.fm Web Services' artist.getSimilar with C# and LINQ to XML

Installing CollabNet Subversion Server 1.6.3 and TortoiseSVN 1.6.3 on Windows Server 2003

Multiple network adapters in VirtualBox, for Windows guests

Search

Links of Note

Recent Posts

categories

Support This Site