SQL Server with Mr. Denny:

Development


October 19, 2009  11:00 AM

Hey sysadmins, quit trying to virtualize everything!



Posted by: Denny Cherry
SQL, Virtualization, VMware

Please forward this to the systems admin in your life that wants to take your big SQL Server, and cram it into a Virtual Machine against your wishes. So you've got your kick ass virtualization project moving along nicely, but you've hit a snag.  The DBAs are fighting back saying that they don't...

October 15, 2009  11:00 AM

SQL Server gets an ANSI compliant unique index … sort of



Posted by: Denny Cherry
Index, SQL, T/SQL, Unique Index

If you work with any of the other big database platforms you've probably noticed that SQL Server's implementation of a unique index is "different" than the others.  Until now there hasn't been a way to fix that without using a trigger.  Until now...


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


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: