SQL Server with Mr. Denny:

July, 2011


July 28, 2011  2:00 PM

HA vs DR, what’s it all mean



Posted by: Denny Cherry
AlwaysOn, DR, SQL Server, SQL Server 11, Storage

People often get HA (High Availability) and DR (Disaster Recovery) mixed up.  There are a couple of reasons that this happens.  First is the fact that there aren’t any clear guidelines which separate the two.  There are standard terms which are used to help define HA and DR, but there’s...

July 25, 2011  2:00 PM

Any testing on the effect of Hiding NX/XD flag from guest with SQL Server on ESX?



Posted by: Denny Cherry
SQL Server, Virtual Chapter, Virtualization, VMware

During the webcast which I did for the SQL PASS Virtulization Virtual Chapter on July 13th, 2011 a question came up that I didn't have the answer for.  The question was if I had done "Any testing on the effect of Hiding NX/XD flag from guest with SQL Server  on ESX?".  I hadn't done any testing...


July 19, 2011  2:00 PM

Want to try out Windows Azure for free for 30 days?



Posted by: Denny Cherry
Azure, SQL Server

If you've been wanting to try out Windows Azure and haven't been able to yet, now is the time.  I've been given an access code that you can use which will give you 30 days of full Windows / SQL Azure for free.  And the best part is there is no credit card required.  Just drop in the code on sign...


July 18, 2011  2:00 PM

Interview with our new whipping boy Adrian Bethune



Posted by: Denny Cherry
DACPAC, Interview

While at Tech Ed 2011 I spent a good amount of time talking with Adrian Bethune (@canon_sense) who is the new product manager for SQL Server Manageability, originally hired onto the team by the magnificent Dan Jones (


July 14, 2011  6:33 PM

Updated SSMS Shortcut Key file



Posted by: Denny Cherry
Shortcut Keys, SQL Server, SQL Server 2012, SQL Server Management Studio

I've updated the SQL Server "Denali" settings file to include the CTRL+E and CTRL+X hot keys.  You can find the new file in the same location as the old one so you only need to download it once. Denny


July 14, 2011  2:56 AM

Resetting SSMS shortcut keys in SQL Server “Denali” CTP 3



Posted by: Denny Cherry
Hot Keys, Shortcut Keys, SQL Server, SQL Server 2012, SQL Server Management Studio

If you did what I did when you installed CTP 3 of SQL Server "Denali" (which happened when I uninstalled CTP 1 then installed CTP 3) you'll be in for a rude surprise, a lot of your shortcut keys that you've been using for years don't work any more.  This is to say the least VERY annoying, and...


July 12, 2011  2:00 PM

Database %d was shutdown due to error 9002 in routine ‘HeapPageRef::Update’.



Posted by: Denny Cherry
SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

So I hit the error in the title the other night while converting a heap to a clustered index on a production system.  After this error poped up, some other nasty stuff showed up in the error log, which I've included below.

Error: 9002, Severity: 17, State: 4. The transaction log for...


July 11, 2011  2:00 PM

Transaction log growth best practices



Posted by: Denny Cherry
SQL Server, Transaction Log

There is a lot of talk online about transaction log growth and what you should do. There are two answers to this question, and in this post I'll give you both answers. The theoretical answer is that you want to grow your transaction logs in 8 gig chunks. This will maximize the amount of space...


July 7, 2011  2:00 PM

How HyperBac worked for me



Posted by: Denny Cherry
Backup & recovery

I recently installed HyperBac on a clients SQL Server to reduce the amount of space needed to store their backups.  Specifically we were looking to reduce the amount of space the log backups took, but I was curious to see how much space the full backups would be reduced by. The full backups...


July 5, 2011  2:00 PM

What does WITH (NOLOCK) actually mean



Posted by: Denny Cherry
Lock Pages

Contrary to popular belief WITH (NOLOCK) isn’t actually the SQL Server “Turbo” button.  While it may appear that way, there’s actually some stuff going on in the back that makes it look this way.  Understanding what is happening is critical to using WITH (NOLOCK) correctly. When you...


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: