June 15, 2009  11:00 AM

PASS 2009 here I come



Posted by: Denny Cherry
In Person Events, PASS, Storage

The people at the PASS 2009 have made the ultimate mistake.  They've decided to allow me to come and speak at the PASS 2009 Summit this November. Continued »


June 1, 2009  1:00 PM

Clean up the backup history



Posted by: Denny Cherry
Backup & recovery, Database Administration, sp_delete_backuphistory

Something that most people don't release needs a little TLC in SQL Server is the backup history. Every time a database is backed up records are written about it.  Over time this can add up to a lot of useless data floating around the SQL Server in the msdb database. If you like to use the UI...


May 20, 2009  12:16 AM

#emcworld Day 2 In Review



Posted by: Denny Cherry
EMC World, EMC World 2009, Storage Vmotion, VMware

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



Posted by: Denny Cherry
EMC World, EMC World 2009

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



Posted by: Denny Cherry
EMC World, EMC World 2009

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



Posted by: Denny Cherry
CLARiiON, EMC, EMC World, EMC World 2009, Twitter

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 11, 2009  11:00 AM

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



Posted by: Denny Cherry
distrib.exe, Replication, SQL Server 2000, SQL Server 2005, SQL Server 2008

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...


May 7, 2009  11:00 AM

Pull vs. Push Subscriptions? Which one should you use?



Posted by: Denny Cherry
Replication, SQL Server 2000, SQL Server 2005, SQL Server 2008

This is a "it depends" sort of question. These are my recommendations, your mileage may vary. Your distributor is on the same system as your publisher - Pull is probably for you Your Subscribers are a very high transaction count - Push is probably for you You need to manually copy the...


April 13, 2009  11:00 AM

Datacenter Migration In Progress



Posted by: Denny Cherry
Data Center Build, EMC, SQL Server, VMware

For those of you who know me, or have heard me talk at a Code Camp in the last year, you've heard me talk about a data center migration that I want to do from Rackspace in Texas to our own equipment in the LA area.  Well that day has finely come. Our current environment has served us well, but...


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: