SQL Server with Mr. Denny:

October, 2011


October 31, 2011  2:00 PM

VMware’s vCenter and SQL Server Database Backups

Denny Cherry Denny Cherry Profile: Denny Cherry

VMware's vCenter system uses SQL Server as it's default database platform.  One thing that needs to be looked into for a lot of VMware installations is the backup setup for the vCenter databases.  Often I find the vCenter databases configured in SIMPLE recovery.  Now this doesn't mean that the...

October 27, 2011  10:20 PM

Learn Storage and Virtualization online

Denny Cherry Denny Cherry Profile: Denny Cherry

Now you as a database professional have the chance to earn Storage and Virtualization from home, work, or where ever is convenient for you.  As a partnership with SSWUG.org I've recorded an 11 session class titled "Storage and...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


October 27, 2011  2:00 PM

Out of office messages, gmail and mailing lists

Denny Cherry Denny Cherry Profile: Denny Cherry

Email is pretty much the most annoying necessary evil out there.  Another annoying necessary evil out there is the out of office message.  Normally these aren't to annoying over all as they let you know that someone that you've sent a message to isn't going to be responding for a while. Where...


October 24, 2011  2:00 PM

Working with replication snapshots to large to fit on your distributor

Denny Cherry Denny Cherry Profile: Denny Cherry

I ran across an interesting problem the other day.  I was setting up replication for a couple of VERY large tables.  These two tables between there are about 553 Gigs in size.  There isn't enough room on the distributor, and there is a slow link between the distribution server and the...


October 20, 2011  2:00 PM

What changing the recovery mode of your vCenter database really means

Denny Cherry Denny Cherry Profile: Denny Cherry

Apparently one of the things that VMware's support department will often recommend that people do is to change the recovery mode of the vCenter database within SQL Server from FULL to SIMPLE recovery because it will magically make a lot of disk problems go away.  While this is true, your disk...


October 17, 2011  9:37 PM

Been to PASS and now you are feeling a little depressed?

Denny Cherry Denny Cherry Profile: Denny Cherry

Going to the PASS summit is an amazing experience as you've probably noticed from all the wrap up posts that you've seen. However the downside to PASS is the sad reality that after the summit has ended you have to get back to normal work and your normal life. But that isn't actually true. You can...


October 17, 2011  2:00 PM

Quick and dirty way to run a batch over and over

Denny Cherry Denny Cherry Profile: Denny Cherry

Everyone has their favorite way or running a block of code over and over again.  If you have to run an entire batch over and over again there is nothing as quick and easy as using the "GO n" syntax.  When you put a number after the GO batch separator SQL Server Management Studio (as well...


October 14, 2011  6:52 PM

Something old, something new, something borrowed, something blue and a Confio umbrella

Denny Cherry Denny Cherry Profile: Denny Cherry

Since I didn't make it to the SQL PASS keynotes this morning, I figured that I'd tell you about another little event that happened late last night.  Last night there was a SQL PASS first.  There was a wedding here at the PASS summit.  Tamera Clark (


October 13, 2011  4:50 PM

SQL PASS 2011 Keynote Day 2

Denny Cherry Denny Cherry Profile: Denny Cherry

Welcome to SQL PASS Summit Keynote on Day 2.  Today was another day of announcements made by Quentin Clark who is the Corporate VP for Microsoft who is in charge of the SQL Server database engine. Quentin started his talk about how SQL Server 2012 will improve the way that SQL Server provides...


October 12, 2011  5:02 PM

SQL PASS Keynote notes

Denny Cherry Denny Cherry Profile: Denny Cherry

Today was Day 1 of the SQL PASS summit.  Today there were a few announcements during the keynotes which if you didn’t see on the live streaming site you probably want to hear about. During the PASS portion of the keynote we also heard about the massive amount of training the the SQL PASS...


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: