Inspired by Harry's post, I made an expanded version of find-to-set-alias suitable to putting into a script (.ps1) file, which includes warnings and diagnostic information, with an optional -quiet switch (more useful for your profile to automatically find and alias things, when you expect that they might not be there).
Source: find-to-set-alias.ps1
param(
$foldersearch = $(throw "foldersearch required"),
$filename = $(throw "filename required"),
$alias = $(throw "alias required"),
[switch]$quiet
)
if ((test-path $foldersearch) -eq $false) {
if ($quiet -eq $false) { write-warning ("Could not find any paths to match " + $foldersearch) }
exit
}
# If the user specified a wildcard, turn the foldersearch into an array of matching items
# We don't always want to do this, because specifying a non-wildcard directory gives false positives
if ($foldersearch.contains('*') -or $foldersearch.contains('?')) {
$foldersearch = Get-ChildItem $foldersearch -ErrorAction SilentlyContinue
}
$files = @($foldersearch | %{ Get-ChildItem $_ -Recurse -Filter $filename -ErrorAction SilentlyContinue })
if ($files -eq $null) {
if ($quiet -eq $false) {
write-warning ("Could not find " + $filename + " in searched paths:")
$foldersearch | %{ write-warning (" " + $_) }
}
exit
}
set-alias $alias $files[0].FullName -scope Global
if ($quiet -eq $false) {
write-host ("Added alias " + $alias + " for " + $files[0].FullName)
if ($files.count -gt 1) {
write-warning ("There were " + $files.count + " matches:")
$files | %{ write-warning (" " + $_.FullName) }
}
}
If you use ASP.NET's App_Data directory, chances are good you're using SQL Server Express and the User Instances feature. When you try to profile the default instance (usually ".\SQLEXPRESS"), you'll discover that your user instance databases don't show up in the database list and cannot be profiled. The reason is because user instance databases get their own instance of SQL Server.
To profile a user instance, you need to discover what the named pipe of the connection is. You can find it by running a query against the default instance:
SELECT owning_principal_name,instance_pipe_name FROM sys.dm_os_child_instances
Locate the user in question (if you're running in the Web Server built into Visual Studio, it will be your local user account; if you're running inside of IIS, it will be whatever user you have the app pool configured to run as). Copy the instance_pipe_name value and use that as your server name for SQL Profiler:
Once you're connected, you will be able to trace the SQL for your user instance databases.
Note: You can also use that same "server name" with SQL Server Management Studio if you need to perform ad-hoc SQL queries against the user instance.
This was another great year for new rock & metal music, just like 2007. I'm not sure if it's my tastes this year, or just the way schedules worked out, but almost everything on the list this year is really on the heavy side of rock (there is no analogue to Foo Fighters to hop into the mix this time around). A couple bands are missing because they have no videos (I'm looking at you, Ayreon) or the song they chose to make a video for is so mediocre (I'm looking at you, Metallica).
Happy New Year!
Note: If the video says "This video is no longer available" when you attempt to play it, that means it probably timed out with YouTube. Try refreshing this page and then playing the video again, or click through to the YouTube page directly using the up-arrow button in the bottom right corner of the video.
Opeth - Porcelain Heart
It took a while to realize it, but this album is the best of their career, eclipsing Blackwater Park. It's a masterwork of their combination of beautiful, acoustic harmonizing style and their brutal dark style.
Scar Symmetry - Morphogenesis
Four album in three years, Scar Symmetry are definitely one of my most favorite (and most productive) melodic death metal bands. Their vocal and musical hooks are gigantic, making me want to listen to their albums over and over again.
Trivium - Down From the Sky
What can I say? Trivium is probably my favorite thrash band right now, and this song really captures their style well. I wish I'd been able to find a higher quality video...
The Human Abstract - Procession of the Fates
This was my favorite new discovery of the year; they have a very experimental prog rock sound and the video is very interesting (and very well done for a relatively obscure band).
Protest the Hero - Sequoia Throne
You thought The Mars Volta were a little odd? These guys are like the insane little cousin to Mars Volta's normality.
In Flames - Alias
I'm glad they chose this as the 2nd single for the album, because it is hands down the best on the disc. The hooks through the chorus are so big you could hang buffalo on them.
Testament - More Than Meets the Eye
They went 9 years without a new album, and it was well worth the wait. The new album effortlessly blends the heavy driving style of The Gathering with the melodic style of Practice What You Preach.
Meshuggah - Bleed
The drummer for Meshuggah is well known as being part drumming-robot, and this was the song that really caught people's attention for his style. Be warned that the video is kind of disturbing.
Evergrey - Broken Wings
These guys are one of the most under-appreciated metal bands... they put out album after album with just stellar material but I rarely see them get mentioned (maybe because nobody growls).
Disturbed - Indestructable
The second video from their new album is for the war anthem "Indestructable", definitely one of my favorite songs on the disc. I find myself thrashing along in the car whenever it's in the rotation.
Slipknot - Psychosocial
I'd never listened to Slipknot before I saw this video on Headbanger's Ball a couple weeks before the album's release. I always thought them to be a bit gimmicky, but this song really kicks ass.
DevilDriver - Clouds over California
I ended up watching this one because of the interesting video, and when I listened to the whole album with my Zune Pass, decided it was a keeper. (And, no, the kids aren't the band.)
