SQL Server with Mr. Denny:

October, 2009


October 31, 2009  11:17 PM

My #sqlpass schedule



Posted by: Denny Cherry
In Person Events, PASS

For those lucky enough to be attending the SQL PASS summit this year in Seattle, WA I'll be there to.  This is my third year in a row attending, and my first year speaking.  Over the course of the week I've got a bunch of planned things which I'll be doing.  Hopefully you'll look me up at one...

October 29, 2009  11:00 AM

Auto shrink is just pure evil



Posted by: Denny Cherry
SQL

If you don't agree with the above statement please keep reading.  I'm write, and it's important, I promise. In order for the auto-shrink feature to be really effective it has to move data from the end of the file to the middle/front of the file so that it can chop off the tail end of the...


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 23, 2009  11:00 AM

#sqlpass hair color voting ends tonight! Cast your vote before it’s too late.



Posted by: Denny Cherry
Hair Dye, In Person Events, PASS

That's right, the second most important vote of this years SQL PASS Summit (with the elections being the most important); the color of my hair is closing tonight. Currently (I'm writing this...


October 22, 2009  10:25 PM

This isn’t your grand-mothers bingo game (#sqlbingo)



Posted by: Denny Cherry
Bingo, In Person Events, PASS, Quest Software, SQLServerPedia.com, Twitter

This year at the PASS Summit there will be a daily bingo game.  This isn't the standard sit in a room while someone calls out numbers.  No you have to find the people who's names and faces (for the most part) are on the bingo...

Bookmark and Share     2 Comments     RSS Feed     Email a friend


October 22, 2009  11:00 AM

How do you know when it’s time to refactor that database design?



Posted by: Denny Cherry
Social Commentary, SQL

Software developers love re-factoring code.  And why shouldn't they.  It's quick (sometimes) and when done correctly it'll reduce the amount of code, and speed up application response time.  DBAs like re-factoring code as well.  We get the same benefits when done correctly.  Re-factoring the...


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 15, 2009  7:06 AM

The polished turd that is Dell’s Gold Level Support department really isn’t all that supporting



Posted by: Denny Cherry
IIS 7, Windows 2008

If you follow me on twitter then you've heard bits and pieces of this already on my twitter stream. In preparation for the onslaught of security patches which were released on October 14, 2009 I went ahead and patched all our severs the...


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: