SQL Server with Mr. Denny:

October, 2011


October 31, 2011  2:00 PM

VMware’s vCenter and SQL Server Database Backups



Posted by: Denny Cherry
Backup & recovery, SQL Server, vCenter, VMware

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



Posted by: Denny Cherry
Hyper-V, SQL Server, SSWUG, Storage, Virtualization, VMware

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



Posted by: Denny Cherry
MVP Summit, Social Commentary, SQL PASS

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



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

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



Posted by: Denny Cherry
Recovery, vCenter, VMware

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?



Posted by: Denny Cherry
PASS, SQL PASS, SQL PASS 2011, SQL Server

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



Posted by: Denny Cherry
SQL Server, T/SQL

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



Posted by: Denny Cherry
Confio, Kerry Tyler, Pat Wright, SQL PASS, SQL PASS 2011, Tamara Clark

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



Posted by: Denny Cherry
Keynotes, PASS, SQL PASS, SQL PASS 2011, SQL Server

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



Posted by: Denny Cherry
Azure, SQL PASS, SQL PASS 2011, SQL Server, SQL Server 2012, SQL Server MVP Deep Dives Volume 2

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: