SQL Server with Mr. Denny:

May, 2009


May 28, 2009  11:00 AM

What’s the difference between encrypted data and hashed data?

Denny Cherry Denny Cherry Profile: Denny Cherry

The biggest difference between encrypted data and hashed data is that encrypted data can be decrypted later.  Hash algorithms such as MD5 are one way hashing algorithms which means that the value that is returned can't be decrypted back to the original value. It is important to know the...

May 27, 2009  2:00 PM

ServerFault.com goes live

Denny Cherry Denny Cherry Profile: Denny Cherry

This week ServerFault.com has transissioned from Beta to fully live.  This means that you no longer need to have the beta access code to access the site. Hopefully you find the site as useful as I have while it was in beta. Denny


May 25, 2009  11:00 AM

VMware and SQL and Lock Pages in Memory

Denny Cherry Denny Cherry Profile: Denny Cherry

With the recent release of the ability for the Lock Pages in Memory setting to be used on SQL Server 2005 and 2008 Standard Edition I see more and more people shooting them selves in the foot with this setting when running under VMware.  I see this as becoming more of an issue now that this switch...


May 20, 2009  1:32 PM

I’m drunk with power at ServerFault.com

Denny Cherry Denny Cherry Profile: Denny Cherry

As of Monday it's official, that I'm now one of the two moderators over at ServerFault.com.  From what I understand this means I basically go through the list of posts that people have tagged as not being relevant to he site and remove them,...


May 20, 2009  12:16 AM

#emcworld Day 2 In Review

Denny Cherry Denny Cherry Profile: Denny Cherry

Today was day 2 of EMC World 2009.  There were some great sessions today.  I'm focused on two tracks this year, VMware and the CLARiiON product as we have just deployed both of these in our Bookmark and Share     1 Comment     RSS Feed     Email a friend


May 19, 2009  5:24 AM

Got Pics from EMC World Day 0 posted

Denny Cherry Denny Cherry Profile: Denny Cherry

Thanks to my wife Kris reminding me that the SD card in my camera will also fit in my blackberry I've gotten the photo's uploaded to flickr. Denny


May 18, 2009  1:28 PM

EMC World Day 0 In Review

Denny Cherry Denny Cherry Profile: Denny Cherry

This morning is Day 1 of EMC World, so it's a perfect time to review yesterday. Day 0 is all about getting to the show, and getting checked in.  And of course the party. The food was pretty good, as was the beer.  The band sounded ok, but the sound guy wasn't all that great. I'll be...


May 16, 2009  7:16 PM

#EMCWorld 2009 is starting tomorrow, and I’m on my way

Denny Cherry Denny Cherry Profile: Denny Cherry

Well tomorrow begins my annual trek to EMC World.  This year I'm headed back to Orlando as EMC World is being held at the Orange County Convention Center.  As I've done the last couple of years I'll post as often as I can during the conference both on here on my blog, as well as on


May 14, 2009  11:00 AM

Outside Queue to SSB adapter

Denny Cherry Denny Cherry Profile: Denny Cherry

Something that I think that Microsoft should include with the SQL Service Broker is an adapter so that MSMQ messages (and other messaging systems as well) will flow automatically into the SQL Service Broker.  Since Microsoft hasn't gotten around to writing one I'm going to start. It shouldn't...


May 11, 2009  11:00 AM

How do I change from push to pull subscriptions in SQL Replication?

Denny Cherry Denny Cherry Profile: Denny Cherry

The official answer is to delete the subscriber and recreate it pushing a new snapshot to the subscriber. The much quicker and easier method is as follows. 1. Stop the distribution agent on the machine that it's currently running on. 2. Disable the SQL Agent job that runs the distribution...


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: