SQL Server with Mr. Denny

January 7, 2010  11:00 AM

Not everything needs a public IP address.

Denny Cherry Denny Cherry Profile: Denny Cherry

For those of you in bigger shops you can probably ignore this.  If you work in a smaller shop where everything in the datacenter has a public IP, this post is for you.

Continued »

January 4, 2010  11:00 AM

When setting up a new Windows Cluster test failover before releasing to production

Denny Cherry Denny Cherry Profile: Denny Cherry

When you build a new Microsoft Cluster Server cluster always be sure to fail over all the drives between all the nodes before installing SQL Server on it and deploying the cluster to production.  The first time that you fail over a cluster from one node to another the disks can take a very long time to fail over.

If you don’t test this fail over ahead of time your first production fail over could be quite a bit longer than you expect.  Granted I’m only talked 30-60 seconds longer than expected, but your are clustering the SQL Server for the most possible uptime, and 30-60 extra seconds could be a big problem.

Do in other words test, then deploy.


December 31, 2009  11:00 AM

Happy New Year

Denny Cherry Denny Cherry Profile: Denny Cherry

No tech blog post today.

I just want to wish everyone a happy new year.


December 28, 2009  11:00 AM

How to convert a standalone instance to a clustered instance

Denny Cherry Denny Cherry Profile: Denny Cherry

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 instance into a clustered instance isn’t that tough, but it will require some down time to the clients. Continued »

December 24, 2009  11:00 AM

Windows 2008 R2 Core mode has some great changes

Denny Cherry Denny Cherry Profile: Denny Cherry

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 ASP.NET websites.  You couldn’t install SQL Server, or Exchange.  If you wanted classic ASP, or PHP then you were set.  Pretty must the only real use for these was as as domain controllers and other infrastructure users.

Windows 2008 R2 core mode is actually useful. Continued »

December 21, 2009  11:00 AM

Windows 2008 R2 Management

Denny Cherry Denny Cherry Profile: Denny Cherry

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.

Continued »

December 17, 2009  11:00 AM

CXPacket isn’t the cause, it is a symptom

Denny Cherry Denny Cherry Profile: 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.

Continued »

December 14, 2009  11:00 AM

Beware of Diskeeper 10 on your servers

Denny Cherry Denny Cherry Profile: Denny Cherry

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.

Continued »

December 10, 2009  11:00 AM

Transaction Log files are not safe to delete

Denny Cherry Denny Cherry Profile: Denny Cherry

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. Continued »

December 7, 2009  11:00 AM

What you can and can’t do with SAN replication

Denny Cherry Denny Cherry Profile: 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 things which it is really good at, and some things which it can’t/shouldn’t be used for.  (Everything here is going to be SAN vendor dependent.  This includes features, modules you have to buy, terminology, and probably some other stuff I’m not thinking of.) Continued »

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: