SQL Server with Mr. Denny:

December, 2009


December 31, 2009  11:00 AM

Happy New Year

Posted by: Denny Cherry

No tech blog post today. I just want to wish everyone a happy new year. Denny

December 28, 2009  11:00 AM

How to convert a standalone instance to a clustered instance

Posted by: Denny Cherry
Clustering, SQL

This question has come up a couple of times on various forums on the Inter-webs so I figured I'd write up something a little more in-depth than I'd be able to do on a forum. There's no way to easily flip a standalone SQL Server instance to a clustered instance.  However moving a standalone...

December 24, 2009  11:00 AM

Windows 2008 R2 Core mode has some great changes

Posted by: Denny Cherry
Windows 2008 R2

Windows 2008 introduced us to code mode.  It was great, an ultra thin server OS, with little overhead as there's no UI.  It was as awesome improvement to Windows, unless you actually wanted to use any other Microsoft technologies.  There's no .NET support so you couldn't run .NET services, or...

December 21, 2009  11:00 AM

Windows 2008 R2 Management

Posted by: Denny Cherry
Windows 2008 R2

When I was at the Windows 2008 R2 release there was a ton of new information that was talked about.  There are all new management tools for Windows 2008 R2.  In fact there is an all new methology within Microsoft when it comes to building the management tools.

December 17, 2009  11:00 AM

CXPacket isn’t the cause, it is a symptom

Posted by: Denny Cherry

All to often when people deal with parallel queries they see that some threads of the query have a wait type of CXPacket so they assume that the parallel execution plan is causing a problem, but it probably isn’t.

December 14, 2009  11:00 AM

Beware of Diskeeper 10 on your servers

Posted by: Denny Cherry
SQL, Testing

Everyone likes nice defragmented SQL Servers.  However if you use Diskeeper to do so be very careful before you upgrade to the new version 10, or if you are going to upgrade to the new version 10 you’ll need to make a small change to your configuration on each SQL Server.

December 10, 2009  11:00 AM

Transaction Log files are not safe to delete

Posted by: Denny Cherry
Recovery, SQL

All to often I see people online saying that they detach a database then delete the log file to shrink it.  This is a very dangerous operation which can leave you with a corrupt database that you can't do anything with.

December 7, 2009  11:00 AM

What you can and can’t do with SAN replication

Posted by: Denny Cherry

SAN replication is a very power tool which will let you get real time (or near real time) backups of your database on another location on your storage array, to another storage array at the local site, or to a remote storage array at another site. However like all technologies there are some...

December 3, 2009  11:00 AM

Dual HBAs (or iSCSI ports) should be a requirement for every server

Posted by: Denny Cherry
iSCSI, Storage

Proper network design is very important to ensuring the highest availability between your storage array and your server.  This design is important weither you are using a Fibre Channel SAN or an iSCSI SAN.  The basic design is the same.


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: