October 2008 Blog Posts
I upgraded SQL on my laptop and during the process managed to 'lose' my database…. Total n00b move. I couldn't recover the database file (it was over a gig and was quickly written over). Determined not to recreate the work since the last backup, I kept searching for a solution. Then it hit me; pull the database from the data context (dbml) I created with SQLMETAL. Simply call CreateDatabase(), and 'bam' database recovered. Whew!!!
If you use LINQ, check this out, it's definitely worth the time. You can execute LINQ statements at the break point.
"One of the nice development features that LINQ to SQL supports is the ability to use a "debug visualizer" to hover over a LINQ expression while in the VS 2008 debugger and inspect the raw SQL that the ORM will ultimately execute at runtime when evaluating the LINQ query expression."
Running programs remotely through ssh is great with Linux or Mac OS X with the –X flag. Not quite as easy with Windows. I lean on PUTTY for my ssh, which of course does not come with an X Server. Xming will piggy back with Putty to run an X Server on windows and allow you to remote the application with the –X flag. The application has worked great for running GUIs off the HPC through ssh.
"Xming is the leading free unlimited X Window server for Microsoft Windows (XP/2003/Vista). It is fully featured, small and fast,...
Matlab may be used to solve differential equations symbolically as well as numerically. Well, actually Maple is being used behind the scenes. This can be seen whenever an error occurs with the solver 'Error using ==> maple at 129'. Regardless, say you wanted to solve for a spring mass damper system under a forced oscillation:
The solution is lots of fun to do by hand, but faster and easier in Matlab using dsolve. Dsolve calls Maple to symbolically solve the system. The solver can solve for a single equation with boundary conditions or for systems of...
For $6.99 a year you can have your own mail domain. Something like email@example.com. The route I chose was to go with http://www.1and1.com to order the domain name. I then use Google Apps' Standard Edition to host the mail (http://www.google.com/apps/intl/en/business/editions.html). The process is fairly straightforward. After registering for the Google app just apply the mail records from Google into the mail records for the domain on 1and1. That's all there is too it, and in a few days your mail will up and running.
An overview of Visual Studio 2010 and .NET 4.0 was posted on MSDN. Now, where to apply for the beta…
Visual Studio 2010 and .NET Framework 4.0 Overviewhttp://msdn.microsoft.com/en-us/vstudio/products/cc948977.aspx
I found a great post on how to add Regular Expression functions to SQL Server through CLR functions and extended the methods slightly. The functions allow queries such as the one below to be performed. I was concerned with performance initially, but a few tests and I am blown away by the speed. The original post can be found here, http://anastasiosyal.com/archive/2008/07/05/regular-expressions-in-ms-sql-server-using-clr.aspx, and my modified code below.
'(\w+\d+)') match from aspnet_Users where dbo.RegExMatch(UserName,
The query above will return usernames from the aspnet_users table that start with words and are followed by numbers (Such as ccook123, but not...