How to Move the Default Databases for MS SQL Server

I have juss finshed the painful task of moving of moving all the default databases (Master.mdf etc) from program files to more useful places on the database server. I wrote my self a little guide in google docs and thought someone else might like to use it. Here is the guide.

New Nine Inch Nails - Ghosts

There is a new Nine Inch Nails CD and it is only available online so what are you waiting for go and buy it I did, here is a bit of info from the site.

Nine Inch Nails presents Ghosts I - IV, a brand new 36 track instrumental collection available right now. Almost two hours of new music composed and recorded over an intense ten week period last fall, Ghosts I - IV sprawls Nine Inch Nails across a variety of new terrain.

Oh and just in case you don't believe me
You can get it for free but thats not really right it is?

Get Your Smashing Pumpkins Tickets Now

Come on Wellington anyone who likes good music(that is anything I listen to) who hasn't got tickets to the Pumpkins and Queens of the Stoneage is part of the problem, that is why we don't get to see any good bands here. Damn it Timberlake should out in like 30 minutes why hasn't the Pumpkins sold out.
Go and buy your tickets now it will be great, it will be the best concert to come to Wellington had since Tool.

WebBrowser Control Loading Hack

I was having a problem with the where I was trying to set some a the DocumentText on the load of my windows from but that browser control was not intilizied correctly and would not load the DocumentText. It took me a while but I worked out a way around it. Here is how I did it:

1. I created a class variable called WebControlFirstLoad and set it to true.
2. I set the DocumentCompleted event for the browser control to:

   if (!this.WebControlFirstLoad) return;
   this.WebControlFirstLoad = false
   [...load page code here...]

Now it all works fine.

Regular Expression Designer

I don't know about you but I'm not a big fan of the trial and error when dealing with regular expressions luckily today I managed to find a tool to help out.

Wires from the Sky

Wires from the Sky
Originally uploaded by Korich

On my way to work there was a large pile of wires and tubing in the middle of the road, they where damp so they have been there during the night. I asked the people who worked in the workshop below where we live if they knew where they where from but no one did.

Do you have any where they came from?

Sorry about the picture i took it using my crappy cellphone, and when I got home someone have tided it up.

Using a custom database for ASP.NET Membership

I needed to use a custom database for my membership and roles in an ASP.NET service it took me a little while to sort out in the web.config so I thought that I would post my web.config here just in case anyone wants to copy it. just replace the words in square brackets with the correct values.

<?xml version="1.0"?>
<configuration >

 <appSettings/ >
 <connectionStrings >
  <add  name="ApplicationConnectionString"
   connectionString="[ConnectionString]"
           providerName="System.Data.SqlClient" / >
  <add name="MembershipConnectionString"
  connectionString="[ConnectionString]"
  providerName="System.Data.SqlClient" / >
 </connectionStrings >

 <system.web >

  <compilation debug="true" / >

  <authentication mode="Forms" / >

  <membership defaultProvider="SqlMembershipProvider"  >
   <providers >
    <clear / >
    <add name="SqlMembershipProvider"
     connectionStringName="MembershipConnectionString"
    applicationName="AssetManagement"
    type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" / >
   </providers >
  </membership >
  <roleManager enabled="true" >
   <providers >
    <clear / >
    <add connectionStringName="MembershipConnectionString"
    applicationName="AssetManagement"
    name="AspNetSqlRoleProvider"
    type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" / >
   </providers >
  </roleManager >
 </system.web >
</configuration >

Oh and to add the tables you need to your database use the following command from the command line replacing the words in square brackets with the correct values;

C:\WINDOWS\Microsoft.NET\Framework\[Framework]\aspnet_regsql.exe –E -S [Server] -d [DatabaseName] -A mr

Here is some more info on aspnet_regsql.exe.