SQL Server with Mr. Denny:

September, 2009

September 30, 2009  5:27 PM

Slide Deck and Recording from todays webcast

Posted by: Denny Cherry
Virtualization, Webcast

For those that weren't able to join the presentation, I'm posting the slide deck and a recording of the presentation. The slide deck only has a couple of slides in it, so my it self it isn't all...

September 29, 2009  6:26 PM

Join me tomorrow as I talk about virtualization

Posted by: Denny Cherry
PASS, PASS SIG, Virtualization, Webcast

Join me tomorrow September 30th, 2009 as I talk about virtualization with the PASS Virtualization Virtual Chapter.  I'll be presenting my presentation entitled "Diving into Server Virtualization, Deciding if Virtualization is a good choice for your...

Bookmark and Share     3 Comments     RSS Feed     Email a friend

September 28, 2009  11:00 AM

No, I will not do your homework for you

Posted by: Denny Cherry
Social Commentary

If you are a computer science major, or taking a computer class of some sort, then by all means use the Internet for research.  That's what it's there for.  If you've written some code and it's just not working correctly then by app means post your question on a forum (with the code) and ask what...

September 24, 2009  6:40 PM

It takes a big man to admit when you’re wrong.

Posted by: Denny Cherry

It's been pointed out to me just how screwed up yesterdays post was.  I'm a big boy, I can admin it when I muck something up, especially something that...

September 24, 2009  11:00 AM

Understanding what the WITH ROLLBACK IMMEDIATE does

Posted by: Denny Cherry

Based on some questions on forums and some of the responses that people have been giving there appears to be done misunderstanding about what the WITH ROLLBACK IMMEDIATE option does when added to the ALTER DATABASE command.  My goal here is to try and clear up at least some of the confusion.

September 21, 2009  11:00 AM

DENY overwrites GRANT, most of the time

Posted by: Denny Cherry

SQL Server rights are pretty easy to work with most of the time.  You grant a bunch of rights to an object, then you deny rights to those objects and the user looses the rights.  Pretty easy.  Now the catch is that if you use the fixed database roles, those roles overwrite any denies that are in...

September 17, 2009  11:00 AM

Dates can easily be the hardest datatype to work with.

Posted by: Denny Cherry
Index Performance, Index Scan, Index Seek, Indexing, T/SQL

The datetime data type can be one of the hardest to work with when it comes to index optimization.  Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value.  Most people handle this via a convert function around the date...

September 14, 2009  5:24 PM

SQL Server Clustering Guide & Webcast Links

Posted by: Denny Cherry
iSCSI, SQL Server 2008, Starwind, Webcast

A white paper which I wrote for Starwind Software is now available.  The link to register for the webcast (October 21, 2009) has also been

Bookmark and Share     0 Comments     RSS Feed     Email a friend

September 14, 2009  11:00 AM

My experiences upgrading ESX 3.5 to vSphere 4.0

Posted by: Denny Cherry

A couple of weeks back I begun the process of upgrading our VMware ESX 3.5 systems to vSphere 4.0.  I've got to tell you, that has to be the easiest system upgrade process in history.

September 11, 2009  11:16 PM

Next weeks webcast has been rescheduled.

Posted by: Denny Cherry
Starwind, Webcast

I was going to be doing a webcast next week on September 16th, 2008 on Clustering SQL Server 2008 over iSCSI.  Due to some scheduling issues we've had to reschedule the presentation for October 21, 2009 at 2pm (Eastern) / 11am (Pacific). 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: