SQL Server with Mr. Denny:

SQL Server


April 18, 2012  8:30 AM

Storage and Virtualization in Poland May 24



Posted by: Denny Cherry
In Person Events, SQL Server

Come and join me in Poland, May 24th, 2012 (24-05-2012) at SQL Day 2012.  During this day long session we will be looking at storage and virtualization from a...

April 16, 2012  2:00 PM

SQL Saturday 111 Slide Decks



Posted by: Denny Cherry
In Person Events, SQL Saturday, SQL Server

I've uploaded my slide decks from SQL Saturday 111. The sessions can be found on the session pages for the two sessions. I gave two sessions at SQL Saturday 111 in Atlanta, GA. The first was


April 12, 2012  2:00 PM

CPU Affinity Mask and virtualizating SQL Servers



Posted by: Denny Cherry
Error Message, Grant Fritchey, Hyper-V, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2

If you have physical SQL Servers that you plan on moving into a virtual environment you'll want to double check your affinity mask settings before actually moving the machine from a physical server to a VM when using P2V software.  The reason for this is that if the affinity mask is set for...


April 9, 2012  5:06 PM

Upgrading MS Ops Manager & SQL Server



Posted by: Denny Cherry
Error 29112, MERGE statement, Microsoft Operations Manager, Microsoft System Center, OperationsManager, OperationsManagerDW, SQL Server, SQL Server 2005, SQL Server 2008 R2, System Center Management Configuration Service

Something which has come up when upgrading Microsoft Operations Manager 2007 to 2012 is that there is an extra step which isn't really documented in the Ops Manager upgrade guide.  You see when upgrading from Ops Manager 2007 to 2012 you also need to upgrade the SQL Server to SQL Server 2008 R2 as...


April 4, 2012  2:00 PM

Now is the time to update DR plans



Posted by: Denny Cherry
Distaster Recovery, SQL Server

Many companies today came pretty close to needing to implement their DR plans yesterday, and many of them probably didn't even realize it.  In case you didn't see what was going on in the Dallas area yesterday there was massive hail and several tornado's toucheing down in the area.  The Dallas...


April 2, 2012  2:00 PM

My First #sqlbits Experience



Posted by: Denny Cherry
Buck Woody, SQL Bits, SQL Server, Stacia Misner

So I arrived home from my first SQL Bits conference, which was the 10th SQL Bits event (they do two a year).  I've got to say that I had a great time at the conference.  SQL Bits, if you aren't away is a three day event with the first day (Thursday) being all...


March 29, 2012  2:00 PM

SQL Server Replication and DR



Posted by: Denny Cherry
Distaster Recovery, Replication, SQL Server

Every once and a while people ask me if they should use SQL Server Replication to get data to a DR site.  And typically to them my answer is "probably not".  The reason that I say that is for a couple of reasons. 1. If there are triggers on your tables, replication doesn't have a way to ensure...


March 26, 2012  2:00 PM

Want to know the quickest way to get your recruiting email deleted?



Posted by: Denny Cherry
Interview, Social Commentary, SQL Server

We all get emails from recruiters.  I know that I'm shocked on a day that I don't get them.  Personally I love reading these emails as they are usually pretty damn funny.  But I'm seeing a very disturbing trend in these emails.  This trend is making job candidates pay to attend out of town job...


March 22, 2012  2:00 PM

How I use sp_whoisactive and sp_who3



Posted by: Denny Cherry
Performance Problems, sp_who3, SQL Server, Troubleshooting

On occasion I'm asked to come and look into some SQL performance problems on systems.  Normally when I'm doing this the customer doesn't have any third party tools installed and they are actively having problems, and these problems are leading to lost revenue or at least really pissed off...


March 19, 2012  2:00 PM

Windows 8 Boots With No Network



Posted by: Denny Cherry
Beta, Networking, SQL Server, Windows 8

So I've run into a bit of a strange issue with Windows 8 on my laptop that I wanted to share in case anyone else runs into the same problem.  My basic problem is that about 50% of the time when my laptop boots up into Windows 8 it can't find the network.  I know that the WiFi card is working...


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: