SQL Server with Mr. Denny:

Microsoft Windows


June 3, 2010  11:00 AM

Getting EMC Navisphere working on x64



Posted by: Denny Cherry
EMC, Windows 7

So a while back I got a new laptop and also upgraded by desktop from Windows 7 32bit to Windows 7 64bit.  Everything worked great, but there was one thing which took me some time to get...

May 6, 2010  11:00 AM

If you change the default instances port number, you may not be able to connect



Posted by: Denny Cherry
Microsoft CSS, SQL Server

Something that some companies like to do is to change the port number that the default instance is listening under as a security precaution.  However this has a habit of stopping anyone from connecting to the default instance without knowing the port number. This is because the default instance...


March 29, 2010  11:00 AM

So I was installing SQL 2008 CU6 for SP1 the other day…



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

God that sounds boring doesn't it. Anyway, I was installing SQL 2008 CU 6 for SP 1 the other day and I was greeted with the dreaded "some process is running which will cause your SQL Server to reboot after install" screen.  The app which was running was fshost.exe which is part of the Full Text...


March 9, 2010  8:00 PM

IO, IO, It’s Off To Disk We Go! #TSQL2sDay



Posted by: Denny Cherry
Microsoft Windows, Performance Problems, SQL Server, Storage, TSQL2sDay

So today is #TSQL2sDay, and this months topic is Disk IO.  Storage is something I love working in, so I figured why not, I'll post something. Hopefully everyone knows that your storage solution is the most critical when it...


February 15, 2010  11:00 AM

Dealing with a digital “chicken or the egg” situation.



Posted by: Denny Cherry
Cisco VPN, Windows 7

Recently I had the opportunity to upgrade my computer desktop from 2 Gigs of RAM to 8 Gigs of RAM.  This required that I reinstall Windows 7 to replace by 32bit OS with a 64bit OS. This presented me with a problem as I work from home full time and I have to VPN in.  You see we use a Cisco VPN...


January 4, 2010  11:00 AM

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



Posted by: Denny Cherry
Clustering, Microsoft Cluster Service

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


November 23, 2009  11:00 AM

Moving a standalone instance to a cluster while keeping the name and IP



Posted by: Denny Cherry
Clustering, Migration, SQL

A little while back I posted about how to move a standalone instance to a clustered instance using a different name and IP, but what do you do when you...


October 27, 2009  11:00 AM

The Windows 7, Windows 2008 R2, Exchange 2010 launch was more informative that I thought



Posted by: Denny Cherry
Exchange 2010, Windows 2008 R2, Windows 7

Yesterday was the Windows 7, Windows 2008 R2, Exchange 2010 launch event here in Southern California (Orange County to be specific, Burbank is on Wednesday).  For the most part I was planning on going to pick up a couple of tidbits of information, and a free copy on Windows 7 Ultimate (I'm not...


October 26, 2009  11:00 AM

I’ve got some money for an upgrade, what should I upgrade?



Posted by: Denny Cherry
RAM, Server Hardware, SQL

So you are going along your normal day, and your boss comes up to you and tells you "We've got a few thousand bucks left in this years budget, what would you like to upgrade?"  Assuming that new 26" monitors for your workstation are out of the question, the boss is probably talking about a server...


October 5, 2009  11:00 AM

SQL 2005 SP3 Failing to install with password length error



Posted by: Denny Cherry
Installation, SQL, SQL Server 2005

When installing SQL Server 2005 SP3 you may get an error about the password being to short, and it may have nothing to do with your sa password.  It's because the Install Scripts are trying to create a certificate with a password which doesn't meet your domain's password requirements. If 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: