SQL Server with Mr. Denny:

SQL


October 13, 2009  9:33 PM

What color should my hair be for #sqlpass?



Posted by: Denny Cherry
In Person Events, PASS, SQL

I posted a survey over on Security Fight Club to get some input from the SQL community.  I need to know what color I should die my hair for SQL PASS.  The survey will be open until shortly...

October 12, 2009  11:00 AM

SQL Upgrades are a one way street.



Posted by: Denny Cherry
SQL, Upgrading

That's right folks.  Once you upgrade SQL Server versions there is no going back. Continued »


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


October 2, 2009  7:14 PM

Join me on Oct 21st for a Clustering with iSCSI Presentation



Posted by: Denny Cherry
Clustering, iSCSI, SQL, Starwind, Webcast

All, On October 21st, 2009 at 11am (Pacific) / 2pm (Eastern) I'm going to be presenting a free Webcast on how to setup a Windows 2008 Cluster when using iSCSI.  Additionally I'll be going over some tuning tricks you can use to improve the performance of your iSCSI network.


October 1, 2009  11:00 AM

HA and DR require the same techniques right?



Posted by: Denny Cherry
Clustering, SQL

While many of the technologies used for HA and DR are similar (or even the same) HA and DR are two different types of events which should be handled differently.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 20, 2009  6:34 PM

Adding column to take taking to long? You’re probably assigning a default.



Posted by: Denny Cherry
SQL

When you create a column on a database, and you put that column on the right of the table the column shouldn't be added almost instantly.  However if you are assigning a default value to the column and setting the column to now allow NULL values the operation will take quite a lot longer.  This...


June 25, 2009  9:00 AM

Setting VMware memory settings to improve SQL Server Performance



Posted by: Denny Cherry
SQL, VMware

There is a VMware setting which you can set which should give you a small but noticeable performance improvement in SQL Server performance when that SQL Server is running within a VMware Virtual Machine.


May 25, 2009  11:00 AM

VMware and SQL and Lock Pages in Memory



Posted by: Denny Cherry
Lock Pages, SQL, VMware

With the recent release of the ability for the Lock Pages in Memory setting to be used on SQL Server 2005 and 2008 Standard Edition I see more and more people shooting them selves in the foot with this setting when running under VMware.  I see this as becoming more of an issue now that this switch...


March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan



Posted by: Denny Cherry
Back To Basics, Execution Plan, Index Performance, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says.  Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...


March 2, 2009  2:43 PM

Standalone SQL Agent Update 3/2/2009



Posted by: Denny Cherry
SQL

I’ve been quiet about the Standalone SQL Agent for a while now.  I haven’t forgotten about the project, in fact I’ve been busily working on it in what little free time I have.  I’ve been working on phase 2 of the project which is adding in the UI to handle job management.  Needless 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: