Braving Fay

by KodefuGuru 28. August 2008 16:45

I was surprised to hear that the Jacksonville Code Camp wasn't cancelled. A major tropical storm was coming through the area at the time, but the organizers for the Code Camp weren't going to let that stop them. I decided if they were brave enough to hold a conference during a tropical storm, I should be brave enough to drive into it. Just not in my rag top; we took my wife's car.

Friday, my wife and I packed our bags and headed out the door. We were picking Lou Vega up from Charleston, and it was going to take 6 hours total with that detour. We hit the largest storm immediately outside of Columbia. Life is so ironic. The worst we encountered from Fay were strong winds. It's not fun when you're inches away from a concrete barrier and you can feel the wind pushing your car to and fro.

We were quite lucky that the storm had cleared the streets. A certain direction web site changed E Coastline Dr to Line St. This caused us to end up in a very unsavory part of town. Once we determined that there wasn't a Hyatt Regency between what appeared to be crack houses, we called the hotel to get directions. The most eventful part of the evening was when Lou wrestled an alligator driven from its habitat by the storm... but that's a story for another day.

The Code Camp went very well considering the circumstances. The location was moved to a different part of town, but we didn't have trouble finding it due to my spidey senses. It felt kind of odd giving a presentation from the back of a room, but all was well in the end. I was able to meet up with some old friends, Scott Dorman and Russ Fustino, and made a few more. Later that night we went back to the Regency for the after-party. One benefit of the reduced attendance was the proliferation of blue tickets. It ended up being like a pub club with better food and a nice view of the river.

If you haven't made it to a Code Camp before, I recommend you try it out. It gives you a chance to learn, win books and software, and hang out with other members of the development community. The best part is they're always on the weekend, so it will not interfere with your regular work schedule.

Tags:

Presentation

MSDN Event in Columbia

by KodefuGuru 20. August 2008 23:55
Tomorrow, Russ Fustino will be speaking at an MSDN event in Columbia. It's the only MSDN event in South Carolina this quarter. So, if you're around tomorrow be sure to attend!

Tags: ,

Presentation

Create Vista Icons in VS 2008

by KodefuGuru 8. August 2008 17:00

Axialis has released a free add-in for VS 2008 that creates the 256x256 icons used in Vista. Download IconWorkshop™ Lite and free yourself from the 32x32 bit tyranny!

 

 

Here's the download page:

http://www.axialis.com/download/iwlite.html

Tags: , , ,

Zen

String to Stream

by KodefuGuru 7. August 2008 17:31

Sometimes a string isn't enough, you need a stream. Unfortunately, there isn't a direct method to stick a string into a stream. But we are saved! MemoryStream will take bytes... here's how to convert your string into a series of bytes so you can get that all important StringStream. No, I'm not going to make a StringStream class though you certainly can fulfill your masochistic class explosion desires.

String request = "I can has cheezburger?";

MemoryStream stream = new MemoryStream(Encoding.Unicode.GetBytes(request));

 

Tags: ,

Techniques

Hung Database Restore

by KodefuGuru 4. August 2008 18:08

When doing a deployment today, the build script errored out with a SQL timeout.

C:\Projects\MyProject.proj (2374,3): error: PROJDB: Error # -2 on Line 0: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The line in the msbuild script was executing a backup/restore script to refresh the database for one of our teams. I decided to change the StatementTimeout for the ExecuteDDL task and try again. This time I received another error.

C:\Projects\MyProject.proj (2374,3): error: PROJDB: Error # 4060 on Line 65536: Cannot open database "PROJDB" requested by the login. The login failed.
C:\Projects\MyProject.proj (2374,3): error: PROJDB: Error # 18456 on Line 65536: Login failed for user 'DOMAIN\BuildUser'.

Why would my database login be messed up? I jumped onto the database server through Management Studio and discovered that the database was stuck in the Restore state. I waited for a while to see if it would go away, but it became clear that it was hung. I googled around to see what needed to be done to fix it. Someone suggested that running the following command would take it out of that state: RESTORE DATABASE <dbname> WITH RECOVERY. It didn't. Instead, I received an error that you can't alter the database while it is being restored.

I finally solved the problem by deleting the database, adding a new database with the same name back, then running the restore script.

Tags: ,

General

Powered by BlogEngine.NET 1.6.0.0
Theme by Mads Kristensen

Whois KodefuGuru

Chris Eargle

Chris Eargle
.NET Community Champion

LinkedIn Twitter Technorati Facebook

MVP - Visual C#

 

INETA Community Champions
Friend of RedGate
Telerik .NET Ninja
Community blogs & blog posts

I am a #52er


World Map

RecentComments

Comment RSS

Tag cloud

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2010