SQL Server with Mr. Denny:

March, 2009


March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan

Denny Cherry Denny Cherry Profile: Denny Cherry

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 11, 2009  9:05 PM

What the hell is wrong with people?

Denny Cherry Denny Cherry Profile: Denny Cherry

I ran across the post A Culture of (Potential) Assholes: Sexual Harassment in IT on twitter today, and all I could think was "What the hell is wrong with people?" Before I go on, I'd like to go...


March 9, 2009  11:00 AM

Handy script for use when looking at blocking

Denny Cherry Denny Cherry Profile: Denny Cherry

A while back I was looking at a clients database and we were looking at why the ASPState database was having blocking issues.  So I through this script together to show not only the blocked processes, but also the blocking processes, but also include the name of the stored procedure as well as the...


March 8, 2009  2:20 AM

Developing a SQL Server Database Backup Plan

Denny Cherry Denny Cherry Profile: Denny Cherry

Last week I published a new article on Enterprise IT Planet called "Developing a SQL Server Database Backup Plan" in which I go...


March 7, 2009  6:20 AM

SoCal Coffee and Code was a success

Denny Cherry Denny Cherry Profile: Denny Cherry

I would have to say that the first SoCal Coffee and Code was a hit.  Only a few people came, but I wasn't sure if any were going to show, so fora  first event I'd say that a few is a success. Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 5, 2009  11:00 AM

Coffee And Code in Irvine Tomorrow

Denny Cherry Denny Cherry Profile: Denny Cherry

Don't forget tomorrow (Friday the 6th) is our first Coffee and Code in the SoCal area (at least the first that I know of). We’ll be at the Starbucks at the Tustin Market place (2959 El Camino Real


March 5, 2009  10:59 AM

Steps to Troubleshoot Connections to your SQL Server

Denny Cherry Denny Cherry Profile: Denny Cherry

People ask all the time why they can't connect to their SQL Server. Here are some thoubleshooting steps that they should take in order to find out what the problem is. Please keep in mind that without knowledge of your specific problem I can only point you towards the right direction.


March 3, 2009  7:02 PM

Photo’s from last night

Denny Cherry Denny Cherry Profile: Denny Cherry

A couple of people have posted pictures from last night. So far I've run across which Andrew Karcher and I were both in. Thanks to Pinal Dave for posting...


March 2, 2009  2:43 PM

Standalone SQL Agent Update 3/2/2009

Denny Cherry Denny Cherry Profile: Denny Cherry

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


March 2, 2009  9:00 AM

FREE Seminar: Spend a Day with the Experts – Aliso Viejo, CA

Denny Cherry Denny Cherry Profile: Denny Cherry

Quest has put together a one day free seminar at the Quest Software office on Friday March 13, 2009. Brent Ozar and myself will be presenting several presentations on SQL Server 2008. For more information and to register for the event visit


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: