SQL Server with Mr. Denny:

Microsoft Windows


May 28, 2012  2:00 PM

Figuring out how log shipping is doing



Posted by: Denny Cherry
Backup & recovery, Log Shipping, Migration, Restore Database, SQL Server

A lot of the time when doing data center migrations or system migrations I end up using Transaction Log Shipping to get the data from one SQL Server to another.  I do this for a few reasons.

  1. It's reliable.
  2. It's easy to do (I've got plenty of scripts sitting around to...

May 14, 2012  2:00 PM

Be careful which node you install a clustered instance from



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

While installing a clustered SQL Server instance recently I ran across a bit of an annoyance.  When I was going through the SQL Installation process I didn't pay any attention to which node of the cluster currently owned all the disks that I was planning on using for SQL Server.  Because of this...


December 22, 2011  2:00 PM

Fragmentation may cause corruption



Posted by: Denny Cherry
Microsoft CSS, SQL Server

Let me start this off by saying that I chose the title of this blog post very carefully.  You'll note that it says "fragmentation may cause corruption" not that it will cause corruption, so before you go saying "Denny says that if you have any fragmentation of the database it'll become...


December 1, 2011  2:00 PM

When learning database design, be careful where you learn from



Posted by: Denny Cherry
Database Design, SharePoint, Social Commentary, SQL Server

Every year we have new people joining our ranks as database professionals.  Many of these new people use systems at the places which they already work as the source of their learning when it comes to database design and data modeling.  However this isn't always the best idea unless the systems...


September 8, 2011  7:53 PM

24HOP: BI Workload Follow-Up



Posted by: Denny Cherry
24 HoP, Integration Services, Performance, RAM, SQL PASS, SQL Server, SSIS, Stacia Misner

This is a total repost of Stacia's blog post from this morning so that hopefully everyone will see it.  So pretend that Stacia wrote this and that I didn't.

Yesterday,...


October 25, 2010  11:00 AM

Being a great DBA means knowing more than just SQL Server



Posted by: Denny Cherry
SQL Server, Windows 2008 R2, Windows 7

Sometimes a project comes around that requires knowledge beyond the normal SQL Server knowledge. This is where having the extra knowledge can really make you standout.  Recently I was talking to Allen Kinsel (blog |


October 18, 2010  11:00 AM

Installing Cisco Fabric Manager on Windows 7 x64



Posted by: Denny Cherry
Storage, Windows 7

So you want to install Cisco Fabric Manager and/or Cisco Device Manager on a Windows 7 x64 computer.  Awesome, good for you.  Unfortunately like x64 VPN Cisco has in their infinite wisdom not released an x64 version of the Fabric Manger or Device Manager.  This makes installing under x64 a lot...


September 15, 2010  11:00 AM

Talking to the SoCal .NET Architecture User Group about SQL Server Basics



Posted by: Denny Cherry
SQL Server, Windows 7

Later this week on September 16, 2010 I'll be going and visiting the SoCal .NET Architecture User Group in Santa Ana, CA.  In this presentation we'll be going back to the basics of SQL Server and focusing on the basic T/SQL DML statements, and object creation as without a good foundation to build...


July 6, 2010  11:00 AM

The Windows 7 book that I worked on has finely arrived.



Posted by: Denny Cherry
Book, Windows 7

A while back I was asked to pick up a chapter in a Windows 7 book.  It took a while to get my copy of the book, but it has finely shown up.  The book is titled "


June 17, 2010  11:00 AM

Configuring Blackberry Wireless Sync with 64bit Outlook



Posted by: Denny Cherry
Blackberry, RIM, Windows 7

With the release of Office 2010 uses of Blackberrys have a new problem to deal with.  The blackberry desktop manager software which you install on your computer is only a 32bit application, so if you install the 64bit version of Outlook (or Office) then the Blackberry desktop manager can't talk to...


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: