SQL Server with Mr. Denny

January 9, 2009  1:05 AM

I was bouncing around the net, and found Wordle.net

Denny Cherry Denny Cherry Profile: Denny Cherry

Wordle.net creates word maps of all the words on a website.  So I fed it my blog and came up with this.

I thought it was kind of cool, so I posted it up here.  Try out our site and see what it does.

In the true spirit of twitter I’ll pick on a couple of people to generate there own and post them (as soon as twitter comes back up, it’s DOA at the moment).

Denis Gobo, and Michelle Ufford you’ve been tagged


January 8, 2009  10:10 PM

My Windows 7 Install Experience

Denny Cherry Denny Cherry Profile: Denny Cherry

Those of us with MSDN or TechNet accounts got access to the new Windows 7 build last night.  So I had my work PC spend the night downloading it, and spent this afternoon installing it today under VMware ESX.  I’ve recorded the install for posterity.  I paused the recording during the borring parts like waiting for the files to expand. Continued »

January 8, 2009  12:00 AM

Do your servers take for ever to reboot?

Denny Cherry Denny Cherry Profile: Denny Cherry

One company I worked at the newer SQL Servers started taking forever to reboot the OS. The older servers didn’t take all that long. It finely dawned on us one day what it was.

Continued »

January 7, 2009  11:27 PM

Installing SQL Server 2005 SP3 or SQL Server 2008 on XP Prep SP3 can cause Bug Check

Denny Cherry Denny Cherry Profile: Denny Cherry

The SQL Server CSS team has just posted a blog post saying that it you install SQL Server 2005 SP3 or SQL Server 2008 on a Windows XP Machine which is pre SP 3 you can get a Bug Check (Blue Screen).

If you are running Windows XP I highly recommend that you read this before installing SQL 2005 SP3 or SQL 2008 on your machine.


January 4, 2009  9:15 PM

JournalSpace.com Says the site was trashed by the IT guy

Denny Cherry Denny Cherry Profile: Denny Cherry

The owner of JournalSpace.com has posted an update to the site (screen shot for posterity) giving more information about what happened.

Apparently the IT guy who liked to tell people how smart he was decided to rely on RAID as a backup for the database, but had automated backups of the web servers.  He was apparently caught steeling from the company and wiped out the SQL database on his way out the door.

Apparently my suspicions were correct and it wasn’t a system problem, but a person who deleted the data.

Andrew Hart posted a note on how some of the users are able to get there data back using the Google cache.  I tried using the Internet Wayback Machine but apparently JournalSpace.com was set to not allow it to be archived.

I would recommend to the owner of the site that the contact the local police department and file a report.  While company employees can’t be held liable for stupidity, intentionally destroying the company we can be held liable for.

Denis Gobo posted an update as well, as I’m sure others did as well.


UPDATE: I forgot to include that I’m following the JournalSpace.com user on twitter so that I can keep abreast of new updates.

SECOND UPDATE: My horrible spelling was pointed out to me, so I’ve corrected this. Apparently Firefox didn’t pickup the spelling problems the first time around.

January 2, 2009  8:46 PM

Mirroring isn’t a backup solution

Denny Cherry Denny Cherry Profile: Denny Cherry

In case you live under a rock and haven’t heard about Journalspace.com‘s little mistake, they have gone out of business due to a database problem.  Here’s a screenshot in case the site is down when you look at it.

In a nutshell it appears that they were relying on a RAID1 array as the database backup.  While we see this all the time in small database shops as noted on /. this site has been up since 2002 and had an Alexa page rank of 106,881 with 14k monthly visitors (according to Quantcast).  For a site so large to be making such a simple mistake is just unacceptable. Continued »

January 2, 2009  8:56 AM

SQL Server virtualization pros and cons: Weigh the performance impact

Denny Cherry Denny Cherry Profile: Denny Cherry

It’s been a while since I’ve posted about new articles that I’ve published.  Over the next few weeks I’m going to see if I can’t remedy that, and get all caught up.

Over on SearchSQLServer.com I posted an article entitled “SQL Server virtualization pros and cons: Weigh the performance impact“.

Continued »

January 2, 2009  7:12 AM

Standalone SQL Agent Project Kickoff Announement

Denny Cherry Denny Cherry Profile: Denny Cherry

If you have used SQL Server 2005 Express Edition (or SQL Server 2008 Express Edition) then you know that the SQL Agent has been removed from the product.  I have from time to time found this to be annoying as I want to do things like backup my database on a regular basis, or do other basic things.  The normal solution is to either use another SQL Server to do the scheduling, or use the Windows Task Scheduler to do the scheduling. Continued »

December 31, 2008  11:00 AM

Happy New Year!!

Denny Cherry Denny Cherry Profile: Denny Cherry

Have a happy New Year. Go spend the night with family.

That’s what I’m doing tonight.


December 30, 2008  7:39 PM

New Years Resolutions for 2009

Denny Cherry Denny Cherry Profile: Denny Cherry

I’ve been tagged by Denis Gobo for a New Years Resolution post.  I’ve only got a couple of things to put, since I’m not a big fan of New Years resolutions.

Upgrade our production systems to SQL Server 2008
I’ve been speaking about SQL Server 2008 since before it was released.  It would probably be nice if I actually upgraded our production systems at the office.  It’s just a matter of time to actually get it done.

Get started writing a SQL book of my own
In 2008 I wrote a few chapters for a couple of books for other people.  In 2009 I’ll attempt to write my own.

I’ll tag Jason Massie and Tom Larock.


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: