SQL Server with Mr. Denny:

Microsoft Windows


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

August 26, 2009  3:34 PM

Clearing the Windows page file and its effect on server performance



Posted by: Denny Cherry
Article, Microsoft Windows, Page File, SearchSQLServer.com

I just published a new article over on SearchSQLServer.com about "Clearing the Windows page file and its effect on server...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 3, 2009  11:00 AM

Single Instance vs Multiple Instances



Posted by: Denny Cherry
Instance, Multiple Instance Configuration, RAM, SQL Server, TempDB

I see this question quite a bit, should I use a single instance or one instance per application database on my server. Continued »


July 29, 2009  7:50 PM

Windows 2008, where oh where has all my drive space gone?



Posted by: Denny Cherry
Space, WER, Windows 2008, Windows Error Reporting

If you are using Windows 2008, you may be like me.  Wondering where the hell all this drive space is disapearing to. Continued »


July 13, 2009  11:00 AM

Windows 2008 C Drive doesn’t always extend correctly



Posted by: Denny Cherry
Diskpart, Virtualization, Windows 2008

When using VMs and Windows 2008 you have the ability to easily grow the C drive on your servers. This makes it much easier to assign only the space needed to the C drive of your servers saving you a ton of space. However I recently had a few machines say that the disk was extanded in Computer...


July 2, 2009  11:00 AM

When clustering SQL 2008, SQL Server may reject the Key



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

When installing SQL Server 2008 Enterprise onto my new SQL Cluster I downloaded the media from Microsoft and dropped it onto a network share and installed it.  The first node went perfectly, the second node, not so much.  When I went to install on the second node I would get to the screen which...


May 14, 2009  11:00 AM

Outside Queue to SSB adapter



Posted by: Denny Cherry
MSMQ, Open Source, Outside Queue to SSB Adapter, Service Broker

Something that I think that Microsoft should include with the SQL Service Broker is an adapter so that MSMQ messages (and other messaging systems as well) will flow automatically into the SQL Service Broker.  Since Microsoft hasn't gotten around to writing one I'm going to start. It shouldn't...


April 26, 2009  5:29 AM

SQL Server Standard Edition getting Lock Pages in Memory



Posted by: Denny Cherry
Bob Ward, Bug, Lock Pages, Microsoft CSS, SQL Server 2005, SQL Server 2008

Microsoft SQL Server 2005 and 2008 Standard edition will be getting the Lock Pages in Memory feature that SQL Server Enterprise Edition has had starting in SQL Server 2005.  This was announced by Bob Ward via the


March 30, 2009  7:45 PM

SQL 2008 Clusters require treaking to make SQL Dumpter work



Posted by: Denny Cherry
Microsoft CSS, SQL Dumper, SQL Server 2008

If you don't already read the CSS teams blog, I suggest that you do.  A little while ago they posted a blog post about how the


February 28, 2009  12:21 AM

WebEx and Windows 7



Posted by: Denny Cherry
WebEx, Windows 7

Apparently WebEx and Windows 7 doesn't play nice very well. I have been working from home recently and normally I just RDP into my workstation at the office.  Today I was working with Quest Tech Support and they setup a WebEx session for me.  When I fired it up on my workstation (like I've...